DAL/TCWL_D_Storage.cs

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

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

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

    public class TCWL_D_Storage
    {
        public bool Add(TCWL_M_Storage model)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("insert into TCWL_Storage(");
            builder.Append("ProID,StockID,ProNum,ServerID,ProSize)");
            builder.Append(" values (");
            builder.Append("@ProID,@StockID,@ProNum,@ServerID,@ProSize)");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ProID", SqlDbType.VarChar, 0x24), new SqlParameter("@StockID", SqlDbType.VarChar, 0x24), new SqlParameter("@ProNum", SqlDbType.Int, 4), new SqlParameter("@ServerID", SqlDbType.VarChar, 50), new SqlParameter("@ProSize", SqlDbType.VarChar, 0x24) };
            cmdParms[0].Value = model.ProID;
            cmdParms[1].Value = model.StockID;
            cmdParms[2].Value = model.ProNum;
            cmdParms[3].Value = model.ServerID;
            cmdParms[4].Value = model.ProSize;
            return (DBHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }

        public int CheckHas(string proid, string prosize, string StockID, out string id)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("select ID from TCWL_Storage  where ProID=@ProID and ProSize=@ProSize and StockID=@StockID");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ProID", SqlDbType.VarChar, 0x24), new SqlParameter("@ProSize", SqlDbType.VarChar, 0x24), new SqlParameter("@StockID", SqlDbType.VarChar, 0x24) };
            cmdParms[0].Value = proid;
            cmdParms[1].Value = prosize;
            cmdParms[2].Value = StockID;
            DataTable table = DBHelper.Query(builder.ToString(), cmdParms).Tables[0];
            if (table.Rows.Count > 0)
            {
                id = table.Rows[0][0].ToString();
                return table.Rows.Count;
            }
            id = "";
            return 0;
        }

        public int CheckNum(string proid, string prosize, string StockID, out string id)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("select ID,ProNum from TCWL_Storage  where ProID=@ProID and ProSize=@ProSize and StockID=@StockID");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ProID", SqlDbType.VarChar, 0x24), new SqlParameter("@ProSize", SqlDbType.VarChar, 0x24), new SqlParameter("@StockID", SqlDbType.VarChar, 0x24) };
            cmdParms[0].Value = proid;
            cmdParms[1].Value = prosize;
            cmdParms[2].Value = StockID;
            DataTable table = DBHelper.Query(builder.ToString(), cmdParms).Tables[0];
            if (table.Rows.Count > 0)
            {
                id = table.Rows[0][0].ToString();
                return int.Parse(table.Rows[0][1].ToString());
            }