Data_Control/sbgl_add.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Data_Access;

namespace Data_Control
{
    public  class sbgl_add:EquipmentDBConnection 
    {
        /// <summary>
        /// 添加设备维修信息
        /// </summary>
        /// <param name="A">ArrayList类型的设备维修信息数组</param>
        public void Add_Sbwx_info(ArrayList A)
        {
            using (SqlConnection conn = this.GetEquipmentConnStr())
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = conn;
                cmd.CommandText = "AddServiceInfo";
                cmd.CommandType = CommandType.StoredProcedure;
                SqlParameter paraEquipmentID=new SqlParameter ("@equipmentID",A[0]);
                cmd.Parameters.Add(paraEquipmentID);
                SqlParameter paraServicePerson = new SqlParameter("@servicePerson", A[1]);
                cmd.Parameters.Add(paraServicePerson);
                SqlParameter paraServiceTime = new SqlParameter("@serviceTime", A[2]);
                cmd.Parameters.Add(paraServiceTime);
                SqlParameter paraServiceFare = new SqlParameter("@serviceFare", A[3]);
                cmd.Parameters.Add(paraServiceFare);
                SqlParameter paraFailureReason = new SqlParameter("@failureReason", A[4]);
                cmd.Parameters.Add(paraFailureReason);
                SqlParameter paraBeginDate = new SqlParameter("@beginDate", A[5]);
                cmd.Parameters.Add(paraBeginDate);
                SqlParameter paraFinishDate = new SqlParameter("@finishDate", A[6]);
                cmd.Parameters.Add(paraFinishDate);
                SqlParameter paraRemark = new SqlParameter("@remark", A[7]);
                cmd.Parameters.Add(paraRemark);
                conn.Open();
                cmd.ExecuteNonQuery();
                conn.Close();
            }
        }

        /// <summary>
        /// 添加设备运行信息
        /// </summary>
        /// <param name="A">ArrayList类型的设备运行信息数组</param>
        public void Add_Sb_Db(ArrayList A)
        {
            using (SqlConnection conn = this.GetEquipmentConnStr())
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = conn;
                cmd.CommandText = "AddEquiChange";
                cmd.CommandType = CommandType.StoredProcedure;

                SqlParameter paraEquipmentID = new SqlParameter("@equipmentID", A[0]);