WELOA.DAL/Equipment/sb_lossDAO.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using WELOA.Model;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using LSDAL_SQL;

namespace SBDAL_SQL
{
    public class sb_lossDAO
    {
        
        private DateSetInformation dsinfo = new DateSetInformation();
        private ls_exception exlog = new ls_exception();
        private sb_lendDAO lendDAO = new sb_lendDAO();
        private Polytechnic trinfo = new Polytechnic();

        
        public Polytechnic del_Loss(int nId)
        {
            this.trinfo.rowsnum = -1;
            this.trinfo.nException = -1;
            using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["lsstring"].ConnectionString))
            {
                SqlCommand command = connection.CreateCommand();
                command.CommandType = CommandType.Text;
                command.CommandText = "DELETE sb_loss WHERE id=@id ";
                command.Parameters.AddWithValue("@id", nId);
                try
                {
                    if (connection.State == ConnectionState.Closed)
                    {
                        connection.Open();
                    }
                    this.trinfo.rowsnum = command.ExecuteNonQuery();
                }
                catch (Exception exception)
                {
                    this.exlog.insexception("sb_lossDAO.cs del_Loss", exception.Message);
                    this.trinfo.nException = 1;
                    return this.trinfo;
                }
            }
            return this.trinfo;
        }

        public Polytechnic ins_Loss_Manager(string strDevicenumber, string strDevicename, string strCategories, string strType, string strConfiguration, string strUnit, int nLossnumber, string strLosscause, string strLossnote, string strApplicantkinds, string strLossapplicantid, string strLossapplicant, string strManager, string strManagerdecided, string strManagernote, string strOriginaldatatable, int nOriginaldataid)
        {
            this.trinfo.rowsnum = -1;
            this.trinfo.nException = -1;
            using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["lsstring"].ConnectionString))
            {
                SqlCommand command = connection.CreateCommand();
                command.CommandType = CommandType.Text;
                command.CommandText = "INSERT INTO sb_loss VALUES (@devicenumber,@devicename,@categories,@type,@configuration,@unit,@lossnumber,@losscause,@lossnote,@applicantkinds,@lossapplicantid,@lossapplicant,@applicanttime,@manager,@managerdecided,@managernote,@managertime,@checker,@checkdecided,@checknote,@checktime,@finalchecker,@finalcheckdecided,@finalchecknote,@finalchecktime,@originaldatatable,@originaldataid)";
                command.Parameters.AddWithValue("@devicenumber", strDevicenumber);
                command.Parameters.AddWithValue("@devicename", strDevicename);