Beispiel #1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Mod_ReZJB_PDD model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into ReZJB_PDD(");
            strSql.Append("ZJBstatus,CAPPK,ck,pdrq,ysdh)");
            strSql.Append(" values (");
            strSql.Append("@ZJBstatus,@CAPPK,@ck,@pdrq,@ysdh)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ZJBstatus", SqlDbType.Int,        4),
                new SqlParameter("@CAPPK",     SqlDbType.VarChar,   50),
                new SqlParameter("@ck",        SqlDbType.VarChar,   50),
                new SqlParameter("@pdrq",      SqlDbType.DateTime),
                new SqlParameter("@ysdh",      SqlDbType.VarChar, 50)
            };
            parameters[0].Value = model.ZJBstatus;
            parameters[1].Value = model.CAPPK;
            parameters[2].Value = model.ck;
            parameters[3].Value = model.pdrq;
            parameters[4].Value = model.ysdh;

            object obj = DbHelper_SQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Mod_ReZJB_WGD_Item model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into ReZJB_WGD_Item(");
            strSql.Append("wgdh,pch,ph,gg,wlh,wlmc,pcinfo,zyx1,zyx2,zyx3,zyx4,zyx5,ZJBstatus,CAPPK)");
            strSql.Append(" values (");
            strSql.Append("@wgdh,@pch,@ph,@gg,@wlh,@wlmc,@pcinfo,@zyx1,@zyx2,@zyx3,@zyx4,@zyx5,@ZJBstatus,@CAPPK)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@wgdh",      SqlDbType.VarChar,  50),
                new SqlParameter("@pch",       SqlDbType.VarChar,  50),
                new SqlParameter("@ph",        SqlDbType.VarChar,  50),
                new SqlParameter("@gg",        SqlDbType.VarChar,  50),
                new SqlParameter("@wlh",       SqlDbType.VarChar,  50),
                new SqlParameter("@wlmc",      SqlDbType.VarChar,  50),
                new SqlParameter("@pcinfo",    SqlDbType.VarChar, 150),
                new SqlParameter("@zyx1",      SqlDbType.VarChar, 150),
                new SqlParameter("@zyx2",      SqlDbType.VarChar, 150),
                new SqlParameter("@zyx3",      SqlDbType.VarChar, 150),
                new SqlParameter("@zyx4",      SqlDbType.VarChar, 150),
                new SqlParameter("@zyx5",      SqlDbType.VarChar, 150),
                new SqlParameter("@ZJBstatus", SqlDbType.Int,       4),
                new SqlParameter("@CAPPK",     SqlDbType.VarChar, 50)
            };
            parameters[0].Value  = model.wgdh;
            parameters[1].Value  = model.pch;
            parameters[2].Value  = model.ph;
            parameters[3].Value  = model.gg;
            parameters[4].Value  = model.wlh;
            parameters[5].Value  = model.wlmc;
            parameters[6].Value  = model.pcinfo;
            parameters[7].Value  = model.zyx1;
            parameters[8].Value  = model.zyx2;
            parameters[9].Value  = model.zyx3;
            parameters[10].Value = model.zyx4;
            parameters[11].Value = model.zyx5;
            parameters[12].Value = model.ZJBstatus;
            parameters[13].Value = model.CAPPK;

            object obj = DbHelper_SQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Beispiel #3
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Mod_ReZJB_PDD_Item model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into ReZJB_PDD_Item(");
            strSql.Append("ysdh,BARCODE,PCH,SX,ZCSL,FZCZL,vfree0,vfree1,vfree2,vfree3,vfree4,ZJBstatus,CAPPK)");
            strSql.Append(" values (");
            strSql.Append("@ysdh,@BARCODE,@PCH,@SX,@ZCSL,@FZCZL,@vfree0,@vfree1,@vfree2,@vfree3,@vfree4,@ZJBstatus,@CAPPK)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@ysdh",      SqlDbType.VarChar,  50),
                new SqlParameter("@BARCODE",   SqlDbType.VarChar,  50),
                new SqlParameter("@PCH",       SqlDbType.VarChar,  50),
                new SqlParameter("@SX",        SqlDbType.VarChar,  50),
                new SqlParameter("@ZCSL",      SqlDbType.Int,       4),
                new SqlParameter("@FZCZL",     SqlDbType.Decimal,   9),
                new SqlParameter("@vfree0",    SqlDbType.VarChar, 150),
                new SqlParameter("@vfree1",    SqlDbType.VarChar, 150),
                new SqlParameter("@vfree2",    SqlDbType.VarChar, 150),
                new SqlParameter("@vfree3",    SqlDbType.VarChar, 150),
                new SqlParameter("@vfree4",    SqlDbType.VarChar, 150),
                new SqlParameter("@ZJBstatus", SqlDbType.Int,       4),
                new SqlParameter("@CAPPK",     SqlDbType.VarChar, 50)
            };
            parameters[0].Value  = model.ysdh;
            parameters[1].Value  = model.BARCODE;
            parameters[2].Value  = model.PCH;
            parameters[3].Value  = model.SX;
            parameters[4].Value  = model.ZCSL;
            parameters[5].Value  = model.FZCZL;
            parameters[6].Value  = model.vfree0;
            parameters[7].Value  = model.vfree1;
            parameters[8].Value  = model.vfree2;
            parameters[9].Value  = model.vfree3;
            parameters[10].Value = model.vfree4;
            parameters[11].Value = model.ZJBstatus;
            parameters[12].Value = model.CAPPK;

            object obj = DbHelper_SQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Beispiel #4
