立库管理/WMS_Database/DAL/View_RecordDAL.cs

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

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

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
 
namespace WMS_Database
{
    /// <summary>
    /// 数据访问类:View_Record
    /// </summary>
    public partial class View_RecordDAL
    {
        public View_RecordDAL()
        { }
        #region  Method


        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(string Plan_ID, string Manage_Type_Code, string Stock_Tray_Barcode, string Start_Cell_ID, string End_Cell_ID, string Manage_Operater, DateTime Manage_Begin_Time, DateTime Manage_End_Time, string Record_Remark, string Record_ID, string Plan_List_ID, string Goods_ID, string Record_Box_Barcode, string Record_List_Quantity, string Record_List_Remark, string Record_List_Reserve1, string Goods_Class_ID, string Goods_Code, string Goods_Name, string Goods_Type, string Goods_Batch, string Goods_Model, string Goods_Suppier_Code, string Goods_Desc, string Goods_Level, string Record_List_ID, string Record_OperateType)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from View_Record");
            strSql.Append(" where Plan_ID='" + Plan_ID + "' and Manage_Type_Code='" + Manage_Type_Code + "' and Stock_Tray_Barcode='" + Stock_Tray_Barcode + "' and Start_Cell_ID='" + Start_Cell_ID + "' and End_Cell_ID='" + End_Cell_ID + "' and Manage_Operater='" + Manage_Operater + "' and Manage_Begin_Time='" + Manage_Begin_Time + "' and Manage_End_Time='" + Manage_End_Time + "' and Record_Remark='" + Record_Remark + "' and Record_ID='" + Record_ID + "' and Plan_List_ID='" + Plan_List_ID + "' and Goods_ID='" + Goods_ID + "' and Record_Box_Barcode='" + Record_Box_Barcode + "' and Record_List_Quantity='" + Record_List_Quantity + "' and Record_List_Remark='" + Record_List_Remark + "' and Record_List_Reserve1='" + Record_List_Reserve1 + "' and Goods_Class_ID='" + Goods_Class_ID + "' and Goods_Code='" + Goods_Code + "' and Goods_Name='" + Goods_Name + "' and Goods_Type='" + Goods_Type + "' and Goods_Batch='" + Goods_Batch + "' and Goods_Model='" + Goods_Model + "' and Goods_Suppier_Code='" + Goods_Suppier_Code + "' and Goods_Desc='" + Goods_Desc + "' and Goods_Level='" + Goods_Level + "' and Record_List_ID='" + Record_List_ID + "' and Record_OperateType='" + Record_OperateType + "' ");
            return DbHelperSQL.Exists(strSql.ToString());
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(WMS_Database.View_RecordModel model)
        {
            StringBuilder strSql = new StringBuilder();
            StringBuilder strSql1 = new StringBuilder();
            StringBuilder strSql2 = new StringBuilder();
            if (model.Plan_ID != null)
            {
                strSql1.Append("Plan_ID,");
                strSql2.Append("'" + model.Plan_ID + "',");
            }
            if (model.Manage_Type_Code != null)
            {
                strSql1.Append("Manage_Type_Code,");
                strSql2.Append("'" + model.Manage_Type_Code + "',");
            }
            if (model.Stock_Tray_Barcode != null)
            {
                strSql1.Append("Stock_Tray_Barcode,");
                strSql2.Append("'" + model.Stock_Tray_Barcode + "',");
            }
            if (model.Start_Cell_ID != null)
            {
                strSql1.Append("Start_Cell_ID,");
                strSql2.Append("'" + model.Start_Cell_ID + "',");
            }
            if (model.End_Cell_ID != null)
            {
                strSql1.Append("End_Cell_ID,");
                strSql2.Append("'" + model.End_Cell_ID + "',");