WELOA.DAL/Equipment/sb_getDAO.cs

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

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

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

namespace SBDAL_SQL
{
    public class sb_getDAO
    {
        
        private DateSetInformation dsinfo = new DateSetInformation();
        private ls_exception exlog = new ls_exception();
        private ls_publicclass publicclassDAO = new ls_publicclass();
        private sb_storageDAO storageDAO = new sb_storageDAO();
        private sb_systemDAO systemDAO = new sb_systemDAO();
        private Polytechnic trinfo = new Polytechnic();

        
        public Polytechnic delGet(string strDevicenumber, int nGetnumber, string strGeterid)
        {
            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_get WHERE devicenumber=@devicenumber AND geterid = @geterid AND devicestate =@devicestate ";
                command.Parameters.AddWithValue("@devicenumber", strDevicenumber);
                command.Parameters.AddWithValue("@geterid", strGeterid);
                command.Parameters.AddWithValue("@devicestate", "预领");
                SqlCommand command2 = connection.CreateCommand();
                command2.CommandType = CommandType.Text;
                command2.CommandText = "UPDATE sb_storage SET actualinventory=actualinventory + @getnumber WHERE devicenumber=@devicenumber";
                command2.Parameters.AddWithValue("@devicenumber", strDevicenumber);
                command2.Parameters.AddWithValue("@getnumber", nGetnumber);
                if (connection.State == ConnectionState.Closed)
                {
                    connection.Open();
                }
                SqlTransaction transaction = connection.BeginTransaction();
                try
                {
                    command.Transaction = transaction;
                    command2.Transaction = transaction;
                    int num = command.ExecuteNonQuery();
                    int num2 = command2.ExecuteNonQuery();
                    if ((num > 0) && (num2 > 0))
                    {
                        this.trinfo.rowsnum = 1;
                    }
                    transaction.Commit();
                }
                catch (Exception exception)
                {
                    transaction.Rollback();