0
        /// <summary>
        /// 获取记录总数
        /// </summary>
        public int GetRecordCount(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select count(1) FROM SeZJB_Shift_Record ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            object obj = DbHelper_SQL.GetSingle(strSql.ToString());

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Beispiel #5
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Mod_ReZJB_FYD model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into ReZJB_FYD(");
            strSql.Append("fydh,ck,khbm,yslb,cph,wlh,wlmc,sx,zldj,jhsl,jhzl,zjldw,fjldw,varrivestation,zdr,zdrq,PH,GG,PCInfo,zyx1,zyx2,zyx3,zyx4,zyx5,ZJBstatus,CAPPK,ywbm,ywry)");
            strSql.Append(" values (");
            strSql.Append("@fydh,@ck,@khbm,@yslb,@cph,@wlh,@wlmc,@sx,@zldj,@jhsl,@jhzl,@zjldw,@fjldw,@varrivestation,@zdr,@zdrq,@PH,@GG,@PCInfo,@zyx1,@zyx2,@zyx3,@zyx4,@zyx5,@ZJBstatus,@CAPPK,@ywbm,@ywry)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@fydh",           SqlDbType.VarChar,   50),
                new SqlParameter("@ck",             SqlDbType.VarChar,   50),
                new SqlParameter("@khbm",           SqlDbType.VarChar,   50),
                new SqlParameter("@yslb",           SqlDbType.VarChar,   50),
                new SqlParameter("@cph",            SqlDbType.VarChar,   50),
                new SqlParameter("@wlh",            SqlDbType.VarChar,   50),
                new SqlParameter("@wlmc",           SqlDbType.VarChar,   50),
                new SqlParameter("@sx",             SqlDbType.VarChar,   50),
                new SqlParameter("@zldj",           SqlDbType.VarChar,   50),
                new SqlParameter("@jhsl",           SqlDbType.Decimal,    9),
                new SqlParameter("@jhzl",           SqlDbType.Decimal,    9),
                new SqlParameter("@zjldw",          SqlDbType.VarChar,   50),
                new SqlParameter("@fjldw",          SqlDbType.VarChar,   50),
                new SqlParameter("@varrivestation", SqlDbType.VarChar,   50),
                new SqlParameter("@zdr",            SqlDbType.VarChar,   50),
                new SqlParameter("@zdrq",           SqlDbType.DateTime),
                new SqlParameter("@PH",             SqlDbType.VarChar,   50),
                new SqlParameter("@GG",             SqlDbType.VarChar,   50),
                new SqlParameter("@PCInfo",         SqlDbType.VarChar,   50),
                new SqlParameter("@zyx1",           SqlDbType.VarChar,   50),
                new SqlParameter("@zyx2",           SqlDbType.VarChar,   50),
                new SqlParameter("@zyx3",           SqlDbType.VarChar,   50),
                new SqlParameter("@zyx4",           SqlDbType.VarChar,   50),
                new SqlParameter("@zyx5",           SqlDbType.VarChar,   50),
                new SqlParameter("@ZJBstatus",      SqlDbType.Int,        4),
                new SqlParameter("@CAPPK",          SqlDbType.VarChar,   50),
                new SqlParameter("@ywbm",           SqlDbType.VarChar,   50),
                new SqlParameter("@ywry",           SqlDbType.VarChar, 50)
            };
            parameters[0].Value  = model.fydh;
            parameters[1].Value  = model.ck;
            parameters[2].Value  = model.khbm;
            parameters[3].Value  = model.yslb;
            parameters[4].Value  = model.cph;
            parameters[5].Value  = model.wlh;
            parameters[6].Value  = model.wlmc;
            parameters[7].Value  = model.sx;
            parameters[8].Value  = model.zldj;
            parameters[9].Value  = model.jhsl;
            parameters[10].Value = model.jhzl;
            parameters[11].Value = model.zjldw;
            parameters[12].Value = model.fjldw;
            parameters[13].Value = model.varrivestation;
            parameters[14].Value = model.zdr;
            parameters[15].Value = model.zdrq;
            parameters[16].Value = model.PH;
            parameters[17].Value = model.GG;
            parameters[18].Value = model.PCInfo;
            parameters[19].Value = model.zyx1;
            parameters[20].Value = model.zyx2;
            parameters[21].Value = model.zyx3;
            parameters[22].Value = model.zyx4;
            parameters[23].Value = model.zyx5;
            parameters[24].Value = model.ZJBstatus;
            parameters[25].Value = model.CAPPK;
            parameters[26].Value = model.ywbm;
            parameters[27].Value = model.ywry;

            object obj = DbHelper_SQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Beispiel #6
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Mod_ReZJB_WGD model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into ReZJB_WGD(");
            strSql.Append("wgdh,pch,ph,gg,bb,wlh,wlmc,fzdw,zxbz,zldj,SCX,pcinfo,zyx1,zyx2,zyx3,zyx4,zyx5,gpmainmeasrate,ZJBstatus,CAPPK)");
            strSql.Append(" values (");
            strSql.Append("@wgdh,@pch,@ph,@gg,@bb,@wlh,@wlmc,@fzdw,@zxbz,@zldj,@SCX,@pcinfo,@zyx1,@zyx2,@zyx3,@zyx4,@zyx5,@gpmainmeasrate,@ZJBstatus,@CAPPK)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@wgdh",           SqlDbType.VarChar,  50),
                new SqlParameter("@pch",            SqlDbType.VarChar,  50),
                new SqlParameter("@ph",             SqlDbType.VarChar,  50),
                new SqlParameter("@gg",             SqlDbType.VarChar,  50),
                new SqlParameter("@bb",             SqlDbType.VarChar,  50),
                new SqlParameter("@wlh",            SqlDbType.VarChar,  50),
                new SqlParameter("@wlmc",           SqlDbType.VarChar,  50),
                new SqlParameter("@fzdw",           SqlDbType.VarChar,  50),
                new SqlParameter("@zxbz",           SqlDbType.VarChar,  50),
                new SqlParameter("@zldj",           SqlDbType.VarChar,  50),
                new SqlParameter("@SCX",            SqlDbType.VarChar,  50),
                new SqlParameter("@pcinfo",         SqlDbType.VarChar, 150),
                new SqlParameter("@zyx1",           SqlDbType.VarChar, 150),
                new SqlParameter("@zyx2",           SqlDbType.VarChar, 150),
                new SqlParameter("@zyx3",           SqlDbType.VarChar, 150),
                new SqlParameter("@zyx4",           SqlDbType.VarChar, 150),
                new SqlParameter("@zyx5",           SqlDbType.VarChar, 150),
                new SqlParameter("@gpmainmeasrate", SqlDbType.Decimal,   9),
                new SqlParameter("@ZJBstatus",      SqlDbType.Int,       4),
                new SqlParameter("@CAPPK",          SqlDbType.VarChar, 50)
            };
            parameters[0].Value  = model.wgdh;
            parameters[1].Value  = model.pch;
            parameters[2].Value  = model.ph;
            parameters[3].Value  = model.gg;
            parameters[4].Value  = model.bb;
            parameters[5].Value  = model.wlh;
            parameters[6].Value  = model.wlmc;
            parameters[7].Value  = model.fzdw;
            parameters[8].Value  = model.zxbz;
            parameters[9].Value  = model.zldj;
            parameters[10].Value = model.SCX;
            parameters[11].Value = model.pcinfo;
            parameters[12].Value = model.zyx1;
            parameters[13].Value = model.zyx2;
            parameters[14].Value = model.zyx3;
            parameters[15].Value = model.zyx4;
            parameters[16].Value = model.zyx5;
            parameters[17].Value = model.gpmainmeasrate;
            parameters[18].Value = model.ZJBstatus;
            parameters[19].Value = model.CAPPK;

            object obj = DbHelper_SQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Beispiel #7
0
        ///// <summary>
        ///// 增加一条数据
        ///// </summary>
        public int Add(Mod_ReZJB_GPD model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into ReZJB_GPD(");
            strSql.Append("Barcode,WGDH,CK,HW,PCH,WLH,WLMC,SX,ZLDJ,PH,GG,BB,GH,ZL,BZ,RQ,RKType,RKRY,WeightRQ,CKCXH,ProduceData,PCInfo,Filed1,ErrSeason,Filed2,vfree0,vfree1,vfree2,vfree3,vfree4,GPTYPE,ZJBStatus,CAPPK)");
            strSql.Append(" values (");
            strSql.Append("@Barcode,@WGDH,@CK,@HW,@PCH,@WLH,@WLMC,@SX,@ZLDJ,@PH,@GG,@BB,@GH,@ZL,@BZ,@RQ,@RKType,@RKRY,@WeightRQ,@CKCXH,@ProduceData,@PCInfo,@Filed1,@ErrSeason,@Filed2,@vfree0,@vfree1,@vfree2,@vfree3,@vfree4,@GPTYPE,@ZJBStatus,@CAPPK)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@Barcode",     SqlDbType.VarChar,    20),
                new SqlParameter("@WGDH",        SqlDbType.VarChar,    50),
                new SqlParameter("@CK",          SqlDbType.VarChar,    30),
                new SqlParameter("@HW",          SqlDbType.VarChar,    20),
                new SqlParameter("@PCH",         SqlDbType.VarChar,    20),
                new SqlParameter("@WLH",         SqlDbType.VarChar,    20),
                new SqlParameter("@WLMC",        SqlDbType.VarChar,   100),
                new SqlParameter("@SX",          SqlDbType.VarChar,    30),
                new SqlParameter("@ZLDJ",        SqlDbType.VarChar,    10),
                new SqlParameter("@PH",          SqlDbType.VarChar,    30),
                new SqlParameter("@GG",          SqlDbType.VarChar,    30),
                new SqlParameter("@BB",          SqlDbType.VarChar,    10),
                new SqlParameter("@GH",          SqlDbType.Int,         4),
                new SqlParameter("@ZL",          SqlDbType.Decimal,     9),
                new SqlParameter("@BZ",          SqlDbType.VarChar,    50),
                new SqlParameter("@RQ",          SqlDbType.DateTime),
                new SqlParameter("@RKType",      SqlDbType.VarChar,    20),
                new SqlParameter("@RKRY",        SqlDbType.VarChar,    20),
                new SqlParameter("@WeightRQ",    SqlDbType.DateTime),
                new SqlParameter("@CKCXH",       SqlDbType.Int,         4),
                new SqlParameter("@ProduceData", SqlDbType.VarChar,    20),
                new SqlParameter("@PCInfo",      SqlDbType.VarChar,   150),
                new SqlParameter("@Filed1",      SqlDbType.VarChar,    50),
                new SqlParameter("@ErrSeason",   SqlDbType.VarChar,    50),
                new SqlParameter("@Filed2",      SqlDbType.VarChar,    50),
                new SqlParameter("@vfree0",      SqlDbType.VarChar,   300),
                new SqlParameter("@vfree1",      SqlDbType.VarChar,    50),
                new SqlParameter("@vfree2",      SqlDbType.VarChar,    50),
                new SqlParameter("@vfree3",      SqlDbType.VarChar,    50),
                new SqlParameter("@vfree4",      SqlDbType.VarChar,    50),
                new SqlParameter("@GPTYPE",      SqlDbType.VarChar,    50),
                new SqlParameter("@ZJBStatus",   SqlDbType.Int,         4),
                new SqlParameter("@CAPPK",       SqlDbType.VarChar, 50)
            };
            parameters[0].Value  = model.Barcode;
            parameters[1].Value  = model.WGDH;
            parameters[2].Value  = model.CK;
            parameters[3].Value  = model.HW;
            parameters[4].Value  = model.PCH;
            parameters[5].Value  = model.WLH;
            parameters[6].Value  = model.WLMC;
            parameters[7].Value  = model.SX;
            parameters[8].Value  = model.ZLDJ;
            parameters[9].Value  = model.PH;
            parameters[10].Value = model.GG;
            parameters[11].Value = model.BB;
            parameters[12].Value = model.GH;
            parameters[13].Value = model.ZL;
            parameters[14].Value = model.BZ;
            parameters[15].Value = model.RQ;
            parameters[16].Value = model.RKType;
            parameters[17].Value = model.RKRY;
            parameters[18].Value = model.WeightRQ;
            parameters[19].Value = model.CKCXH;
            parameters[20].Value = model.ProduceData;
            parameters[21].Value = model.PCInfo;
            parameters[22].Value = model.Filed1;
            parameters[23].Value = model.ErrSeason;
            parameters[24].Value = model.Filed2;
            parameters[25].Value = model.vfree0;
            parameters[26].Value = model.vfree1;
            parameters[27].Value = model.vfree2;
            parameters[28].Value = model.vfree3;
            parameters[29].Value = model.vfree4;
            parameters[30].Value = model.GPTYPE;
            parameters[31].Value = model.ZJBStatus;
            parameters[32].Value = model.CAPPK;

            object obj = DbHelper_SQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Beispiel #8
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Mod_ReZJB_ZKD model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into ReZJB_ZKD(");
            strSql.Append("zkdh,sck,tck,wlh,wlmc,pch,sx,zldj,jhsl,jhzl,zjldw,fjldw,ph,gg,vfree0,vfree1,vfree2,vfree3,vfree4,ZJBstatus,CAPPK)");
            strSql.Append(" values (");
            strSql.Append("@zkdh,@sck,@tck,@wlh,@wlmc,@pch,@sx,@zldj,@jhsl,@jhzl,@zjldw,@fjldw,@ph,@gg,@vfree0,@vfree1,@vfree2,@vfree3,@vfree4,@ZJBstatus,@CAPPK)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@zkdh",      SqlDbType.VarChar, 50),
                new SqlParameter("@sck",       SqlDbType.VarChar, 50),
                new SqlParameter("@tck",       SqlDbType.VarChar, 50),
                new SqlParameter("@wlh",       SqlDbType.VarChar, 50),
                new SqlParameter("@wlmc",      SqlDbType.VarChar, 50),
                new SqlParameter("@pch",       SqlDbType.VarChar, 50),
                new SqlParameter("@sx",        SqlDbType.VarChar, 50),
                new SqlParameter("@zldj",      SqlDbType.VarChar, 50),
                new SqlParameter("@jhsl",      SqlDbType.Decimal,  9),
                new SqlParameter("@jhzl",      SqlDbType.Decimal,  9),
                new SqlParameter("@zjldw",     SqlDbType.VarChar, 50),
                new SqlParameter("@fjldw",     SqlDbType.VarChar, 50),
                new SqlParameter("@ph",        SqlDbType.VarChar, 50),
                new SqlParameter("@gg",        SqlDbType.VarChar, 50),
                new SqlParameter("@vfree0",    SqlDbType.VarChar, 50),
                new SqlParameter("@vfree1",    SqlDbType.VarChar, 50),
                new SqlParameter("@vfree2",    SqlDbType.VarChar, 50),
                new SqlParameter("@vfree3",    SqlDbType.VarChar, 50),
                new SqlParameter("@vfree4",    SqlDbType.VarChar, 50),
                new SqlParameter("@ZJBstatus", SqlDbType.Int,      4),
                new SqlParameter("@CAPPK",     SqlDbType.VarChar, 50)
            };
            parameters[0].Value  = model.zkdh;
            parameters[1].Value  = model.sck;
            parameters[2].Value  = model.tck;
            parameters[3].Value  = model.wlh;
            parameters[4].Value  = model.wlmc;
            parameters[5].Value  = model.pch;
            parameters[6].Value  = model.sx;
            parameters[7].Value  = model.zldj;
            parameters[8].Value  = model.jhsl;
            parameters[9].Value  = model.jhzl;
            parameters[10].Value = model.zjldw;
            parameters[11].Value = model.fjldw;
            parameters[12].Value = model.ph;
            parameters[13].Value = model.gg;
            parameters[14].Value = model.vfree0;
            parameters[15].Value = model.vfree1;
            parameters[16].Value = model.vfree2;
            parameters[17].Value = model.vfree3;
            parameters[18].Value = model.vfree4;
            parameters[19].Value = model.ZJBstatus;
            parameters[20].Value = model.CAPPK;

            object obj = DbHelper_SQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }