public int addTran(VAN_OA.Model.EFrom.TB_UseCarDetail model, VAN_OA.Model.EFrom.tb_EForm eform) { int id = 0; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; try { model.State = eform.state; tb_EFormService eformSer = new tb_EFormService(); objCommand.Parameters.Clear(); string proNo = eformSer.GetAllE_No("TB_UseCarDetail", objCommand); model.ProNo = proNo; eform.E_No = proNo; id = Add(model, objCommand); eform.allE_id = id; eformSer.Add(eform, objCommand); tan.Commit(); } catch (Exception) { tan.Rollback(); return(0); } return(id); } }
public int addTran(VAN_OA.Model.JXC.CAI_OrderInHouse model, VAN_OA.Model.EFrom.tb_EForm eform, List <CAI_OrderInHouses> orders, SqlCommand objCommand) { int id = 0; CAI_OrderInHousesService OrdersSer = new CAI_OrderInHousesService(); TB_HouseGoodsService houseGoodsSer = new TB_HouseGoodsService(); objCommand.Parameters.Clear(); tb_EFormService eformSer = new tb_EFormService(); string proNo = eformSer.GetAllE_No("CAI_OrderInHouse", objCommand); model.ProNo = proNo; eform.E_No = proNo; model.Status = eform.state; id = Add(model, objCommand); eform.allE_id = id; eformSer.Add(eform, objCommand); for (int i = 0; i < orders.Count; i++) { orders[i].id = id; orders[i].Ids = OrdersSer.Add(orders[i], objCommand); if (eform.state == "通过") { houseGoodsSer.InHouse(model.HouseID, orders[i].GooId, orders[i].GoodNum, orders[i].GoodPrice, objCommand); } } return(id); }
public bool updateTran(VAN_OA.Model.EFrom.TB_UseCarDetail model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms) { using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; try { model.State = eform.state; objCommand.Parameters.Clear(); Update(model, objCommand); tb_EFormService eformSer = new tb_EFormService(); eformSer.Update(eform, objCommand); tb_EFormsService eformsSer = new tb_EFormsService(); eformsSer.Add(forms, objCommand); tan.Commit(); } catch (Exception) { tan.Rollback(); return(false); } } return(true); }
public bool updateTran(VAN_OA.Model.EFrom.TB_UseCarDetail model, VAN_OA.Model.EFrom.tb_EForm eform) { using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; try { model.State = eform.state; objCommand.Parameters.Clear(); Update(model, objCommand); string updateEform = string.Format("update tb_EForm set toPer={0} where id={1}", eform.toPer, eform.id); objCommand.CommandText = updateEform; objCommand.ExecuteNonQuery(); tan.Commit(); } catch (Exception) { tan.Rollback(); return(false); } } return(true); }
public bool updateTran(TB_ToInvoice model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms) { using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; try { model.State = eform.state; objCommand.Parameters.Clear(); model.UpAccount = accountXishu(model, eform, objCommand); Update(model, objCommand); tb_EFormService eformSer = new tb_EFormService(); eformSer.Update(eform, objCommand); tb_EFormsService eformsSer = new tb_EFormsService(); eformsSer.Add(forms, objCommand); //判断是否是删除 -到款单删除 if (eform.proId == 38 && eform.state == "通过") { //及到款单删除会有两个层面, //1,预付款模式,这时只需要在审批的最后一个流程总经理点确定时,删除相应的到款单;并弹出一个提示框,该预付到款单已删除,点确定,完成。 //2,发票到款模式,我们需要在最后一个审批流程点确定时,删除相应项目编号针对该发票号的发票签回单(如果有在审批执行中或已完成审批的),再删除该项目编号针对该发票号的到款单, //并弹出一个提示框,该发票到款单已删除,点确定,完成。 if (model.BusType == 0)//实际发票到款 { //删除发票签回单(如果有) string deleteFPBack = string.Format("delete tb_EForms where e_Id in (select id from tb_EForm where proId=29 and allE_id in (select id from Sell_OrderFPBack where PId={0}));", model.FPId); deleteFPBack += string.Format("delete tb_EForm where proId=29 and allE_id in (select id from Sell_OrderFPBack where PId={0});", model.FPId); deleteFPBack += string.Format("delete Sell_OrderFPBacks where Id in (select id from Sell_OrderFPBack where PId={0});delete Sell_OrderFPBack where PId={0};", model.FPId); objCommand.CommandText = deleteFPBack; objCommand.ExecuteNonQuery(); } //删除发票删除单 审批流 string deleteFPDelete = string.Format("delete tb_EForms where e_Id in (select id from tb_EForm where proId in (26,34,37) and allE_id={0});", model.Id); deleteFPDelete += string.Format("delete tb_EForm where proId in (27,38) and allE_id={0};", model.Id); objCommand.CommandText = deleteFPDelete; objCommand.ExecuteNonQuery(); string DeleteAll = string.Format("delete from [TB_ToInvoice] where id={0};", model.Id); objCommand.CommandText = DeleteAll; objCommand.ExecuteNonQuery(); } tan.Commit(); } catch (Exception) { tan.Rollback(); return(false); } } return(true); }
public int addTran(VAN_OA.Model.JXC.Sell_OrderOutHouse model, VAN_OA.Model.EFrom.tb_EForm eform, List <Sell_OrderOutHouses> orders, out int MainId) { decimal total = 0; for (int i = 0; i < orders.Count; i++) { total += orders[i].GoodSellPriceTotal; } model.SellTotal = total; int id = 0; MainId = 0; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; Sell_OrderOutHousesService OrdersSer = new Sell_OrderOutHousesService(); TB_HouseGoodsService houseGoodsSer = new TB_HouseGoodsService(); try { objCommand.Parameters.Clear(); tb_EFormService eformSer = new tb_EFormService(); string proNo = eformSer.GetAllE_No("Sell_OrderOutHouse", objCommand); model.ProNo = proNo; eform.E_No = proNo; model.Status = eform.state; id = Add(model, objCommand); MainId = id; eform.allE_id = id; eformSer.Add(eform, objCommand); for (int i = 0; i < orders.Count; i++) { orders[i].id = id; OrdersSer.Add(orders[i], objCommand); if (eform.state == "通过") { houseGoodsSer.OutHouse(orders[i].HouseID, orders[i].GooId, orders[i].GoodNum, orders[i].GoodPrice, objCommand); } } tan.Commit(); } catch (Exception) { tan.Rollback(); return(0); } return(id); } }
public bool updateTran(VAN_OA.Model.JXC.TB_SupplierAdvancePayment model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms, List <SupplierToInvoiceView> orders, string IDS) { using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; try { objCommand.Parameters.Clear(); model.Status = eform.state; Update(model, objCommand); tb_EFormService eformSer = new tb_EFormService(); eformSer.Update(eform, objCommand); tb_EFormsService eformsSer = new tb_EFormsService(); eformsSer.Add(forms, objCommand); TB_SupplierAdvancePaymentsService OrdersSer = new TB_SupplierAdvancePaymentsService(); for (int i = 0; i < orders.Count; i++) { if (orders[i].IfCheck == false) { continue; } var modelSupplierInvoices = new TB_SupplierAdvancePayments(); modelSupplierInvoices.Ids = orders[i].payIds; modelSupplierInvoices.Id = model.Id; modelSupplierInvoices.CaiIds = orders[i].Ids; modelSupplierInvoices.SupplierFPNo = orders[i].SupplierFPNo; modelSupplierInvoices.SupplierInvoiceDate = orders[i].SupplierInvoiceDate.Value; modelSupplierInvoices.SupplierInvoiceNum = orders[i].SupplierInvoiceNum; modelSupplierInvoices.SupplierInvoicePrice = orders[i].SupplierInvoicePrice; modelSupplierInvoices.SupplierInvoiceTotal = orders[i].SupplierInvoiceTotal; if (eform.state == "通过" && (orders[i].SupplierProNo == null || orders[i].SupplierProNo == "")) { modelSupplierInvoices.SupplierProNo = GetAllE_No("TB_SupplierAdvancePayments", objCommand); } OrdersSer.Update(modelSupplierInvoices, objCommand); } tan.Commit(); } catch (Exception) { tan.Rollback(); return(false); } } return(true); }
public bool updateTran(VAN_OA.Model.EFrom.Tb_ProjectInv model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms, List <Tb_ProjectInvs> proInvs, string IDS) { using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; Tb_ProjectInvsService prosInvsSer = new Tb_ProjectInvsService(); try { objCommand.Parameters.Clear(); Update(model, objCommand); tb_EFormService eformSer = new tb_EFormService(); eformSer.Update(eform, objCommand); tb_EFormsService eformsSer = new tb_EFormsService(); eformsSer.Add(forms, objCommand); for (int i = 0; i < proInvs.Count; i++) { proInvs[i].PId = model.Id; if (proInvs[i].IfUpdate == true && proInvs[i].Id != 0) { prosInvsSer.Update(proInvs[i], objCommand); } else if (proInvs[i].Id == 0) { prosInvsSer.Add(proInvs[i], objCommand); } } if (IDS != "") { IDS = IDS.Substring(0, IDS.Length - 1); prosInvsSer.DeleteByIds(IDS, objCommand); } tan.Commit(); } catch (Exception) { tan.Rollback(); return(false); } } return(true); }
public bool updateTran(VAN_OA.Model.JXC.Sell_OrderOutHouseBack model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms, List <Sell_OrderOutHouseBacks> orders, string IDS) { decimal total = 0; for (int i = 0; i < orders.Count; i++) { total += orders[i].GoodSellPriceTotal; } model.SellTotal = total; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; Sell_OrderOutHouseBacksService OrdersSer = new Sell_OrderOutHouseBacksService(); try { objCommand.Parameters.Clear(); model.Status = eform.state; Update(model, objCommand); tb_EFormService eformSer = new tb_EFormService(); eformSer.Update(eform, objCommand); tb_EFormsService eformsSer = new tb_EFormsService(); eformsSer.Add(forms, objCommand); //====删除所有子单据 string delete = "delete from Sell_OrderOutHouseBacks where id=" + model.Id; objCommand.CommandText = delete; objCommand.ExecuteNonQuery(); //==== for (int i = 0; i < orders.Count; i++) { orders[i].id = model.Id; OrdersSer.Add(orders[i], objCommand); } tan.Commit(); } catch (Exception) { tan.Rollback(); return(false); } } return(true); }
public int addTran(VAN_OA.Model.EFrom.tb_FundsUse model, VAN_OA.Model.EFrom.tb_EForm eform, out int MainId) { int id = 0; MainId = 0; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; try { objCommand.Parameters.Clear(); tb_EFormService eformSer = new tb_EFormService(); string proNo = eformSer.GetAllE_No("tb_FundsUse", objCommand); model.ProNo = proNo; eform.E_No = proNo; model.State = eform.state; id = Add(model, objCommand); MainId = id; eform.allE_id = id; eformSer.Add(eform, objCommand); if (eform.state == "通过") { string[] nos = model.HouseNo.Split('/'); if (nos.Length > 0) { string sql = string.Format("update CAI_OrderInHouse set FPNo='{0}' where ProNo in (", model.Invoce); foreach (var no in nos) { sql += string.Format(" {0}", no); } sql += ")"; objCommand.CommandText = sql; objCommand.ExecuteNonQuery(); } } tan.Commit(); } catch (Exception) { tan.Rollback(); return(0); } return(id); } }
public int addTran(VAN_OA.Model.JXC.Sell_OrderFPBack model, VAN_OA.Model.EFrom.tb_EForm eform, List <Sell_OrderFPBacks> orders, out int MainId) { int id = 0; MainId = 0; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; Sell_OrderFPBacksService OrdersSer = new Sell_OrderFPBacksService(); try { objCommand.Parameters.Clear(); tb_EFormService eformSer = new tb_EFormService(); string proNo = eformSer.GetAllE_No("Sell_OrderFPBack", objCommand); model.ProNo = proNo; eform.E_No = proNo; decimal total = 0; foreach (var m in orders) { total += m.GoodSellPriceTotal; } model.Total = total; model.Status = eform.state; id = Add(model, objCommand); MainId = id; eform.allE_id = id; eformSer.Add(eform, objCommand); for (int i = 0; i < orders.Count; i++) { orders[i].id = id; OrdersSer.Add(orders[i], objCommand); } tan.Commit(); } catch (Exception) { tan.Rollback(); return(0); } return(id); } }
public int addTran(VAN_OA.Model.EFrom.Tb_ExpInv model, VAN_OA.Model.EFrom.tb_EForm eform, List <Tb_ExpInvs> proInvs) { int id = 0; int MainId = 0; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; Tb_ExpInvsService proInvsSer = new Tb_ExpInvsService(); try { tb_EFormService eformSer = new tb_EFormService(); objCommand.Parameters.Clear(); string proNo = eformSer.GetAllE_No("Tb_ExpInv", objCommand); model.ProNo = proNo; eform.E_No = proNo; id = Add(model, objCommand); MainId = id; eform.allE_id = id; eformSer.Add(eform, objCommand); for (int i = 0; i < proInvs.Count; i++) { proInvs[i].PId = id; proInvsSer.Add(proInvs[i], objCommand); } tan.Commit(); } catch (Exception) { tan.Rollback(); return(0); } return(id); } }
private decimal accountXishu(TB_ToInvoice model, VAN_OA.Model.EFrom.tb_EForm eform, SqlCommand objCommand) { if (eform.state == "通过") { string sql = string.Format(@"declare @cou int; declare @lastDate datetime; select @cou=COUNT(*) from TB_ToInvoice where FPId={2}; if (@cou=0) begin select @lastDate=DaoKuanDate from TB_ToInvoice where State='通过' and PoNo='{0}' and Id<>{1} order by DaoKuanDate end select @lastDate;", model.PoNo, model.Id, model.FPId); objCommand.CommandText = sql; object objdate = objCommand.ExecuteScalar(); //查找第一次销售出库日期 sql = string.Format("select top 1 rutime from Sell_OrderOutHouse where pono='{0}' order by rutime ", model.PoNo); objCommand.CommandText = sql; DateTime sellDate = Convert.ToDateTime(objCommand.ExecuteScalar()); DateTime fristDate = DateTime.Now; if (objdate is DBNull) { fristDate = model.DaoKuanDate; } else { fristDate = Convert.ToDateTime(objdate); } TimeSpan ts = fristDate - sellDate; sql = string.Format("select top 1 accountXishu from TB_AccountPeriod where accountName<={0} order by accountName desc", ts.Days); objCommand.CommandText = sql; decimal accountXishu = Convert.ToDecimal(objCommand.ExecuteScalar()); return(accountXishu); } return(0); }
public int addTran(VAN_OA.Model.JXC.Sell_OrderFP model, VAN_OA.Model.EFrom.tb_EForm eform, List <Sell_OrderFPs> orders, out int MainId) { int id = 0; MainId = 0; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; Sell_OrderFPsService OrdersSer = new Sell_OrderFPsService(); try { objCommand.Parameters.Clear(); tb_EFormService eformSer = new tb_EFormService(); string proNo = eformSer.GetAllE_No("Sell_OrderFP", objCommand); model.ProNo = proNo; eform.E_No = proNo; decimal total = 0; foreach (var m in orders) { total += m.GoodSellPriceTotal; } model.Total = total; model.Status = eform.state; // TB_ToInvoiceService invoiceSer = new TB_ToInvoiceService(); model.ZhuanPayTotal = invoiceSer.GetPayTotal(model.PONo, model.Total); id = Add(model, objCommand); MainId = id; eform.allE_id = id; eformSer.Add(eform, objCommand); System.Collections.Hashtable hs = new System.Collections.Hashtable(); for (int i = 0; i < orders.Count; i++) { orders[i].id = id; OrdersSer.Add(orders[i], objCommand); if (eform.state == "通过") { if (!hs.Contains(orders[i].SellOutPONO)) { hs.Add(orders[i].SellOutPONO, null); } } } foreach (var key in hs.Keys) { //更改销售订单的发票号 //string sql = string.Format("update Sell_OrderOutHouse set FPNo=FPNo+'{0}/' where ProNo='{1}'", model.FPNo, key); //objCommand.CommandText = sql; //objCommand.ExecuteNonQuery(); //更改项目订单的发票号 string sql = string.Format("update CG_POOrder set FPTotal=isnull(FPTotal,'')+'{0}/' where PONo='{1}' and ifzhui=0 ", model.FPNo, model.PONo); objCommand.CommandText = sql; objCommand.ExecuteNonQuery(); } tan.Commit(); } catch (Exception) { tan.Rollback(); return(0); } return(id); } }
public bool updateTran(VAN_OA.Model.JXC.Sell_OrderFP model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms, List <Sell_OrderFPs> orders, string IDS, bool isBackUp, bool isBackUpInvoice) { //判断是否是删除 -销售发票删除 if (eform.proId == 37) { using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; try { objCommand.Parameters.Clear(); model.Status = eform.state; if (eform.state == "不通过") { model.Status = "通过"; } UpdateToDelete(model, objCommand); tb_EFormService eformSer = new tb_EFormService(); eformSer.Update(eform, objCommand, isBackUp); tb_EFormsService eformsSer = new tb_EFormsService(); eformsSer.Add(forms, objCommand); if (eform.state == "通过") { //删除发票签回单(如果有) string deleteFPBack = string.Format("delete tb_EForms where e_Id in (select id from tb_EForm where proId=29 and allE_id in (select id from Sell_OrderFPBack where PId={0}));", model.Id); deleteFPBack += string.Format("delete tb_EForm where proId=29 and allE_id in (select id from Sell_OrderFPBack where PId={0});", model.Id); deleteFPBack += string.Format("delete Sell_OrderFPBacks where Id in (select id from Sell_OrderFPBack where PId={0});delete Sell_OrderFPBack where PId={0};", model.Id); objCommand.CommandText = deleteFPBack; objCommand.ExecuteNonQuery(); //删除发票删除单 string deleteFPDelete = string.Format("delete tb_EForms where e_Id in (select id from tb_EForm where proId in (26,34,37) and allE_id={0});", model.Id); deleteFPDelete += string.Format("delete tb_EForm where proId in (26,34,37) and allE_id={0};", model.Id); objCommand.CommandText = deleteFPDelete; objCommand.ExecuteNonQuery(); //删除发票单 string DeleteAll = string.Format(@"declare @oldFPNo varchar(500);declare @oldPONo varchar(500); select top 1 @oldFPNo=FPNo,@oldPONo=PONo from Sell_OrderFP where id={0} update CG_POOrder set FPTotal=replace( FPTotal, @oldFPNo+'/','') where PONo in (select PONo from Sell_OrderFP where id={0}) and ifzhui=0;", model.Id); Dal.EFrom.tb_EFormService efromSer = new VAN_OA.Dal.EFrom.tb_EFormService(); //var efromModel = efromSer.GetModel(Convert.ToInt32(model.Id)); //if (efromModel.state == "通过") //{ DeleteAll += "update CG_POOrder set POStatue3='' where PONo=@oldPONo;"; //} DeleteAll += string.Format("delete from Sell_OrderFP where id={0};delete from Sell_OrderFPs where id={0}; ", model.Id); objCommand.CommandText = DeleteAll; objCommand.ExecuteNonQuery(); } tan.Commit(); } catch (Exception) { tan.Rollback(); return(false); } } if (eform.state == "通过") { new Sell_OrderFPBackService().SellFPOrderBackUpdatePoStatus(model.PONo); new VAN_OA.Dal.JXC.CG_POOrdersService().GetListArrayToFpsAndUpdatePoStatue(model.PONo, "通过"); } } else { using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; string backUpPoNos = ""; if (isBackUp) { BackUpFPInfoService backUpSer = new BackUpFPInfoService(); backUpPoNos = backUpSer.BackUp(model.Id, objCommand); } //最后进行 删除 到款单 ,以及发票签回单& 备份 if (isBackUpInvoice && eform.state == "通过") { BackUpFPInfoService backUpSer = new BackUpFPInfoService(); backUpPoNos = backUpSer.BackUpOthers(model.Id, objCommand, model.InvoiceNowGuid); } //CG_POOrdersService OrdersSer = new CG_POOrdersService(); //CG_POCaiService CaiSer = new CG_POCaiService(); try { decimal total = 0; foreach (var m in orders) { total += m.GoodSellPriceTotal; } model.Total = total; System.Collections.Hashtable hs = new System.Collections.Hashtable(); objCommand.Parameters.Clear(); model.Status = eform.state; Update(model, objCommand); tb_EFormService eformSer = new tb_EFormService(); eformSer.Update(eform, objCommand, isBackUp); tb_EFormsService eformsSer = new tb_EFormsService(); eformsSer.Add(forms, objCommand); TB_HouseGoodsService houseGoodsSer = new TB_HouseGoodsService(); Sell_OrderFPsService OrdersSer = new Sell_OrderFPsService(); if (isBackUp) { //删除之前的数据 objCommand.CommandText = string.Format("delete from Sell_OrderFPs where id=" + model.Id); objCommand.ExecuteNonQuery(); for (int i = 0; i < orders.Count; i++) { orders[i].id = model.Id; OrdersSer.Add(orders[i], objCommand); if (eform.state == "通过") { if (!hs.Contains(orders[i].SellOutOrderId)) { hs.Add(orders[i].SellOutOrderId, null); } } } } //foreach (var key in hs.Keys) //{ // //更改销售订单的发票号 // string sql = string.Format("update Sell_OrderOutHouse set FPNo=FPNo+'{0}/' where ProNo='{1}'", model.FPNo, key); // objCommand.CommandText = sql; // objCommand.ExecuteNonQuery(); if (eform.state == "通过") { //更改项目订单的发票号 string sql = string.Format("update CG_POOrder set FPTotal=isnull(FPTotal,'')+'{0}/' where PONo='{1}' and ifzhui=0 ", model.FPNo, model.PONo); objCommand.CommandText = sql; objCommand.ExecuteNonQuery(); } //} //for (int i = 0; i < orders.Count; i++) //{ // orders[i].Id = model.Id; // //if (orders[i].IfUpdate == true && orders[i].Ids != 0) // //{ // OrdersSer.Update(orders[i], objCommand); // //} // //else if (orders[i].Ids == 0) // //{ // // OrdersSer.Add(orders[i], objCommand); // //} //} //if (IDS != "") //{ // IDS = IDS.Substring(0, IDS.Length - 1); // OrdersSer.DeleteByIds(IDS, objCommand); //} tan.Commit(); if (backUpPoNos != "") { foreach (string pono in backUpPoNos.Split(',')) { if (!string.IsNullOrEmpty(pono)) { new Sell_OrderFPBackService().SellFPOrderBackUpdatePoStatus(pono); new CG_POOrderService().GetOrder_ToInvoiceAndUpdatePoStatus(pono); } } } } catch (Exception ex) { tan.Rollback(); return(false); } } } return(true); }
public bool updateTran(VAN_OA.Model.JXC.CAI_POOrder model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms, List <CAI_POOrders> orders, string IDS, List <CAI_POCai> Cais, string CAI_IDS) { using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; CAI_POOrdersService OrdersSer = new CAI_POOrdersService(); CAI_POCaiService CaiSer = new CAI_POCaiService(); try { objCommand.Parameters.Clear(); model.Status = eform.state; Update(model, objCommand); tb_EFormService eformSer = new tb_EFormService(); eformSer.Update(eform, objCommand); tb_EFormsService eformsSer = new tb_EFormsService(); eformsSer.Add(forms, objCommand); //for (int i = 0; i < orders.Count; i++) //{ // orders[i].Id = model.Id; // //if (orders[i].IfUpdate == true && orders[i].Ids != 0) // //{ // OrdersSer.Update(orders[i], objCommand); // //} // //else if (orders[i].Ids == 0) // //{ // // OrdersSer.Add(orders[i], objCommand); // //} //} //if (IDS != "") //{ // IDS = IDS.Substring(0, IDS.Length - 1); // OrdersSer.DeleteByIds(IDS, objCommand); //} #region 采购 for (int i = 0; i < Cais.Count; i++) { Cais[i].Id = model.Id; if (Cais[i].IfUpdate == true && Cais[i].Ids != 0) { CaiSer.Update(Cais[i], objCommand); } else if (Cais[i].Ids == 0) { CaiSer.Add(Cais[i], objCommand); } } //if (CAI_IDS != "") //{ // CAI_IDS = CAI_IDS.Substring(0, CAI_IDS.Length - 1); // CaiSer.DeleteByIds(CAI_IDS, objCommand); //} #endregion tan.Commit(); } catch (Exception) { tan.Rollback(); return(false); } } return(true); }
public int addTran(VAN_OA.Model.JXC.CAI_POOrder model, VAN_OA.Model.EFrom.tb_EForm eform, List <CAI_POOrders> orders, List <CAI_POCai> caiOrders, out int MainId, bool isCopy = false) { CG_POCaiService poCaiSer = new CG_POCaiService(); var caiList = poCaiSer.GetCaiList(model.CG_ProNo); int id = 0; MainId = 0; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; CAI_POOrdersService OrdersSer = new CAI_POOrdersService(); CAI_POCaiService caiSer = new CAI_POCaiService(); try { objCommand.Parameters.Clear(); tb_EFormService eformSer = new tb_EFormService(); string proNo = eformSer.GetAllE_No("CAI_POOrder", objCommand); model.ProNo = proNo; eform.E_No = proNo; model.Status = eform.state; id = Add(model, objCommand); MainId = id; eform.allE_id = id; eformSer.Add(eform, objCommand); for (int i = 0; i < orders.Count; i++) { orders[i].Id = id; OrdersSer.Add(orders[i], objCommand); if (isCopy == false) { CAI_POCai cai = new CAI_POCai(); cai.GuestName = orders[i].GuestName; cai.Num = orders[i].Num; cai.InvName = orders[i].InvName; cai.Id = id; cai.GoodId = orders[i].GoodId; var pocaiModel = caiList.Find(p => p.GoodId == orders[i].GoodId); if (pocaiModel != null) { cai.FinPrice1 = pocaiModel.FinPrice1; cai.FinPrice2 = pocaiModel.FinPrice2; cai.FinPrice3 = pocaiModel.FinPrice3; cai.SupperPrice = pocaiModel.SupperPrice; cai.SupperPrice1 = pocaiModel.SupperPrice1; cai.SupperPrice2 = pocaiModel.SupperPrice2; cai.Supplier = pocaiModel.Supplier; cai.Supplier1 = pocaiModel.Supplier1; cai.Supplier2 = pocaiModel.Supplier2; } caiSer.Add(cai, objCommand); } else { var pocaiModel = caiOrders.Find(p => p.GoodId == orders[i].GoodId); pocaiModel.GuestName = orders[i].GuestName; pocaiModel.Num = orders[i].Num; pocaiModel.InvName = orders[i].InvName; pocaiModel.Id = id; caiSer.Add(pocaiModel, objCommand); } } tan.Commit(); } catch (Exception) { tan.Rollback(); return(0); } return(id); } }
public bool updateTran(VAN_OA.Model.JXC.Sell_OrderInHouse model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms, List <Sell_OrderInHouses> orders, string IDS) { decimal total = 0; for (int i = 0; i < orders.Count; i++) { total += orders[i].GoodSellPriceTotal; } model.TuiTotal = total; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; Sell_OrderInHousesService OrdersSer = new Sell_OrderInHousesService(); //CG_POOrdersService OrdersSer = new CG_POOrdersService(); //CG_POCaiService CaiSer = new CG_POCaiService(); try { objCommand.Parameters.Clear(); model.Status = eform.state; Update(model, objCommand); tb_EFormService eformSer = new tb_EFormService(); eformSer.Update(eform, objCommand); tb_EFormsService eformsSer = new tb_EFormsService(); eformsSer.Add(forms, objCommand); TB_HouseGoodsService houseGoodsSer = new TB_HouseGoodsService(); for (int i = 0; i < orders.Count; i++) { if (orders[i].GoodPriceSecond != 0) { orders[i].id = model.Id; OrdersSer.Update(orders[i], objCommand); } //else if (orders[i].Ids == 0) //{ // OrdersSer.Add(orders[i], objCommand); //} } //if (IDS != "") //{ // IDS = IDS.Substring(0, IDS.Length - 1); // OrdersSer.DeleteByIds(IDS, objCommand); //} for (int i = 0; i < orders.Count; i++) { if (eform.state == "通过") { if (orders[i].GoodPriceSecond != 0) { houseGoodsSer.InHouse(orders[i].HouseID, orders[i].GooId, orders[i].GoodNum, orders[i].GoodPriceSecond, objCommand); } else { houseGoodsSer.InHouse(orders[i].HouseID, orders[i].GooId, orders[i].GoodNum, orders[i].GoodPrice, objCommand); } } } tan.Commit(); } catch (Exception) { tan.Rollback(); return(false); } } return(true); }
public bool updateTran(VAN_OA.Model.JXC.CAI_OrderCheck model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms, List <CAI_OrderChecks> orders, string IDS) { using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; CG_POOrdersService OrdersSer = new CG_POOrdersService(); CG_POCaiService CaiSer = new CG_POCaiService(); try { objCommand.Parameters.Clear(); model.Status = eform.state; Update(model, objCommand); tb_EFormService eformSer = new tb_EFormService(); eformSer.Update(eform, objCommand); tb_EFormsService eformsSer = new tb_EFormsService(); eformsSer.Add(forms, objCommand); CAI_OrderChecksService myOrderChecks = new CAI_OrderChecksService(); for (int i = 0; i < orders.Count; i++) { // orders[i].CheckId = model.Id; //if (orders[i].IfUpdate == true && orders[i].Ids != 0) //{ myOrderChecks.Update(orders[i], objCommand); //} //else if (orders[i].Ids == 0) //{ // OrdersSer.Add(orders[i], objCommand); //} } //入库 if (eform.state == "通过") { tb_EForm eformMain = new tb_EForm(); int proId = 0; string sql = "select Pro_Id from A_ProInfo where pro_Type='采购入库'"; objCommand.CommandText = sql; proId = Convert.ToInt32(objCommand.ExecuteScalar()); eformMain.appPer = eform.appPer; eformMain.appTime = DateTime.Now; eformMain.createPer = eform.appPer; eformMain.createTime = DateTime.Now; eformMain.proId = proId; eformMain.state = "通过"; eformMain.toPer = 0; eformMain.toProsId = 0; CAI_OrderInHouseService orderInHouse = new CAI_OrderInHouseService(); sql = "select top 1 id from TB_HouseInfo where ifdefault=1 "; objCommand.CommandText = sql; int objhouseId = Convert.ToInt32(objCommand.ExecuteScalar()); CAI_OrderInHouse orderInModel = new CAI_OrderInHouse() { ChcekProNo = model.ProNo, CreateTime = DateTime.Now, CreateUserId = eform.appPer, GuestName = orders[0].GuestName, HouseID = objhouseId, POName = orders[0].POName, PONo = orders[0].PONo, RuTime = DateTime.Now, Status = "通过", Supplier = orders[0].SupplierName, DoPer = orders[0].CaiGouPer, DaiLi = orders[0].CaiGouPer, FPNo = "", Remark = "" }; List <CAI_OrderInHouses> ordersInHouses = new List <CAI_OrderInHouses>(); foreach (var m in orders) { CAI_OrderInHouses orderM = new CAI_OrderInHouses() { GooId = m.CheckGoodId, GoodNum = m.CheckNum, GoodPrice = m.CheckPrice, OrderCheckIds = m.Ids, QingGouPer = m.QingGou, CaiLastTruePrice = m.CheckLastTruePrice }; ordersInHouses.Add(orderM); } orderInHouse.addTran(orderInModel, eformMain, ordersInHouses, objCommand); } tan.Commit(); } catch (Exception) { tan.Rollback(); return(false); } } return(true); }
public bool updateTran(VAN_OA.Model.EFrom.tb_FundsUse model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms) { using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; try { model.State = eform.state; objCommand.Parameters.Clear(); Update(model, objCommand); tb_EFormService eformSer = new tb_EFormService(); eformSer.Update(eform, objCommand); tb_EFormsService eformsSer = new tb_EFormsService(); eformsSer.Add(forms, objCommand); if (eform.state == "通过") { string[] nos = model.HouseNo.Split('/'); if (nos.Length > 0) { string sql = string.Format("update CAI_OrderInHouse set FPNo='{0}' where ProNo in (", model.Invoce); foreach (var no in nos) { sql += string.Format(" '{0}',", no); } sql = sql.Substring(0, sql.Length - 1); sql += ")"; objCommand.CommandText = sql; objCommand.ExecuteNonQuery(); foreach (var no in nos) { if (no == "") { continue; } string insertRu = string.Format("insert into TB_CaiXiaoNo values ('入库','{0}')", no); objCommand.CommandText = insertRu; objCommand.ExecuteNonQuery(); } } string[] chuNo = model.ExpNo.Split('/'); foreach (var no in chuNo) { if (no == "") { continue; } string insertRu = string.Format("insert into TB_CaiXiaoNo values ('出库','{0}')", no); objCommand.CommandText = insertRu; objCommand.ExecuteNonQuery(); } } tan.Commit(); } catch (Exception) { tan.Rollback(); return(false); } } return(true); }
public int addTran(VAN_OA.Model.EFrom.TB_POOrder model, VAN_OA.Model.EFrom.tb_EForm eform, List <TB_POOrders> orders, List <TB_POCai> caiOrders, out int MainId) { int id = 0; MainId = 0; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; TB_POOrdersService OrdersSer = new TB_POOrdersService(); TB_POCaiService caiSer = new TB_POCaiService(); try { objCommand.Parameters.Clear(); tb_EFormService eformSer = new tb_EFormService(); string proNo = eformSer.GetAllE_No("TB_POOrder", objCommand); model.ProNo = proNo; eform.E_No = proNo; id = Add(model, objCommand); MainId = id; eform.allE_id = id; eformSer.Add(eform, objCommand); for (int i = 0; i < orders.Count; i++) { orders[i].Id = id; OrdersSer.Add(orders[i], objCommand); TB_POCai cai = new TB_POCai(); cai.GuestName = orders[i].GuestName; cai.Num = orders[i].Num; cai.InvName = orders[i].InvName; cai.Id = id; caiSer.Add(cai, objCommand); } //for (int i = 0; i < caiOrders.Count; i++) //{ // caiOrders[i].Id = id; // caiSer.Add(caiOrders[i], objCommand); //} tan.Commit(); } catch (Exception) { tan.Rollback(); return(0); } return(id); } }
public int addTran(VAN_OA.Model.JXC.TB_SupplierAdvancePayment model, VAN_OA.Model.EFrom.tb_EForm eform, List <SupplierToInvoiceView> orders, out int MainId) { int id = 0; MainId = 0; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; TB_SupplierAdvancePaymentsService OrdersSer = new TB_SupplierAdvancePaymentsService(); try { objCommand.Parameters.Clear(); tb_EFormService eformSer = new tb_EFormService(); string proNo = eformSer.GetAllE_No1("TB_SupplierAdvancePayment", objCommand); model.ProNo = proNo; eform.E_No = proNo; model.Status = eform.state; id = Add(model, objCommand); MainId = id; eform.allE_id = id; eformSer.Add(eform, objCommand); for (int i = 0; i < orders.Count; i++) { if (orders[i].IfCheck == false) { continue; } var modelSupplierInvoices = new TB_SupplierAdvancePayments(); modelSupplierInvoices.Id = id; modelSupplierInvoices.CaiIds = orders[i].Ids; modelSupplierInvoices.SupplierFPNo = orders[i].SupplierFPNo; modelSupplierInvoices.SupplierInvoiceDate = orders[i].SupplierInvoiceDate.Value; modelSupplierInvoices.SupplierInvoiceNum = orders[i].SupplierInvoiceNum; modelSupplierInvoices.SupplierInvoicePrice = orders[i].SupplierInvoicePrice; modelSupplierInvoices.SupplierInvoiceTotal = orders[i].SupplierInvoiceTotal; if (eform.state == "通过" && (orders[i].SupplierProNo == null || orders[i].SupplierProNo == "")) { modelSupplierInvoices.SupplierProNo = GetAllE_No("TB_SupplierAdvancePayments", objCommand); } OrdersSer.Add(modelSupplierInvoices, objCommand); } var otherOrders = orders.FindAll(t => t.IfCheck == false); foreach (var otherOrder in otherOrders) { string insertSql = string.Format("insert into TB_TempSupplierInvoice values(0,{1},{0})", id, otherOrder.payIds); objCommand.CommandText = insertSql; objCommand.ExecuteNonQuery(); } tan.Commit(); } catch (Exception) { tan.Rollback(); return(0); } return(id); } }
public int addTran(VAN_OA.Model.JXC.CAI_OrderCheck model, VAN_OA.Model.EFrom.tb_EForm eform, List <CAI_OrderChecks> orders, out int MainId, List <string> ids = null) { int id = 0; MainId = 0; using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; CAI_OrderChecksService OrdersSer = new CAI_OrderChecksService(); try { objCommand.Parameters.Clear(); tb_EFormService eformSer = new tb_EFormService(); string proNo = eformSer.GetAllE_No("CAI_OrderCheck", objCommand); model.ProNo = proNo; eform.E_No = proNo; model.Status = eform.state; id = Add(model, objCommand); model.Id = id; MainId = id; eform.allE_id = id; eformSer.Add(eform, objCommand); for (int i = 0; i < orders.Count; i++) { orders[i].CheckId = id; orders[i].Ids = OrdersSer.Add(orders[i], objCommand); } //入库 if (eform.state == "通过") { tb_EForm eformMain = new tb_EForm(); int proId = 0; string sql = "select Pro_Id from A_ProInfo where pro_Type='采购入库'"; objCommand.CommandText = sql; proId = Convert.ToInt32(objCommand.ExecuteScalar()); eformMain.appPer = eform.appPer; eformMain.appTime = DateTime.Now.AddSeconds(1); eformMain.createPer = eform.appPer; eformMain.createTime = DateTime.Now.AddSeconds(1); eformMain.proId = proId; eformMain.state = "通过"; eformMain.toPer = 0; eformMain.toProsId = 0; eform.E_LastTime = DateTime.Now.AddSeconds(1); CAI_OrderInHouseService orderInHouse = new CAI_OrderInHouseService(); sql = "select top 1 id from TB_HouseInfo where ifdefault=1 "; objCommand.CommandText = sql; int objhouseId = Convert.ToInt32(objCommand.ExecuteScalar()); CAI_OrderInHouse orderInModel = new CAI_OrderInHouse() { ChcekProNo = model.ProNo, CreateTime = DateTime.Now.AddSeconds(1), CreateUserId = eform.appPer, GuestName = orders[0].GuestName, HouseID = objhouseId, POName = orders[0].POName, PONo = orders[0].PONo, RuTime = DateTime.Now.AddSeconds(1), Status = "通过", Supplier = orders[0].SupplierName, DoPer = orders[0].CaiGouPer, DaiLi = orders[0].CaiGouPer, FPNo = "", Remark = "" }; List <CAI_OrderInHouses> ordersInHouses = new List <CAI_OrderInHouses>(); foreach (var m in orders) { CAI_OrderInHouses orderM = new CAI_OrderInHouses() { GooId = m.CheckGoodId, GoodNum = m.CheckNum, GoodPrice = m.CheckPrice, OrderCheckIds = m.Ids, QingGouPer = m.QingGou, CaiLastTruePrice = m.CheckLastTruePrice }; ordersInHouses.Add(orderM); } orderInHouse.addTran(orderInModel, eformMain, ordersInHouses, objCommand); if (ids != null) { foreach (var ordersIn in ordersInHouses) { ids.Add(ordersIn.Ids.ToString()); } } } tan.Commit(); } catch (Exception) { tan.Rollback(); return(0); } return(id); } }