DAL/TCWL_D_Transfer.cs

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

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

namespace DAL
{
    using Common;
    using Model;
    using System;
    using System.Data;
    using System.Data.SqlClient;
    using System.Text;

    public class TCWL_D_Transfer
    {
        public bool Add(TCWL_M_ProTransfer model)
        {
            StringBuilder builder = new StringBuilder();
            Guid guid = Guid.NewGuid();
            builder.Append("insert into TCWL_ProTransfer(");
            builder.Append("ID,ProID,FromStockID,ToStockID,ProNum,ProUnit,ProSize,ProName,Remarks,ByUserName,ByUserID,InUserName,InUserID,InDate,ServerID,FromStockName,ToStockName,SizeName,ProType,ProCode)");
            builder.Append(" values (");
            builder.Append("@ID,@ProID,@FromStockID,@ToStockID,@ProNum,@ProUnit,@ProSize,@ProName,@Remarks,@ByUserName,@ByUserID,@InUserName,@InUserID,@InDate,@ServerID,@FromStockName,@ToStockName,@SizeName,@ProType,@ProCode)");
            SqlParameter[] cmdParms = new SqlParameter[] { 
                new SqlParameter("@ID", SqlDbType.VarChar, 0x24), new SqlParameter("@ProID", SqlDbType.VarChar, 0x24), new SqlParameter("@FromStockID", SqlDbType.VarChar, 0x24), new SqlParameter("@ToStockID", SqlDbType.VarChar, 0x24), new SqlParameter("@ProNum", SqlDbType.Int, 4), new SqlParameter("@ProUnit", SqlDbType.NVarChar, 8), new SqlParameter("@ProSize", SqlDbType.NVarChar, 0x24), new SqlParameter("@ProName", SqlDbType.NVarChar, 50), new SqlParameter("@Remarks", SqlDbType.NVarChar, 100), new SqlParameter("@ByUserName", SqlDbType.NVarChar, 30), new SqlParameter("@ByUserID", SqlDbType.VarChar, 10), new SqlParameter("@InUserName", SqlDbType.NVarChar, 30), new SqlParameter("@InUserID", SqlDbType.VarChar, 10), new SqlParameter("@InDate", SqlDbType.DateTime), new SqlParameter("@ServerID", SqlDbType.VarChar, 50), new SqlParameter("@FromStockName", SqlDbType.NVarChar, 50), 
                new SqlParameter("@ToStockName", SqlDbType.NVarChar, 50), new SqlParameter("@SizeName", SqlDbType.NVarChar, 50), new SqlParameter("@ProType", SqlDbType.NVarChar, 20), new SqlParameter("@ProCode", SqlDbType.NVarChar, 30)
             };
            cmdParms[0].Value = guid.ToString();
            cmdParms[1].Value = model.ProID;
            cmdParms[2].Value = model.FromStockID;
            cmdParms[3].Value = model.ToStockID;
            cmdParms[4].Value = model.ProNum;
            cmdParms[5].Value = model.ProUnit;
            cmdParms[6].Value = model.ProSize;
            cmdParms[7].Value = model.Proname;
            cmdParms[8].Value = model.Remarks;
            cmdParms[9].Value = model.ByUserName;
            cmdParms[10].Value = model.ByUserID;
            cmdParms[11].Value = model.InUserName;
            cmdParms[12].Value = model.InUserID;
            cmdParms[13].Value = model.InDate;
            cmdParms[14].Value = model.ServerID;
            cmdParms[15].Value = model.FromStockName;
            cmdParms[0x10].Value = model.ToStockName;
            cmdParms[0x11].Value = model.SizeName;
            cmdParms[0x12].Value = model.ProType;
            cmdParms[0x13].Value = model.ProCode;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public string AddTrans(TCWL_M_ProTransfer model)
        {
            StringBuilder builder = new StringBuilder();
            Guid guid = Guid.NewGuid();
            builder.Append("insert into TCWL_ProTransfer(");
            builder.Append("ID,ProID,FromStockID,ToStockID,ProNum,ProUnit,ProSize,ProName,Remarks,ByUserName,ByUserID,InUserName,InUserID,InDate,ServerID,FromStockName,ToStockName,SizeName,ProType,ProCode,InState)");
            builder.Append(" values (");
            builder.Append("@ID,@ProID,@FromStockID,@ToStockID,@ProNum,@ProUnit,@ProSize,@ProName,@Remarks,@ByUserName,@ByUserID,@InUserName,@InUserID,@InDate,@ServerID,@FromStockName,@ToStockName,@SizeName,@ProType,@ProCode,@InState)");
            SqlParameter[] cmdParms = new SqlParameter[] { 
                new SqlParameter("@ID", SqlDbType.VarChar, 0x24), new SqlParameter("@ProID", SqlDbType.VarChar, 0x24), new SqlParameter("@FromStockID", SqlDbType.VarChar, 0x24), new SqlParameter("@ToStockID", SqlDbType.VarChar, 0x24), new SqlParameter("@ProNum", SqlDbType.Int, 4), new SqlParameter("@ProUnit", SqlDbType.NVarChar, 8), new SqlParameter("@ProSize", SqlDbType.NVarChar, 0x24), new SqlParameter("@ProName", SqlDbType.NVarChar, 50), new SqlParameter("@Remarks", SqlDbType.NVarChar, 100), new SqlParameter("@ByUserName", SqlDbType.NVarChar, 30), new SqlParameter("@ByUserID", SqlDbType.VarChar, 10), new SqlParameter("@InUserName", SqlDbType.NVarChar, 30), new SqlParameter("@InUserID", SqlDbType.VarChar, 10), new SqlParameter("@InDate", SqlDbType.DateTime), new SqlParameter("@ServerID", SqlDbType.VarChar, 50), new SqlParameter("@FromStockName", SqlDbType.NVarChar, 50), 
                new SqlParameter("@ToStockName", SqlDbType.NVarChar, 50), new SqlParameter("@SizeName", SqlDbType.NVarChar, 50), new SqlParameter("@ProType", SqlDbType.NVarChar, 20), new SqlParameter("@ProCode", SqlDbType.NVarChar, 30), new SqlParameter("@InState", SqlDbType.Int, 4)
             };
            cmdParms[0].Value = guid.ToString();
            cmdParms[1].Value = model.ProID;