Example #1
0
        /// <summary>
        /// 删除采购订单
        /// </summary>
        /// <param name="BuyOrderID"></param>
        /// <returns></returns>
        public bool Delete(string BuyOrderID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("delete from BuyOrder ");
            strSql.Append(" where BuyOrderID=@BuyOrderID ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@BuyOrderID", SqlDbType.VarChar, 36)
            };
            parameters[0].Value = BuyOrderID;

            int rows = 0;

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

            try
            {
                //删除分录
                BuyBillItemDAL item = new BuyBillItemDAL();
                item.Delete(BuyOrderID);

                //删除分阅人
                BOReaderDAL bor = new BOReaderDAL();
                bor.Delete(BuyOrderID);

                //删除复核人
                BOSecondCheckDAL bos = new BOSecondCheckDAL();
                bos.Delete(BuyOrderID);

                rows = DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters);

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

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Example #2
0
        /// <summary>
        /// 新增采购单
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int AddBuyBill(BuyBill model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into BuyOrder(");
            strSql.Append("BuyOrderID,BuyOrderCode,BuyOrderDate,SupplierID,DeliveryDate,Creator,CreateTime,Editor,EditTime,FirstChecker,RecCompany,RecTel,RecFax,OrderState,Remark,SecondCheckerName,ReaderName)");
            strSql.Append(" values (");
            strSql.Append("@BuyOrderID,@BuyOrderCode,@BuyOrderDate,@SupplierID,@DeliveryDate,@Creator,@CreateTime,@Editor,@EditTime,@FirstChecker,@RecCompany,@RecTel,@RecFax,@OrderState,@Remark,@SecondCheckerName,@ReaderName)");
            SqlParameter[] parameters =
            {
                new SqlParameter("@BuyOrderID",        SqlDbType.VarChar,     36),
                new SqlParameter("@BuyOrderCode",      SqlDbType.VarChar,     60),
                new SqlParameter("@BuyOrderDate",      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.BuyOrderID;
            parameters[1].Value  = model.BuyOrderCode;
            parameters[2].Value  = model.BuyOrderDate;
            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);

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

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

                BuyBillItemDAL item = new BuyBillItemDAL();
                item.Save(model.BuyOrderID, model.OldBuyOrderID);

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

            return(1);
        }