public bool Classify() { int rst = 0; IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); try { //清空表当前数据 Clear(); //归集数据,插入表 string sql = @"insert into ClientClassification(Id,Amount,ClientName,LevelName,LevelTypeName) select NEWID() Id,t1.*,cl.LevelName,case cl.LevelType when 'SOTotalAmmount' then '销售订单总额' end LevelTypeName from (select SUM(so.SaleCost) Amount,c.ClientName from SaleOrder so left join Client c on so.ClientID=c.ClientID where so.ClientID is not null and so.ClientID <> '' GROUP by so.ClientID,c.ClientName) t1,ClientLevel cl where t1.Amount >= cl.LevelMin and t1.Amount < cl.LevelMax"; rst = DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, sql); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); base.Logger.LogError(ex); return(false); } return(rst > 0); }
/// <summary> /// 复审 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateCheckS(BuyBill model, BOSecondCheck boc) { BOSecondCheckDAL bocDal = new BOSecondCheckDAL(); StringBuilder strSql = new StringBuilder(); strSql.Append("update BuyOrder set "); strSql.Append("OrderState=@OrderState"); strSql.Append(" where BuyOrderID=@BuyOrderID "); SqlParameter[] parameters = { new SqlParameter("@OrderState", SqlDbType.Char, 1), new SqlParameter("@BuyOrderID", SqlDbType.VarChar, 36) }; parameters[0].Value = model.OrderState; parameters[1].Value = model.BuyOrderID; IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); try { bocDal.Check(boc); if (bocDal.IsCheck(model.BuyOrderID)) { DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters); } transaction.Commit(); } catch { transaction.Rollback(); } return(true); }
/// <summary> /// 删除公文 /// </summary> /// <param name="OfficeDocID"></param> /// <returns></returns> public int DelOfficeDoc(string OfficeDocID) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from OA_OfficeDoc "); strSql.Append(" where OfficeDocID=@OfficeDocID "); SqlParameter[] parameters = { new SqlParameter("@OfficeDocID", SqlDbType.VarChar, 36) }; parameters[0].Value = OfficeDocID; IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); try { OfficeDocItemDAL itemBll = new OfficeDocItemDAL(); itemBll.DelOfficeDocItem(OfficeDocID); DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters); transaction.Commit(); } catch { transaction.Rollback(); } return(1); }
/// <summary> /// 修改用户 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(UserInfo model) { URrelationDAL urDal = new URrelationDAL(); StringBuilder strSql = new StringBuilder(); strSql.Append("update OA_User set "); strSql.Append("UserCode=@UserCode,"); strSql.Append("UserName=@UserName,"); strSql.Append("UserState=@UserState,"); strSql.Append("DeptID=@DeptID,"); strSql.Append("Operator=@Operator"); strSql.Append(" where UserID=@UserID "); SqlParameter[] parameters = { new SqlParameter("@UserCode", SqlDbType.NVarChar, 20), new SqlParameter("@UserName", SqlDbType.VarChar, 20), new SqlParameter("@UserState", SqlDbType.Char, 1), new SqlParameter("@DeptID", SqlDbType.VarChar, 36), new SqlParameter("@Operator", SqlDbType.NVarChar, 30), new SqlParameter("@UserID", SqlDbType.VarChar, 36) }; parameters[0].Value = model.UserCode; parameters[1].Value = model.UserName; parameters[2].Value = model.UserState; parameters[3].Value = model.DeptID; parameters[4].Value = model.Operator; parameters[5].Value = model.UserID; IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); try { int rows = DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters); if (rows > 0) { urDal.Delete(model.UserID); URrelation ur = new URrelation(); ur.ID = System.Guid.NewGuid().ToString(); ur.UserID = model.UserID; ur.RoleID = model.RoleID; urDal.Add(ur); transaction.Commit(); return(true); } else { return(false); } } catch { transaction.Rollback(); } return(false); }
/// <summary> /// 新增到货单 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddReachGoodsBill(ReachGoodsBill model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OA_ReachGoodsBill("); strSql.Append("ReachGoodsBillID,ReachGoodsBillCode,BuyOrderCode,ReachGoodsDate,CreateBillTime,CreateUserID,InforPerson,Remark,BuyOrderID)"); strSql.Append(" values ("); strSql.Append("@ReachGoodsBillID,@ReachGoodsBillCode,@BuyOrderCode,@ReachGoodsDate,@CreateBillTime,@CreateUserID,@InforPerson,@Remark,@BuyOrderID)"); SqlParameter[] parameters = { new SqlParameter("@ReachGoodsBillID", SqlDbType.VarChar, 36), new SqlParameter("@ReachGoodsBillCode", SqlDbType.NVarChar, 50), new SqlParameter("@BuyOrderCode", SqlDbType.NVarChar, 50), new SqlParameter("@ReachGoodsDate", SqlDbType.Char, 8), new SqlParameter("@CreateBillTime", SqlDbType.DateTime), new SqlParameter("@CreateUserID", SqlDbType.VarChar, 36), new SqlParameter("@InforPerson", SqlDbType.VarChar, 36), new SqlParameter("@Remark", SqlDbType.NVarChar, 300), new SqlParameter("@BuyOrderID", SqlDbType.VarChar, 36) }; parameters[0].Value = model.ReachGoodsBillID; parameters[1].Value = model.ReachGoodsBillCode; parameters[2].Value = model.BuyOrderCode; parameters[3].Value = model.ReachGoodsDate; parameters[4].Value = model.CreateBillTime; parameters[5].Value = model.CreateUserID; parameters[6].Value = model.InforPerson; parameters[7].Value = model.Remark; parameters[8].Value = model.BuyOrderID; IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); try { DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters); ReachGoodsBillItemDAL item = new ReachGoodsBillItemDAL(); item.Save(model.ReachGoodsBillID); transaction.Commit(); } catch { transaction.Rollback(); } return(1); }
/// <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); } }
/// <summary> /// 新增公章申请 /// </summary> /// <param name="model"></param> /// <param name="list"></param> /// <returns></returns> public bool Add(OA.Model.ApplyPublicPower model, IList <ApplyPublicPowerItem> list) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ApplyPublicPower("); strSql.Append("AppID,DeptID,ApplyDate,Creator,CreateTime,FirstChecker,SecondChecker)"); strSql.Append(" values ("); strSql.Append("@AppID,@DeptID,@ApplyDate,@Creator,@CreateTime,@FirstChecker,@SecondChecker)"); SqlParameter[] parameters = { new SqlParameter("@AppID", SqlDbType.VarChar, 36), new SqlParameter("@DeptID", SqlDbType.VarChar, 36), new SqlParameter("@ApplyDate", SqlDbType.Char, 8), new SqlParameter("@Creator", SqlDbType.VarChar, 36), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@FirstChecker", SqlDbType.VarChar, 36), new SqlParameter("@SecondChecker", SqlDbType.VarChar, 36) }; parameters[0].Value = model.AppID; parameters[1].Value = model.DeptID; parameters[2].Value = model.ApplyDate; parameters[3].Value = model.Creator; parameters[4].Value = model.CreateTime; parameters[5].Value = model.FirstChecker; parameters[6].Value = model.SecondChecker; IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); try { DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters); ApplyPublicPowerItemDAL itemBll = new ApplyPublicPowerItemDAL(); for (int i = 0; i < list.Count; i++) { ApplyPublicPowerItem item = list[i] as ApplyPublicPowerItem; itemBll.Add(item); } transaction.Commit(); } catch { transaction.Rollback(); } return(true); }
/// <summary> /// 新增公文 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddOfficeDoc(OfficeDoc model, IList <OfficeDocItem> list) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OA_OfficeDoc("); strSql.Append("OfficeDocID,Title,Contents,WriterID,WriteTime)"); strSql.Append(" values ("); strSql.Append("@OfficeDocID,@Title,@Contents,@WriterID,@WriteTime)"); SqlParameter[] parameters = { new SqlParameter("@OfficeDocID", SqlDbType.VarChar, 36), new SqlParameter("@Title", SqlDbType.NVarChar, 100), new SqlParameter("@Contents", SqlDbType.Text), new SqlParameter("@WriterID", SqlDbType.VarChar, 36), new SqlParameter("@WriteTime", SqlDbType.DateTime) }; parameters[0].Value = model.OfficeDocID; parameters[1].Value = model.Title; parameters[2].Value = model.Contents; parameters[3].Value = model.WriterID; parameters[4].Value = model.WriteTime; IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); try { DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters); OfficeDocItemDAL itemBll = new OfficeDocItemDAL(); for (int i = 0; i < list.Count; i++) { OfficeDocItem item = list[i] as OfficeDocItem; itemBll.AddOfficeDocItem(item); } transaction.Commit(); } catch { transaction.Rollback(); } return(1); }
/// <summary> /// 取消提交 /// </summary> /// <param name="BuyOrderID">采购订单ID</param> /// <returns></returns> public bool UnSubmit(string BuyOrderID) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BuyOrder set "); strSql.Append("OrderState='1',"); strSql.Append("FirstChecker='',"); strSql.Append("FirstCheckView='',"); strSql.Append("SecondCheckerName='',"); strSql.Append("ReaderName=''"); strSql.Append(" where BuyOrderID=@BuyOrderID "); SqlParameter[] parameters = { new SqlParameter("@BuyOrderID", SqlDbType.VarChar, 36) }; parameters[0].Value = BuyOrderID; IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); try { DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters); BOSecondCheckDAL boSC = new BOSecondCheckDAL(); boSC.Delete(BuyOrderID); BOReaderDAL bSC = new BOReaderDAL(); bSC.Delete(BuyOrderID); transaction.Commit(); return(true); } catch { transaction.Rollback(); } return(false); }
/// <summary> /// 复审 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool SecondCheck(SaleOrder model, SOSecondCheck soc) { SOSecondCheckDAL socDal = new SOSecondCheckDAL(); StringBuilder strSql = new StringBuilder(); strSql.Append("update SaleOrder set "); strSql.Append("SaleState=@SaleState"); strSql.Append(" where SaleOrderID=@SaleOrderID "); SqlParameter[] parameters = { new SqlParameter("@SaleState", SqlDbType.Char, 1), new SqlParameter("@SaleOrderID", SqlDbType.VarChar, 36) }; parameters[0].Value = model.SaleState; parameters[1].Value = model.SaleOrderID; IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); try { socDal.Check(soc); if (socDal.IsCheck(model.SaleOrderID)) { DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters); } transaction.Commit(); } catch { transaction.Rollback(); } return(true); }
/// <summary> /// 复审 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool SecondCheck(AskPrice model, APSecondCheck apsc) { APSecondCheckDAL apscDal = new APSecondCheckDAL(); StringBuilder strSql = new StringBuilder(); strSql.Append("update AskPrice set "); strSql.Append("State=@State"); strSql.Append(" where APID=@APID "); SqlParameter[] parameters = { new SqlParameter("@State", SqlDbType.Char, 1), new SqlParameter("@APID", SqlDbType.VarChar, 36) }; parameters[0].Value = model.State; parameters[1].Value = model.APID; IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); try { apscDal.Check(apsc); if (apscDal.IsCheck(model.APID)) { DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters); } transaction.Commit(); } catch { transaction.Rollback(); } return(true); }
/// <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); }
/// <summary> /// 修改采购单 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateBuyBill(BuyBill model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BuyOrder set "); strSql.Append("BuyOrderCode=@BuyOrderCode,"); strSql.Append("BuyOrderDate=@BuyOrderDate,"); 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 BuyOrderID=@BuyOrderID "); SqlParameter[] parameters = { 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("@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("@BuyOrderID", SqlDbType.VarChar, 36) }; parameters[0].Value = model.BuyOrderCode; parameters[1].Value = model.BuyOrderDate; 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.BuyOrderID; 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 socount = model.CList.Count; if (socount > 0) { boSC.Delete(model.BuyOrderID); for (int i = 0; i < socount; i++) { BOSecondCheck bosc = model.CList[i] as BOSecondCheck; boSC.Add(bosc); } } BOReaderDAL rSC = new BOReaderDAL(); int rcount = model.RList.Count; if (rcount > 0) { rSC.Delete(model.BuyOrderID); for (int i = 0; i < rcount; i++) { BOReader sor = model.RList[i] as BOReader; rSC.Add(sor); } } transaction.Commit(); } catch { transaction.Rollback(); } return(true); }
public override bool Save(params AskPrice[] entities) { if (entities == null || entities.Length < 1) { return(false); } //Logger.LogInfo(entities.SerializeToJson()); StringBuilder sbSqlAskPrice = new StringBuilder(); List <Func <bool> > saveItemsFuncs = new List <Func <bool> >(); List <SqlParameter> sqlParams = new List <SqlParameter>(); AskPrice entity = null; for (int i = 0; i < entities.Length; i++) { entity = entities[i]; //1、组织sql //①询价单 if (ValidateUtil.isBlank(entity.APID)) { //新增,保存部分字段 entity.APID = Guid.NewGuid().ToString(); sbSqlAskPrice.AppendFormat("insert into {0}(APID,APCode,APType,AskDate,ClientID,PayTypeID,TrackDescription,ClientSurvey,APRemark,Creator,CreateTime,State)", TableName); sbSqlAskPrice.AppendFormat(" values (@APID{0},@APCode{0},@APType{0},@AskDate{0},@ClientID{0},@PayTypeID{0},@TrackDescription{0},@ClientSurvey{0},@APRemark{0},@Creator{0},@CreateTime{0},@State{0});", i); sqlParams.AddRange(new SqlParameter[] { new SqlParameter { ParameterName = "@Creator" + i, Value = entity.Creator }, new SqlParameter { ParameterName = "@CreateTime" + i, Value = entity.CreateTime }, new SqlParameter { ParameterName = "@State" + i, Value = entity.State }, }); } else { //修改,只更新部分字段 sbSqlAskPrice.AppendFormat("update {0} set APType=@APType{1},AskDate=@AskDate{1},ClientID=@ClientID{1},PayTypeID=@PayTypeID{1},TrackDescription=@TrackDescription{1},ClientSurvey=@ClientSurvey{1},APRemark=@APRemark{1},Editor=@Editor{1},EditTime=@EditTime{1}", TableName, i); sbSqlAskPrice.AppendFormat(" where APID=@APID{0};", i); sqlParams.AddRange(new SqlParameter[] { new SqlParameter { ParameterName = "@Editor" + i, Value = entity.Editor }, new SqlParameter { ParameterName = "@EditTime" + i, Value = entity.EditTime }, }); } //不管新增或修改, 参数都一样 sqlParams.AddRange(new SqlParameter[] { new SqlParameter { ParameterName = "@APID" + i, Value = entity.APID }, new SqlParameter { ParameterName = "@APCode" + i, Value = entity.APCode }, new SqlParameter { ParameterName = "@APType" + i, Value = entity.APType }, new SqlParameter { ParameterName = "@AskDate" + i, Value = entity.AskDate }, new SqlParameter { ParameterName = "@ClientID" + i, Value = entity.ClientID }, new SqlParameter { ParameterName = "@PayTypeID" + i, Value = entity.PayTypeID }, new SqlParameter { ParameterName = "@TrackDescription" + i, Value = entity.TrackDescription }, new SqlParameter { ParameterName = "@ClientSurvey" + i, Value = entity.ClientSurvey }, new SqlParameter { ParameterName = "@APRemark" + i, Value = entity.APRemark }, }); //②询价单行 if (entity.Items != null && entity.Items.Count > 0) { foreach (var item in entity.Items) { item.APID = entity.APID; saveItemsFuncs.Add(() => { //调用AskPriceItemDAL.Save return(apItemDAL.Save(entity.Items.ToArray())); }); } } } //2、执行sql IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); int rst = 0; try { rst = DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, sbSqlAskPrice.ToString(), sqlParams.ToArray()); //保存询价单行 if (saveItemsFuncs.Count > 0) { foreach (var func in saveItemsFuncs) { func(); } } //提交 transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); base.Logger.LogError(ex); return(false); } //3、返回成功或失败的标志 return(rst > 0); }
public override bool Save(params GoodsMovement[] entities) { if (entities == null || entities.Length < 1) { return(false); } //Logger.LogInfo(entities.SerializeToJson()); StringBuilder sbSqlGM = new StringBuilder(); List <Func <bool> > saveItemsFuncs = new List <Func <bool> >(); List <SqlParameter> sqlParams = new List <SqlParameter>(); GoodsMovement entity = null; for (int i = 0; i < entities.Length; i++) { entity = entities[i]; //1、组织sql //①货物移动 if (ValidateUtil.isBlank(entity.GoodsMovementID)) { //新增,保存部分字段 entity.GoodsMovementID = Guid.NewGuid().ToString(); sbSqlGM.AppendFormat("insert into {0}(GoodsMovementID,BusinessType,MoveTypeCode,GoodsMovementCode,CreateDate,ReceiptDate,RecDeptID,RecHandler,RecWHID,RecWHEmpID,IssDate,IssDeptID,IssHandler,IssWHID,IssWHEmpID,PurDeptID,PurEmpID,SupplierID,SalesDepID,SalesEmpID,CustomerID,ProDepID,ProEmpID,ConDepID,ConEmpID,Creator,CreateTime,BillState,IsRed,Remark)", TableName); sbSqlGM.AppendFormat(" values (@GoodsMovementID{0},@BusinessType{0},@MoveTypeCode{0},@GoodsMovementCode{0},@CreateDate{0},@ReceiptDate{0},@RecDeptID{0},@RecHandler{0},@RecWHID{0},@RecWHEmpID{0},@IssDate{0},@IssDeptID{0},@IssHandler{0},@IssWHID{0},@IssWHEmpID{0},@PurDeptID{0},@PurEmpID{0},@SupplierID{0},@SalesDepID{0},@SalesEmpID{0},@CustomerID{0},@ProDepID{0},@ProEmpID{0},@ConDepID{0},@ConEmpID{0},@Creator{0},@CreateTime{0},@BillState{0},@IsRed{0},@Remark{0});", i); sqlParams.AddRange(new SqlParameter[] { new SqlParameter { ParameterName = "@Creator" + i, Value = entity.Creator }, new SqlParameter { ParameterName = "@CreateTime" + i, Value = entity.CreateTime }, new SqlParameter { ParameterName = "@BillState" + i, Value = entity.BillState }, }); } else { //修改,只更新部分字段 sbSqlGM.AppendFormat("update {0} set BusinessType=@BusinessType{1},MoveTypeCode=@MoveTypeCode{1},CreateDate=@CreateDate{1},ReceiptDate=@ReceiptDate{1},RecDeptID=@RecDeptID{1},RecHandler=@RecHandler{1},RecWHID=@RecWHID{1},RecWHEmpID=@RecWHEmpID{1},IssDate=@IssDate{1},IssDeptID=@IssDeptID{1},IssHandler=@IssHandler{1},IssWHID=@IssWHID{1},IssWHEmpID=@IssWHEmpID{1},PurDeptID=@PurDeptID{1},PurEmpID=@PurEmpID{1},SupplierID=@SupplierID{1},SalesDepID=@SalesDepID{1},SalesEmpID=@SalesEmpID{1},CustomerID=@CustomerID{1},ProDepID=@ProDepID{1},ProEmpID=@ProEmpID{1},ConDepID=@ConDepID{1},ConEmpID=@ConEmpID{1},IsRed=@IsRed{1},Remark=@Remark{1},Editor=@Editor{1},EditTime=@EditTime{1}", TableName, i); sbSqlGM.AppendFormat(" where GoodsMovementID=@GoodsMovementID{0};", i); sqlParams.AddRange(new SqlParameter[] { new SqlParameter { ParameterName = "@Editor" + i, Value = entity.Editor }, new SqlParameter { ParameterName = "@EditTime" + i, Value = entity.EditTime }, }); } //不管新增或修改, 参数都一样 sqlParams.AddRange(new SqlParameter[] { new SqlParameter { ParameterName = "@GoodsMovementID" + i, Value = entity.GoodsMovementID }, new SqlParameter { ParameterName = "@BusinessType" + i, Value = entity.BusinessType }, new SqlParameter { ParameterName = "@MoveTypeCode" + i, Value = entity.MoveTypeCode }, new SqlParameter { ParameterName = "@GoodsMovementCode" + i, Value = entity.GoodsMovementCode }, new SqlParameter { ParameterName = "@CreateDate" + i, Value = string.IsNullOrEmpty(entity.CreateDate)?null:entity.CreateDate.Replace("-", "") }, new SqlParameter { ParameterName = "@ReceiptDate" + i, Value = string.IsNullOrEmpty(entity.ReceiptDate)?null:entity.ReceiptDate.Replace("-", "") }, new SqlParameter { ParameterName = "@RecDeptID" + i, Value = entity.RecDeptID }, new SqlParameter { ParameterName = "@RecHandler" + i, Value = entity.RecHandler }, new SqlParameter { ParameterName = "@RecWHID" + i, Value = entity.RecWHID }, new SqlParameter { ParameterName = "@RecWHEmpID" + i, Value = entity.RecWHEmpID }, new SqlParameter { ParameterName = "@IssDate" + i, Value = string.IsNullOrEmpty(entity.IssDate)?null:entity.IssDate.Replace("-", "") }, new SqlParameter { ParameterName = "@IssDeptID" + i, Value = entity.IssDeptID }, new SqlParameter { ParameterName = "@IssHandler" + i, Value = entity.IssHandler }, new SqlParameter { ParameterName = "@IssWHID" + i, Value = entity.IssWHID }, new SqlParameter { ParameterName = "@IssWHEmpID" + i, Value = entity.IssWHEmpID }, new SqlParameter { ParameterName = "@PurDeptID" + i, Value = entity.PurDeptID }, new SqlParameter { ParameterName = "@PurEmpID" + i, Value = entity.PurEmpID }, new SqlParameter { ParameterName = "@SupplierID" + i, Value = entity.SupplierID }, new SqlParameter { ParameterName = "@SalesDepID" + i, Value = entity.SalesDepID }, new SqlParameter { ParameterName = "@SalesEmpID" + i, Value = entity.SalesEmpID }, new SqlParameter { ParameterName = "@CustomerID" + i, Value = entity.CustomerID }, new SqlParameter { ParameterName = "@ProDepID" + i, Value = entity.ProDepID }, new SqlParameter { ParameterName = "@ProEmpID" + i, Value = entity.ProEmpID }, new SqlParameter { ParameterName = "@ConDepID" + i, Value = entity.ConDepID }, new SqlParameter { ParameterName = "@ConEmpID" + i, Value = entity.ConEmpID }, new SqlParameter { ParameterName = "@IsRed" + i, Value = entity.IsRed }, new SqlParameter { ParameterName = "@Remark" + i, Value = entity.Remark }, }); //②货物移动行 if (entity.Items != null && entity.Items.Count > 0) { foreach (var item in entity.Items) { item.GoodsMovementID = entity.GoodsMovementID; saveItemsFuncs.Add(() => { //调用GoodsMovementItemDAL.Save return(gmItemDAL.Save(entity.Items.ToArray())); }); } } } //2、执行sql IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); int rst = 0; try { rst = DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, sbSqlGM.ToString(), sqlParams.ToArray()); //保存货物移动行 if (saveItemsFuncs.Count > 0) { foreach (var func in saveItemsFuncs) { func(); } } //提交 transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); base.Logger.LogError(ex); return(false); } //3、返回成功或失败的标志 return(rst > 0); }
/// <summary> /// 新增 /// </summary> /// <param name="model">用户实体类</param> /// <returns>用户ID</returns> public bool Add(OA.Model.UserInfo userInfo) { URrelationDAL urDal = new URrelationDAL(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OA_User("); strSql.Append("UserID,UserCode,UserName,UserPwd,UserState,CreateTime,CreateUserID,DeptID,Operator)"); strSql.Append(" values ("); strSql.Append("@UserID,@UserCode,@UserName,@UserPwd,@UserState,@CreateTime,@CreateUserID,@DeptID,@Operator)"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.VarChar, 36), new SqlParameter("@UserCode", SqlDbType.NVarChar, 20), new SqlParameter("@UserName", SqlDbType.VarChar, 20), new SqlParameter("@UserPwd", SqlDbType.VarChar, 36), new SqlParameter("@UserState", SqlDbType.Char, 1), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUserID", SqlDbType.VarChar, 36), new SqlParameter("@DeptID", SqlDbType.VarChar, 36), new SqlParameter("@Operator", SqlDbType.NVarChar, 30) }; parameters[0].Value = userInfo.UserID; parameters[1].Value = userInfo.UserCode; parameters[2].Value = userInfo.UserName; parameters[3].Value = userInfo.UserPwd; parameters[4].Value = userInfo.UserState; parameters[5].Value = userInfo.CreateTime; parameters[6].Value = userInfo.CreateUserID; parameters[7].Value = userInfo.DeptID; parameters[8].Value = userInfo.Operator; IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); try { int obj = DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters); if (obj > 0) { urDal.Delete(userInfo.UserID); URrelation ur = new URrelation(); ur.ID = System.Guid.NewGuid().ToString(); ur.UserID = userInfo.UserID; ur.RoleID = userInfo.RoleID; urDal.Add(ur); transaction.Commit(); return(true); } else { return(false); } } catch { transaction.Rollback(); } return(false); }
public override bool Save(params BuyOrder[] entities) { if (entities == null || entities.Length < 1) { return(false); } //Logger.LogInfo(entities.SerializeToJson()); StringBuilder sbSqlSaleOrder = new StringBuilder(); List <Func <bool> > saveItemsFuncs = new List <Func <bool> >(); List <SqlParameter> sqlParams = new List <SqlParameter>(); BuyOrder entity = null; for (int i = 0; i < entities.Length; i++) { entity = entities[i]; //1、组织sql //①采购订单 if (ValidateUtil.isBlank(entity.BuyOrderID)) { //新增,保存部分字段 entity.BuyOrderID = Guid.NewGuid().ToString(); sbSqlSaleOrder.AppendFormat("insert into {0}(BuyOrderID,BuyOrderCode,BuyOrderDate,SupplierID,DeliveryDate,Creator,CreateTime,OrderState,Remark)", TableName); sbSqlSaleOrder.AppendFormat(" values (@BuyOrderID{0},@BuyOrderCode{0},@BuyOrderDate{0},@SupplierID{0},@DeliveryDate{0},@Creator{0},@CreateTime{0},@OrderState{0},@Remark{0});", i); sqlParams.AddRange(new SqlParameter[] { new SqlParameter { ParameterName = "@Creator" + i, Value = entity.Creator }, new SqlParameter { ParameterName = "@CreateTime" + i, Value = entity.CreateTime }, new SqlParameter { ParameterName = "@OrderState" + i, Value = entity.OrderState }, }); } else { //修改,只更新部分字段 sbSqlSaleOrder.AppendFormat("update {0} set BuyOrderDate=@BuyOrderDate{1},SupplierID=@SupplierID{1},DeliveryDate=@DeliveryDate{1},Editor=@Editor{1},EditTime=@EditTime{1},Remark=@Remark{1}", TableName, i); sbSqlSaleOrder.AppendFormat(" where BuyOrderID=@BuyOrderID{0};", i); sqlParams.AddRange(new SqlParameter[] { new SqlParameter { ParameterName = "@Editor" + i, Value = entity.Editor }, new SqlParameter { ParameterName = "@EditTime" + i, Value = entity.EditTime }, }); } //不管新增或修改, 参数都一样 sqlParams.AddRange(new SqlParameter[] { new SqlParameter { ParameterName = "@BuyOrderID" + i, Value = entity.BuyOrderID }, new SqlParameter { ParameterName = "@BuyOrderCode" + i, Value = entity.BuyOrderCode }, new SqlParameter { ParameterName = "@BuyOrderDate" + i, Value = entity.BuyOrderDate.Replace("-", "") }, new SqlParameter { ParameterName = "@SupplierID" + i, Value = entity.SupplierID }, new SqlParameter { ParameterName = "@DeliveryDate" + i, Value = entity.DeliveryDate.Replace("-", "") }, new SqlParameter { ParameterName = "@Remark" + i, Value = entity.Remark } }); //②采购订单行 if (entity.Items != null && entity.Items.Count > 0) { foreach (var item in entity.Items) { item.BuyOrderID = entity.BuyOrderID; saveItemsFuncs.Add(() => { //调用BuyOrderItemDAL.Save return(boItemDAL.Save(entity.Items.ToArray())); }); } } } //2、执行sql IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); int rst = 0; try { rst = DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, sbSqlSaleOrder.ToString(), sqlParams.ToArray()); //保存销售订单行 if (saveItemsFuncs.Count > 0) { foreach (var func in saveItemsFuncs) { func(); } } //提交 transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); base.Logger.LogError(ex); return(false); } //3、返回成功或失败的标志 return(rst > 0); }
/// <summary> /// 新增销售订单 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddSaleOrder(SaleOrder model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SaleOrder("); strSql.Append("SaleOrderID,SaleOrderCode,BillTypeID,MaterialID,SaleUnitID,ClientID,SaleDate,SaleQty,SalePrice,SaleCost,FinishDate,Creator,CreateTime,Editor,EditTime,FirstChecker,FirstCheckTime,FirstCheckView,RoutingID,SaleState,Remark,SecondCheckerName,ReaderName,Routing)"); strSql.Append(" values ("); strSql.Append("@SaleOrderID,@SaleOrderCode,@BillTypeID,@MaterialID,@SaleUnitID,@ClientID,@SaleDate,@SaleQty,@SalePrice,@SaleCost,@FinishDate,@Creator,@CreateTime,@Editor,@EditTime,@FirstChecker,@FirstCheckTime,@FirstCheckView,@RoutingID,@SaleState,@Remark,@SecondCheckerName,@ReaderName,@Routing)"); SqlParameter[] parameters = { new SqlParameter("@SaleOrderID", SqlDbType.VarChar, 36), new SqlParameter("@SaleOrderCode", SqlDbType.VarChar, 60), new SqlParameter("@BillTypeID", SqlDbType.VarChar, 36), new SqlParameter("@MaterialID", SqlDbType.VarChar, 36), new SqlParameter("@SaleUnitID", SqlDbType.VarChar, 36), new SqlParameter("@ClientID", SqlDbType.VarChar, 36), new SqlParameter("@SaleDate", SqlDbType.Char, 8), new SqlParameter("@SaleQty", SqlDbType.Decimal, 13), new SqlParameter("@SalePrice", SqlDbType.Decimal, 13), new SqlParameter("@SaleCost", SqlDbType.Decimal, 13), new SqlParameter("@FinishDate", 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("@FirstCheckTime", SqlDbType.DateTime), new SqlParameter("@FirstCheckView", SqlDbType.VarChar, 255), new SqlParameter("@RoutingID", SqlDbType.VarChar, 36), new SqlParameter("@SaleState", SqlDbType.Char, 1), new SqlParameter("@Remark", SqlDbType.VarChar, 1024), new SqlParameter("@SecondCheckerName", SqlDbType.VarChar, 255), new SqlParameter("@ReaderName", SqlDbType.VarChar, 255), new SqlParameter("@Routing", SqlDbType.VarChar, 1024) }; parameters[0].Value = model.SaleOrderID; parameters[1].Value = model.SaleOrderCode; parameters[2].Value = model.BillTypeID; parameters[3].Value = model.MaterialID; parameters[4].Value = model.SaleUnitID; parameters[5].Value = model.ClientID; parameters[6].Value = model.SaleDate; parameters[7].Value = model.SaleQty; parameters[8].Value = model.SalePrice; parameters[9].Value = model.SaleCost; parameters[10].Value = model.FinishDate; parameters[11].Value = model.Creator; parameters[12].Value = model.CreateTime; parameters[13].Value = model.Editor; parameters[14].Value = model.EditTime; parameters[15].Value = model.FirstChecker; parameters[16].Value = model.FirstCheckTime; parameters[17].Value = model.FirstCheckView; parameters[18].Value = model.RoutingID; parameters[19].Value = model.SaleState; parameters[20].Value = model.Remark; parameters[21].Value = model.SecondCheckerName; parameters[22].Value = model.ReaderName; parameters[23].Value = model.Routing; IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); try { DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters); SOSecondCheckDAL soSC = new SOSecondCheckDAL(); int socount = model.SOList.Count; if (socount > 0) { for (int i = 0; i < socount; i++) { SOSecondCheck sosc = model.SOList[i] as SOSecondCheck; soSC.Add(sosc); } } SOReaderDAL rSC = new SOReaderDAL(); int rcount = model.RList.Count; if (rcount > 0) { for (int i = 0; i < rcount; i++) { SOReader sor = model.RList[i] as SOReader; rSC.Add(sor); } } SaleOrderItemDAL item = new SaleOrderItemDAL(); item.Save(model.SaleOrderID, model.OldSaleOrderID); transaction.Commit(); } catch { transaction.Rollback(); } return(1); }
/// <summary> /// 修改销售订单 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateSaleOrder(SaleOrder model) { StringBuilder strSql = new StringBuilder();; strSql.Append("update SaleOrder set "); strSql.Append("BillTypeID=@BillTypeID,"); strSql.Append("MaterialID=@MaterialID,"); strSql.Append("SaleUnitID=@SaleUnitID,"); strSql.Append("ClientID=@ClientID,"); strSql.Append("SaleDate=@SaleDate,"); strSql.Append("SaleQty=@SaleQty,"); strSql.Append("SalePrice=@SalePrice,"); strSql.Append("SaleCost=@SaleCost,"); strSql.Append("FinishDate=@FinishDate,"); strSql.Append("Editor=@Editor,"); strSql.Append("EditTime=@EditTime,"); strSql.Append("FirstChecker=@FirstChecker,"); strSql.Append("RoutingID=@RoutingID,"); strSql.Append("Remark=@Remark,"); strSql.Append("SecondCheckerName=@SecondCheckerName,"); strSql.Append("ReaderName=@ReaderName,"); strSql.Append("Routing=@Routing"); strSql.Append(" where SaleOrderID=@SaleOrderID "); SqlParameter[] parameters = { new SqlParameter("@BillTypeID", SqlDbType.VarChar, 36), new SqlParameter("@MaterialID", SqlDbType.VarChar, 36), new SqlParameter("@SaleUnitID", SqlDbType.VarChar, 36), new SqlParameter("@ClientID", SqlDbType.VarChar, 36), new SqlParameter("@SaleDate", SqlDbType.Char, 8), new SqlParameter("@SaleQty", SqlDbType.Decimal, 13), new SqlParameter("@SalePrice", SqlDbType.Decimal, 13), new SqlParameter("@SaleCost", SqlDbType.Decimal, 13), new SqlParameter("@FinishDate", SqlDbType.Char, 8), new SqlParameter("@Editor", SqlDbType.VarChar, 36), new SqlParameter("@EditTime", SqlDbType.DateTime), new SqlParameter("@FirstChecker", SqlDbType.VarChar, 36), new SqlParameter("@RoutingID", SqlDbType.VarChar, 36), new SqlParameter("@Remark", SqlDbType.VarChar, 1024), new SqlParameter("@SecondCheckerName", SqlDbType.VarChar, 255), new SqlParameter("@ReaderName", SqlDbType.VarChar, 255), new SqlParameter("@Routing", SqlDbType.VarChar, 1024), new SqlParameter("@SaleOrderID", SqlDbType.VarChar, 36) }; parameters[0].Value = model.BillTypeID; parameters[1].Value = model.MaterialID; parameters[2].Value = model.SaleUnitID; parameters[3].Value = model.ClientID; parameters[4].Value = model.SaleDate; parameters[5].Value = model.SaleQty; parameters[6].Value = model.SalePrice; parameters[7].Value = model.SaleCost; parameters[8].Value = model.FinishDate; parameters[9].Value = model.Editor; parameters[10].Value = model.EditTime; parameters[11].Value = model.FirstChecker; parameters[12].Value = model.RoutingID; parameters[13].Value = model.Remark; parameters[14].Value = model.SecondCheckerName; parameters[15].Value = model.ReaderName; parameters[16].Value = model.Routing; parameters[17].Value = model.SaleOrderID; IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); try { DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters); SOSecondCheckDAL soSC = new SOSecondCheckDAL(); int socount = model.SOList.Count; if (socount > 0) { soSC.Delete(model.SaleOrderID); for (int i = 0; i < socount; i++) { SOSecondCheck sosc = model.SOList[i] as SOSecondCheck; soSC.Add(sosc); } } SOReaderDAL rSC = new SOReaderDAL(); int rcount = model.RList.Count; if (rcount > 0) { rSC.Delete(model.SaleOrderID); for (int i = 0; i < rcount; i++) { SOReader sor = model.RList[i] as SOReader; rSC.Add(sor); } } transaction.Commit(); } catch { transaction.Rollback(); } return(true); }
/// <summary> /// 修改询价单 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateAskPrice(AskPrice model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AskPrice set "); strSql.Append("APCode=@APCode,"); strSql.Append("AskDate=@AskDate,"); strSql.Append("ClientName=@ClientName,"); strSql.Append("ClientContact=@ClientContact,"); strSql.Append("ClientTel=@ClientTel,"); strSql.Append("ClientAddress=@ClientAddress,"); strSql.Append("MaterialCode=@MaterialCode,"); strSql.Append("MaterialName=@MaterialName,"); strSql.Append("Specs=@Specs,"); strSql.Append("Routing=@Routing,"); strSql.Append("PlanPrice=@PlanPrice,"); strSql.Append("Issued=@Issued,"); strSql.Append("IssuedCount=@IssuedCount,"); strSql.Append("ActualPrice=@ActualPrice,"); strSql.Append("PayTypeID=@PayTypeID,"); strSql.Append("TrackDescription=@TrackDescription,"); strSql.Append("ClientSurvey=@ClientSurvey,"); strSql.Append("APRemark=@APRemark,"); strSql.Append("Creator=@Creator,"); strSql.Append("Editor=@Editor,"); strSql.Append("EditTime=@EditTime,"); strSql.Append("FirstChecker=@FirstChecker,"); strSql.Append("State=@State,"); strSql.Append("SecondCheckerName=@SecondCheckerName,"); strSql.Append("ReaderName=@ReaderName,"); strSql.Append("Qty=@Qty,"); strSql.Append("UnitID=@UnitID,"); strSql.Append("IsTax=@IsTax,"); strSql.Append("IsShipping=@IsShipping"); strSql.Append(" where APID=@APID "); SqlParameter[] parameters = { new SqlParameter("@APCode", SqlDbType.VarChar, 30), new SqlParameter("@AskDate", SqlDbType.Char, 8), new SqlParameter("@ClientName", SqlDbType.VarChar, 60), new SqlParameter("@ClientContact", SqlDbType.VarChar, 30), new SqlParameter("@ClientTel", SqlDbType.VarChar, 30), new SqlParameter("@ClientAddress", SqlDbType.VarChar, 90), new SqlParameter("@MaterialCode", SqlDbType.VarChar, 60), new SqlParameter("@MaterialName", SqlDbType.VarChar, 90), new SqlParameter("@Specs", SqlDbType.VarChar, 90), new SqlParameter("@Routing", SqlDbType.VarChar, 1024), new SqlParameter("@PlanPrice", SqlDbType.Decimal, 9), new SqlParameter("@Issued", SqlDbType.Char, 1), new SqlParameter("@IssuedCount", SqlDbType.Int, 4), new SqlParameter("@ActualPrice", SqlDbType.Decimal, 9), new SqlParameter("@PayTypeID", SqlDbType.VarChar, 36), new SqlParameter("@TrackDescription", SqlDbType.VarChar, 1024), new SqlParameter("@ClientSurvey", SqlDbType.VarChar, 1024), new SqlParameter("@APRemark", SqlDbType.VarChar, 1024), new SqlParameter("@Creator", SqlDbType.VarChar, 36), new SqlParameter("@Editor", SqlDbType.VarChar, 36), new SqlParameter("@EditTime", SqlDbType.DateTime), new SqlParameter("@FirstChecker", SqlDbType.VarChar, 36), new SqlParameter("@State", SqlDbType.Char, 1), new SqlParameter("@SecondCheckerName", SqlDbType.VarChar, 255), new SqlParameter("@ReaderName", SqlDbType.VarChar, 255), new SqlParameter("@Qty", SqlDbType.Decimal, 9), new SqlParameter("@UnitID", SqlDbType.VarChar, 36), new SqlParameter("@IsTax", SqlDbType.Char, 1), new SqlParameter("@IsShipping", SqlDbType.Char, 1), new SqlParameter("@APID", SqlDbType.VarChar, 36) }; parameters[0].Value = model.APCode; parameters[1].Value = model.AskDate; parameters[2].Value = model.ClientName; parameters[3].Value = model.ClientContact; parameters[4].Value = model.ClientTel; parameters[5].Value = model.ClientAddress; parameters[6].Value = model.MaterialCode; parameters[7].Value = model.MaterialName; parameters[8].Value = model.Specs; parameters[9].Value = model.Routing; parameters[10].Value = model.PlanPrice; parameters[11].Value = model.Issued; parameters[12].Value = model.IssuedCount; parameters[13].Value = model.ActualPrice; parameters[14].Value = model.PayTypeID; parameters[15].Value = model.TrackDescription; parameters[16].Value = model.ClientSurvey; parameters[17].Value = model.APRemark; parameters[18].Value = model.Creator; parameters[19].Value = model.Editor; parameters[20].Value = model.EditTime; parameters[21].Value = model.FirstChecker; parameters[22].Value = model.State; parameters[23].Value = model.SecondCheckerName; parameters[24].Value = model.ReaderName; parameters[25].Value = model.Qty; parameters[26].Value = model.UnitID; parameters[27].Value = model.IsTax; parameters[28].Value = model.IsShipping; parameters[29].Value = model.APID; IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); try { DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters); APSecondCheckDAL soSC = new APSecondCheckDAL(); int socount = model.SCList.Count; if (socount > 0) { soSC.Delete(model.APID); for (int i = 0; i < socount; i++) { APSecondCheck sosc = model.SCList[i] as APSecondCheck; soSC.Add(sosc); } } APReaderDAL rSC = new APReaderDAL(); int rcount = model.RList.Count; if (rcount > 0) { rSC.Delete(model.APID); for (int i = 0; i < rcount; i++) { APReader sor = model.RList[i] as APReader; rSC.Add(sor); } } transaction.Commit(); } catch { transaction.Rollback(); } return(true); }
/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddAskPrice(AskPrice model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AskPrice("); strSql.Append("APID,APCode,AskDate,ClientName,ClientContact,ClientTel,ClientAddress,MaterialCode,MaterialName,Specs,Routing,PlanPrice,Issued,IssuedCount,ActualPrice,PayTypeID,TrackDescription,ClientSurvey,APRemark,Creator,CreateTime,Editor,EditTime,FirstChecker,State,SecondCheckerName,ReaderName,Qty,UnitID,IsTax,IsShipping)"); strSql.Append(" values ("); strSql.Append("@APID,@APCode,@AskDate,@ClientName,@ClientContact,@ClientTel,@ClientAddress,@MaterialCode,@MaterialName,@Specs,@Routing,@PlanPrice,@Issued,@IssuedCount,@ActualPrice,@PayTypeID,@TrackDescription,@ClientSurvey,@APRemark,@Creator,@CreateTime,@Editor,@EditTime,@FirstChecker,@State,@SecondCheckerName,@ReaderName,@Qty,@UnitID,@IsTax,@IsShipping)"); SqlParameter[] parameters = { new SqlParameter("@APID", SqlDbType.VarChar, 36), new SqlParameter("@APCode", SqlDbType.VarChar, 30), new SqlParameter("@AskDate", SqlDbType.Char, 8), new SqlParameter("@ClientName", SqlDbType.VarChar, 60), new SqlParameter("@ClientContact", SqlDbType.VarChar, 30), new SqlParameter("@ClientTel", SqlDbType.VarChar, 30), new SqlParameter("@ClientAddress", SqlDbType.VarChar, 90), new SqlParameter("@MaterialCode", SqlDbType.VarChar, 60), new SqlParameter("@MaterialName", SqlDbType.VarChar, 90), new SqlParameter("@Specs", SqlDbType.VarChar, 90), new SqlParameter("@Routing", SqlDbType.VarChar, 1024), new SqlParameter("@PlanPrice", SqlDbType.Decimal, 9), new SqlParameter("@Issued", SqlDbType.Char, 1), new SqlParameter("@IssuedCount", SqlDbType.Int, 4), new SqlParameter("@ActualPrice", SqlDbType.Decimal, 9), new SqlParameter("@PayTypeID", SqlDbType.VarChar, 36), new SqlParameter("@TrackDescription", SqlDbType.VarChar, 1024), new SqlParameter("@ClientSurvey", SqlDbType.VarChar, 1024), new SqlParameter("@APRemark", SqlDbType.VarChar, 1024), 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("@State", SqlDbType.Char, 1), new SqlParameter("@SecondCheckerName", SqlDbType.VarChar, 255), new SqlParameter("@ReaderName", SqlDbType.VarChar, 255), new SqlParameter("@Qty", SqlDbType.Decimal, 9), new SqlParameter("@UnitID", SqlDbType.VarChar, 36), new SqlParameter("@IsTax", SqlDbType.Char, 1), new SqlParameter("@IsShipping", SqlDbType.Char, 1) }; parameters[0].Value = model.APID; parameters[1].Value = model.APCode; if (string.IsNullOrEmpty(model.APCode)) { parameters[1].Value = "XJ" + System.DateTime.Now.Year + System.DateTime.Now.Month + System.DateTime.Now.Day + System.DateTime.Now.Hour + System.DateTime.Now.Minute + System.DateTime.Now.Second + System.DateTime.Now.Millisecond; } parameters[2].Value = model.AskDate; parameters[3].Value = model.ClientName; parameters[4].Value = model.ClientContact; parameters[5].Value = model.ClientTel; parameters[6].Value = model.ClientAddress; parameters[7].Value = model.MaterialCode; parameters[8].Value = model.MaterialName; parameters[9].Value = model.Specs; parameters[10].Value = model.Routing; parameters[11].Value = model.PlanPrice; parameters[12].Value = model.Issued; parameters[13].Value = model.IssuedCount; parameters[14].Value = model.ActualPrice; parameters[15].Value = model.PayTypeID; parameters[16].Value = model.TrackDescription; parameters[17].Value = model.ClientSurvey; parameters[18].Value = model.APRemark; parameters[19].Value = model.Creator; parameters[20].Value = model.CreateTime; parameters[21].Value = model.Editor; parameters[22].Value = model.EditTime; parameters[23].Value = model.FirstChecker; parameters[24].Value = model.State; parameters[25].Value = model.SecondCheckerName; parameters[26].Value = model.ReaderName; parameters[27].Value = model.Qty; parameters[28].Value = model.UnitID; parameters[29].Value = model.IsTax; parameters[30].Value = model.IsShipping; IDbTransaction transaction = DBAccess.BeginDbTransaction(DB.Type, DB.ConnectionString); try { DBAccess.ExecuteNonQuery(DB.Type, DB.ConnectionString, CommandType.Text, strSql.ToString(), parameters); APSecondCheckDAL apSC = new APSecondCheckDAL(); int socount = model.SCList.Count; if (socount > 0) { for (int i = 0; i < socount; i++) { APSecondCheck apsc = model.SCList[i] as APSecondCheck; apSC.Add(apsc); } } APReaderDAL apR = new APReaderDAL(); int rcount = model.RList.Count; if (rcount > 0) { for (int i = 0; i < rcount; i++) { APReader sor = model.RList[i] as APReader; apR.Add(sor); } } transaction.Commit(); } catch { transaction.Rollback(); } return(1); }