Exemplo n.º 1
0
        /// <summary>
        /// 新增采购单
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int AddBuyApplyBill(BuyApplyBill model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into BuyApplyOrder(");
            strSql.Append("BuyApplyOrderID,BuyApplyOrderCode,BuyApplyOrderDate,SupplierID,DeliveryDate,Creator,CreateTime,Editor,EditTime,FirstChecker,RecCompany,RecTel,RecFax,OrderState,Remark,SecondCheckerName,ReaderName)");
            strSql.Append(" values (");
            strSql.Append("@BuyApplyOrderID,@BuyApplyOrderCode,@BuyApplyOrderDate,@SupplierID,@DeliveryDate,@Creator,@CreateTime,@Editor,@EditTime,@FirstChecker,@RecCompany,@RecTel,@RecFax,@OrderState,@Remark,@SecondCheckerName,@ReaderName)");
            SqlParameter[] parameters =
            {
                new SqlParameter("@BuyApplyOrderID",   SqlDbType.VarChar,     36),
                new SqlParameter("@BuyApplyOrderCode", SqlDbType.VarChar,     60),
                new SqlParameter("@BuyApplyOrderDate", SqlDbType.Char,         8),
                new SqlParameter("@SupplierID",        SqlDbType.VarChar,     36),
                new SqlParameter("@DeliveryDate",      SqlDbType.Char,         8),
                new SqlParameter("@Creator",           SqlDbType.VarChar,     36),
                new SqlParameter("@CreateTime",        SqlDbType.DateTime),
                new SqlParameter("@Editor",            SqlDbType.VarChar,     36),
                new SqlParameter("@EditTime",          SqlDbType.DateTime),
                new SqlParameter("@FirstChecker",      SqlDbType.VarChar,     36),
                new SqlParameter("@RecCompany",        SqlDbType.VarChar,    255),
                new SqlParameter("@RecTel",            SqlDbType.VarChar,     30),
                new SqlParameter("@RecFax",            SqlDbType.VarChar,     30),
                new SqlParameter("@OrderState",        SqlDbType.Char,         1),
                new SqlParameter("@Remark",            SqlDbType.VarChar,   1024),
                new SqlParameter("@SecondCheckerName", SqlDbType.VarChar,    255),
                new SqlParameter("@ReaderName",        SqlDbType.VarChar, 255)
            };
            parameters[0].Value  = model.BuyApplyOrderID;
            parameters[1].Value  = model.BuyApplyOrderCode;
            parameters[2].Value  = model.BuyApplyOrderDate;
            parameters[3].Value  = model.SupplierID;
            parameters[4].Value  = model.DeliveryDate;
            parameters[5].Value  = model.Creator;
            parameters[6].Value  = model.CreateTime;
            parameters[7].Value  = model.Editor;
            parameters[8].Value  = model.EditTime;
            parameters[9].Value  = model.FirstChecker;
            parameters[10].Value = model.RecCompany;
            parameters[11].Value = model.RecTel;
            parameters[12].Value = model.RecFax;
            parameters[13].Value = model.OrderState;
            parameters[14].Value = model.Remark;
            parameters[15].Value = model.SecondCheckerName;
            parameters[16].Value = model.ReaderName;

            IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString);

            try
            {
                DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);

                BOASecondCheckDAL boSC = new BOASecondCheckDAL();
                int ccount             = model.CList.Count;
                if (ccount > 0)
                {
                    for (int i = 0; i < ccount; i++)
                    {
                        BOASecondCheck sosc = model.CList[i] as BOASecondCheck;
                        boSC.Add(sosc);
                    }
                }

                BOAReaderDAL rSC    = new BOAReaderDAL();
                int          rcount = model.RList.Count;
                if (rcount > 0)
                {
                    for (int i = 0; i < rcount; i++)
                    {
                        BOAReader bor = model.RList[i] as BOAReader;
                        rSC.Add(bor);
                    }
                }

                BuyApplyBillItemDAL item = new BuyApplyBillItemDAL();
                item.Save(model.BuyApplyOrderID, model.OldBuyOrderID);

                transaction.Commit();
            }
            catch
            {
                transaction.Rollback();
            }

            return(1);
        }
