Data_Control/AddEquiDB.cs

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

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

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


namespace Data_Control
{
    public class AddEquiDB:EquipmentDBConnection 
    {
        //获得连接对象
        public SqlConnection GetConn()
        {
            SqlConnection conn = new SqlConnection();
            conn = this.GetEquipmentConnStr();
            return conn;

        }
        
        /// <summary>
        /// 添加设备基础信息
        /// </summary>
        /// <param name="A">ArrayList类型的设备基础信息数组</param>
        public void Add_Sb_info(ArrayList  A)
        {
            using (SqlConnection conn = this.GetEquipmentConnStr())
            {
                //String SQL = "insert into Equipment(DepartmentID,DepartmentName,EquiStyleID,EquiSortID," +
                //    "Status,UsePerson,EquiModel,Factory,LeaveFactoryDate,UseDate,StockDate,Price,AssetsID,WritePerson,Remark)" +
                //    "values(" + A[0] + "," + A[1] + "," + A[2] + "," + A[3] + "," + A[4] + "," + A[5] + "," + A[6] + "," + A[7] + "," + A[8] + ",'" + A[9] + "','" + A[10] + "','" + A[11] + "','" + A[12] + "','" + A[13] + "','" + A[14] + "')";

                //SqlConnection conn = this.GetConn();
                //conn.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = conn;
                cmd.CommandText = "AddEquipment";
                cmd.CommandType = CommandType.StoredProcedure;
                SqlParameter paramDepartmentID = new SqlParameter("@departmentID", A[0]);
                cmd.Parameters.Add(paramDepartmentID);
                SqlParameter paramDepartmentName = new SqlParameter("@departmentName", A[1]);
                cmd.Parameters.Add(paramDepartmentName);
                SqlParameter paramEquiStyleID = new SqlParameter("@equiStyleID", A[2]);
                cmd.Parameters.Add(paramEquiStyleID);
                SqlParameter paramEquiSortID = new SqlParameter("@equiSortID", A[3]);
                cmd.Parameters.Add(paramEquiSortID);
                SqlParameter paramStatus = new SqlParameter("@status", A[4]);
                cmd.Parameters.Add(paramStatus);
                SqlParameter paramUsePerson = new SqlParameter("@usePerson", A[5]);
                cmd.Parameters.Add(paramUsePerson);
                SqlParameter paramEquiModel = new SqlParameter("@equiModel", A[6]);
                cmd.Parameters.Add(paramEquiModel);
                SqlParameter paramFactory = new SqlParameter("@factory", A[7]);
                cmd.Parameters.Add(paramFactory);
                SqlParameter paramLeaveFactoryDate = new SqlParameter("@leaveFactoryDate", A[8]);
                cmd.Parameters.Add(paramLeaveFactoryDate);
                SqlParameter paramUseDate = new SqlParameter("@useDate", A[9]);
                cmd.Parameters.Add(paramUseDate);