Exemplo n.º 2
0
        /// <summary>
        /// 修改采购单
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateBuyApplyBill(BuyApplyBill model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update BuyApplyOrder set ");
            strSql.Append("BuyApplyOrderCode=@BuyApplyOrderCode,");
            strSql.Append("BuyApplyOrderDate=@BuyApplyOrderDate,");
            strSql.Append("SupplierID=@SupplierID,");
            strSql.Append("DeliveryDate=@DeliveryDate,");
            strSql.Append("Editor=@Editor,");
            strSql.Append("EditTime=@EditTime,");
            strSql.Append("FirstChecker=@FirstChecker,");
            strSql.Append("FirstCheckTime=@FirstCheckTime,");
            strSql.Append("FirstCheckView=@FirstCheckView,");
            strSql.Append("RecCompany=@RecCompany,");
            strSql.Append("RecTel=@RecTel,");
            strSql.Append("RecFax=@RecFax,");
            strSql.Append("Remark=@Remark,");
            strSql.Append("SecondCheckerName=@SecondCheckerName,");
            strSql.Append("ReaderName=@ReaderName");
            strSql.Append(" where BuyApplyOrderID=@BuyApplyOrderID ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@BuyApplyOrderCode", SqlDbType.VarChar,     60),
                new SqlParameter("@BuyApplyOrderDate", SqlDbType.Char,         8),
                new SqlParameter("@SupplierID",        SqlDbType.VarChar,     36),
                new SqlParameter("@DeliveryDate",      SqlDbType.Char,         8),
                new SqlParameter("@Editor",            SqlDbType.VarChar,     36),
                new SqlParameter("@EditTime",          SqlDbType.DateTime),
                new SqlParameter("@FirstChecker",      SqlDbType.VarChar,     36),
                new SqlParameter("@FirstCheckTime",    SqlDbType.DateTime),
                new SqlParameter("@FirstCheckView",    SqlDbType.VarChar,    255),
                new SqlParameter("@RecCompany",        SqlDbType.VarChar,    255),
                new SqlParameter("@RecTel",            SqlDbType.VarChar,     30),
                new SqlParameter("@RecFax",            SqlDbType.VarChar,     30),
                new SqlParameter("@Remark",            SqlDbType.VarChar,   1024),
                new SqlParameter("@SecondCheckerName", SqlDbType.VarChar,    255),
                new SqlParameter("@ReaderName",        SqlDbType.VarChar,    255),
                new SqlParameter("@BuyApplyOrderID",   SqlDbType.VarChar, 36)
            };
            parameters[0].Value  = model.BuyApplyOrderCode;
            parameters[1].Value  = model.BuyApplyOrderDate;
            parameters[2].Value  = model.SupplierID;
            parameters[3].Value  = model.DeliveryDate;
            parameters[4].Value  = model.Editor;
            parameters[5].Value  = model.EditTime;
            parameters[6].Value  = model.FirstChecker;
            parameters[7].Value  = model.FirstCheckTime;
            parameters[8].Value  = model.FirstCheckView;
            parameters[9].Value  = model.RecCompany;
            parameters[10].Value = model.RecTel;
            parameters[11].Value = model.RecFax;
            parameters[12].Value = model.Remark;
            parameters[13].Value = model.SecondCheckerName;
            parameters[14].Value = model.ReaderName;
            parameters[15].Value = model.BuyApplyOrderID;

            IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString);

            try
            {
                DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);

                BOASecondCheckDAL boSC = new BOASecondCheckDAL();
                int socount            = model.CList.Count;
                if (socount > 0)
                {
                    boSC.Delete(model.BuyApplyOrderID);
                    for (int i = 0; i < socount; i++)
                    {
                        BOASecondCheck bosc = model.CList[i] as BOASecondCheck;
                        boSC.Add(bosc);
                    }
                }

                BOAReaderDAL rSC    = new BOAReaderDAL();
                int          rcount = model.RList.Count;
                if (rcount > 0)
                {
                    rSC.Delete(model.BuyApplyOrderID);
                    for (int i = 0; i < rcount; i++)
                    {
                        BOAReader sor = model.RList[i] as BOAReader;
                        rSC.Add(sor);
                    }
                }

                transaction.Commit();
            }
            catch
            {
                transaction.Rollback();
            }

            return(true);
        }