private void bt_getpo_Click(object sender, EventArgs e) { EntityPO_Pomain doc = new EntityPO_Pomain(); doc.cPOID = tx_cCode.Text == "" ? "1" : tx_cCode.Text; textBox1.Text = QueryCode(8015, JsonConvert.SerializeObject(doc)); }
private void bt_pomain_Click(object sender, EventArgs e) { EntityPO_Pomain doc = new EntityPO_Pomain(); doc.cPOID = "11611314"; doc.dPODate = DateTime.Parse("2018-4-09"); doc.cVenCode = "SZ0046"; List <EntityPO_PoDetails> list = new List <EntityPO_PoDetails>(); list.Add(new EntityPO_PoDetails { cInvCode = "403103", iQuantity = 500, iTaxPrice = decimal.Parse("4.69"), iPerTaxRate = 17, iSum = decimal.Parse("2345") } ); doc.Details = list; string entity = JsonConvert.SerializeObject(doc); string postUrl = string.Format(@"{0}={1}&ModelType=8015", addpara, entity); string result = SendHttpRequest(addurl, postUrl, "POST"); textBox1.Text = result; }
public string AddModels(string UserCode, string CipherPassword, int ModelType, string StrAccID, string Act, string Entity) { //Entity = System.Web.HttpUtility.UrlDecode(Entity); string plainPassword = DefineEncryptDecrypt.Decrypt(CipherPassword); int AccYear = U8BllBase.GetBeginYear(StrAccID); if (AccYear == 0) { return(ControllerHelp.GetReturnStr(0, string.Format("没有找到账套号:{0}", StrAccID))); } int success = 0; ModelsType mt = (ModelsType)ModelType; switch (mt) { case ModelsType.Sale: // 销售订单 lock (SaleLock) { if (Act == "add") { EntitySaleHead entity = JsonConvert.DeserializeObject <EntitySaleHead>(Entity); SoMainBll bll = new SoMainBll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddSale(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.RdRecord09: // 配送出库单(其他出库单) lock (RdRecord09Lock) { if (Act == "add") { EntityRdRecord09Head entity = JsonConvert.DeserializeObject <EntityRdRecord09Head>(Entity); RdRecord09Bll bll = new RdRecord09Bll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddRdRecord09(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.DispatchList1: //销售退货单 case ModelsType.DispatchList4: //委托代销退货单 lock (DispatchList1Lock) { if (Act == "add") { EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity); DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddDispatchList(UserCode, plainPassword, StrAccID, AccYear, Act, ModelsType.DispatchList1 == mt ? 0 : 1, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.DispatchList2: //销售发货单 case ModelsType.DispatchList3: //委托代销发货单 lock (DispatchList2Lock) { if (Act == "add") { EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity); DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddDispatchList(UserCode, plainPassword, ModelType, StrAccID, AccYear, Act, ModelsType.DispatchList2 == mt ? 0 : 1, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.Ap_CloseBill: //收款单 lock (Ap_CloseBillLock) { if (Act == "add") { EntityAp_CloseBillHead entity = JsonConvert.DeserializeObject <EntityAp_CloseBillHead>(Entity); Ap_CloseBillBll bll = new Ap_CloseBillBll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddAp_CloseBill(UserCode, plainPassword, StrAccID, AccYear, Act, ModelType, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.Ap_Vouch: //其他应付款 lock (Ap_VouchLock) { if (Act == "add") { EntityAp_VouchHead entity = JsonConvert.DeserializeObject <EntityAp_VouchHead>(Entity); Ap_VouchBll bll = new Ap_VouchBll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddAp_Vouch(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.PO_Pomain: //采购订单 lock (PO_PomainLock) { if (Act == "add") { EntityPO_Pomain entity = JsonConvert.DeserializeObject <EntityPO_Pomain>(Entity); PO_PomainBll bll = new PO_PomainBll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddPO_Pomain(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.RdRecord01: //采购入库单 lock (RdRecord01Lock) { if (Act == "add") { EntityRdRecord01Head entity = JsonConvert.DeserializeObject <EntityRdRecord01Head>(Entity); RdRecord01Bll bll = new RdRecord01Bll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddRdRecord01(UserCode, plainPassword, StrAccID, AccYear, Act, 0, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.PayAp_CloseBill: //付款单 lock (PayAp_CloseBillLock) { if (Act == "add") { EntityAp_CloseBillHead entity = JsonConvert.DeserializeObject <EntityAp_CloseBillHead>(Entity); Ap_CloseBillBll bll = new Ap_CloseBillBll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddAp_CloseBill(UserCode, plainPassword, StrAccID, AccYear, Act, ModelType, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.ST_AppTransVouch: //调拨申请单 lock (ST_AppTransVouchLock) { if (Act == "add") { EntityST_AppTransVouch entity = JsonConvert.DeserializeObject <EntityST_AppTransVouch>(Entity); ST_AppTransVouchBll bll = new ST_AppTransVouchBll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddST_AppTransVouch(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.TransVouch: //调拨单 lock (TransVouchLock) { if (Act == "add") { EntityTransVouch entity = JsonConvert.DeserializeObject <EntityTransVouch>(Entity); TransVouchBll bll = new TransVouchBll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddTransVouch(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.Vendor: //供应商 lock (VendorLock) { if (Act == "add") { EntityVendor entity = JsonConvert.DeserializeObject <EntityVendor>(Entity); VendorBll bll = new VendorBll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddVendor(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.CheckVouch: //盘点单 lock (VendorLock) { if (Act == "add") { EntityCheckVouchHead entity = JsonConvert.DeserializeObject <EntityCheckVouchHead>(Entity); CheckVouchBll bll = new CheckVouchBll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddCheckVouch(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.InventoryClass: //存货分类 lock (InventoryClassLock) { if (Act == "add") { EntityInventoryClass entity = JsonConvert.DeserializeObject <EntityInventoryClass>(Entity); InventoryClassBll bll = new InventoryClassBll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddInventoryClass(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.Inventory: //存货档案 lock (InventoryLock) { if (Act == "add") { EntityInventory entity = JsonConvert.DeserializeObject <EntityInventory>(Entity); InventoryBll bll = new InventoryBll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddInventory(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.WareHouse: //仓库档案 lock (WareHouseLock) { if (Act == "add") { EntityWareHouse entity = JsonConvert.DeserializeObject <EntityWareHouse>(Entity); WareHouseBll bll = new WareHouseBll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddWareHouse(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.Customer: //客户档案 lock (CustomerLock) { if (Act == "add") { EntityCustomer entity = JsonConvert.DeserializeObject <EntityCustomer>(Entity); CustomerBll bll = new CustomerBll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddCustomer(UserCode, plainPassword, StrAccID, AccYear, Act, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } case ModelsType.RdRecord01T: //红字采购入库单 lock (RdRecord01TLock) { if (Act == "add") { EntityRdRecord01Head entity = JsonConvert.DeserializeObject <EntityRdRecord01Head>(Entity); RdRecord01Bll bll = new RdRecord01Bll(StrAccID, AccYear, UserCode, plainPassword); var result = bll.AddRdRecord01(UserCode, plainPassword, StrAccID, AccYear, Act, 1, entity, out success); return(ControllerHelp.GetReturnStr(success, StrAccID + '_' + result)); } break; } } return(ControllerHelp.GetReturnStr(0, "AddModels中没有找到可对应的操作项")); }
public string GetModels(string UserCode, string CipherPassword, int ModelType, string StrAccID, string Act, string Entity, string dModifyDate) { //Entity = System.Web.HttpUtility.UrlDecode(Entity); string plainPassword = DefineEncryptDecrypt.Decrypt(CipherPassword); int AccYear = U8BllBase.GetBeginYear(StrAccID); if (AccYear == 0) { return(ControllerHelp.GetReturnStr(0, string.Format("没有找到账套号{0}", StrAccID))); } ModelsType mt = (ModelsType)ModelType; string msg = ""; switch (mt) { case ModelsType.CurrentStock: // 库存量查询 if (Act == "get") { EntityCurrentStock entity = JsonConvert.DeserializeObject <EntityCurrentStock>(Entity); CurrentStockBll bll = new CurrentStockBll(StrAccID, AccYear, UserCode, plainPassword); List <EntityCurrentStock> list = bll.GetCurrentStock(entity, out msg); return(ControllerHelp.GetReturnStr(string.IsNullOrWhiteSpace(msg) ? 1 : 0, "", list)); } break; case ModelsType.Sale: // 查询销售订单是否存在 1表示不存在,2表示存在 if (Act == "query") { SoMainBll bll = new SoMainBll(StrAccID, AccYear, UserCode, plainPassword); EntitySaleHead entity = JsonConvert.DeserializeObject <EntitySaleHead>(Entity); int num = bll.QuerySale(entity.cSOCode); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; case ModelsType.DispatchList1: //退货单 1表示不存在,2表示存在 if (Act == "query") { DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword); EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity); int num = bll.QueryDispatchList(entity.cDLCode); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; case ModelsType.DispatchList2: //发货单 1表示不存在,2表示存在 if (Act == "query") { DispatchListBll bll = new DispatchListBll(StrAccID, AccYear, UserCode, plainPassword); EntityDispatchListHead entity = JsonConvert.DeserializeObject <EntityDispatchListHead>(Entity); int num = bll.QueryDispatchList(entity.cDLCode); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; case ModelsType.RdRecord09: // 配送出库单(其他出库单) 1表示不存在,2表示存在 if (Act == "query") { RdRecord09Bll bll = new RdRecord09Bll(StrAccID, AccYear, UserCode, plainPassword); EntityRdRecord09Head entity = JsonConvert.DeserializeObject <EntityRdRecord09Head>(Entity); int num = bll.QueryRdRecord09(entity.cCode); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; case ModelsType.Ap_CloseBill: //收款单(汇款通知单)1表示不存在,2表示存在 if (Act == "query") { Ap_CloseBillBll bll = new Ap_CloseBillBll(StrAccID, AccYear, UserCode, plainPassword); EntityAp_CloseBillHead entity = JsonConvert.DeserializeObject <EntityAp_CloseBillHead>(Entity); int num = bll.QueryAp_CloseBill(entity.cVouchID); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; case ModelsType.PayAp_CloseBill: //付款单(汇款通知单)1表示不存在,2表示存在 if (Act == "query") { Ap_CloseBillBll bll = new Ap_CloseBillBll(StrAccID, AccYear, UserCode, plainPassword); EntityAp_CloseBillHead entity = JsonConvert.DeserializeObject <EntityAp_CloseBillHead>(Entity); int num = bll.QueryAp_CloseBill(entity.cVouchID); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; case ModelsType.ReturnAnalysis: //退货分析表查询 if (Act == "get") { ReturnAnalysisBll bll = new ReturnAnalysisBll(StrAccID, AccYear, UserCode, plainPassword); EntityReturnAnalysisRQC entity = JsonConvert.DeserializeObject <EntityReturnAnalysisRQC>(Entity); List <EntityReturnAnalysisReport> list = bll.GetReturnAnalysis(entity); return(ControllerHelp.GetReturnStr(1, "", list)); } break; case ModelsType.Customer: //客户档案 if (Act == "get") { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); EntityCustomer entity = JsonConvert.DeserializeObject <EntityCustomer>(Entity); List <EntityCustomer> customer = bll.GetCustomer(entity.cCusCode); return(ControllerHelp.GetReturnStr(1, "", customer)); } break; case ModelsType.Vendor: //供应商档案 if (Act == "get") { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); List <EntityVendor> vendor = bll.GetVendor(); return(ControllerHelp.GetReturnStr(1, "", vendor)); } break; case ModelsType.PurchaseType: //采购类型 if (Act == "get") { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); List <EntityPurchaseType> purchasetype = bll.GetPurchaseType(); return(ControllerHelp.GetReturnStr(1, "", purchasetype)); } break; case ModelsType.Inventory: //存货档案 if (Act == "get") { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); List <EntityInventory> inventory = new List <EntityInventory>(); if (string.IsNullOrWhiteSpace(dModifyDate)) { inventory = bll.GetInventory(); } else { inventory = bll.GetInventory(Convert.ToDateTime(dModifyDate)); } return(ControllerHelp.GetReturnStr(1, "", inventory)); } break; case ModelsType.WareHouse: //仓库档案(入库仓库) if (Act == "get") { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); List <EntityWareHouse> warehouse = bll.GetWareHouse(); return(ControllerHelp.GetReturnStr(1, "", warehouse)); } break; case ModelsType.rd_Style: //入库类别档案 if (Act == "get") { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); List <Entityrd_Style> rd_style = bll.Getrd_Style(); return(ControllerHelp.GetReturnStr(1, "", rd_style)); } break; case ModelsType.SettleStyle: //结算方式 if (Act == "get") { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); List <EntitySettleStyle> settlestyle = bll.GetSettleStyle(); return(ControllerHelp.GetReturnStr(1, "", settlestyle)); } break; case ModelsType.CustomerProperty: //经营属性 if (Act == "get") { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); string cuscode = Entity; var customer = bll.GetCustomerProperty(cuscode); return(ControllerHelp.GetReturnStr(1, "", customer)); } break; case ModelsType.InventoryPrice: //存货入库含税单价 if (Act == "get") { if (!string.IsNullOrWhiteSpace(Entity)) { U8BllBase bll = new U8BllBase(StrAccID, AccYear, UserCode, plainPassword); EntityInventoryPrice entity = JsonConvert.DeserializeObject <EntityInventoryPrice>(Entity); var inventoryPrice = bll.GetInventoryPrice(entity.cVenCode, entity.cInvCode); return(ControllerHelp.GetReturnStr(1, "", inventoryPrice)); } } break; case ModelsType.PO_Pomain: //采购订单 if (Act == "query") { PO_PomainBll bll = new PO_PomainBll(StrAccID, AccYear, UserCode, plainPassword); EntityPO_Pomain entity = JsonConvert.DeserializeObject <EntityPO_Pomain>(Entity); int num = bll.GetPO_Pomain(entity.cPOID); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; case ModelsType.RdRecord01: //采购入库单 if (Act == "query") { RdRecord01Bll bll = new RdRecord01Bll(StrAccID, AccYear, UserCode, plainPassword); EntityRdRecord01Head entity = JsonConvert.DeserializeObject <EntityRdRecord01Head>(Entity); int num = bll.GetRdRecord01(entity.cCode); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; case ModelsType.Ap_Vouch: //其他应付单 if (Act == "query") { Ap_VouchBll bll = new Ap_VouchBll(StrAccID, AccYear, UserCode, plainPassword); EntityAp_VouchHead entity = JsonConvert.DeserializeObject <EntityAp_VouchHead>(Entity); int num = bll.GetAp_Vouch(entity.cVouchID); if (num == 0) { return(ControllerHelp.GetReturnStr(1, "new")); } else { return(ControllerHelp.GetReturnStr(2, "old")); } } break; } return(ControllerHelp.GetReturnStr(0, "GetModels(查询)中没有找到可对应的操作项")); }
public string InsertPO_Pomain(EntityPO_Pomain PO_PomainHead) { int?PO_PomainHeadID; if (PO_PomainHead == null || PO_PomainHead.Details == null || PO_PomainHead.Details.Count == 0) { throw new JRException("采购订单新增失败!没有数据!"); } #region 验证 int num = 0; string cmdText = "select count(*) as Num from PO_Pomain where cPOID=@cPOID"; SqlParameter[] paras = { new SqlParameter("@cPOID", PO_PomainHead.cPOID) }; DataTable dt = this.DB_SqlHelper.ExecuteDataTable(cmdText, paras); if (dt != null && dt.Rows.Count > 0) { num = int.Parse(dt.Rows[0]["Num"].ToString()); } if (num > 0) { throw new JRException("数据传递有误,已存在该单号!"); } #endregion int detailCount = PO_PomainHead.Details.Count; int head_id = 0; int body_en_Id = 0; GetId("00", "POMain", detailCount, out head_id, out body_en_Id); string sql = string.Format(@"insert into PO_Pomain(POID,cPOID,dPODate,cVenCode,cexch_name,nflat,iTaxRate, cMaker,cBusType,iDiscountTaxType,cmaketime,cState,cVerifier,iVTid, iverifystateex,cAuditDate,cAuditTime,csysbarcode) values (@POID,@cPOID,@dPODate,@cVenCode,@cexch_name,@nflat,@iTaxRate, @cMaker,@cBusType,@iDiscountTaxType,@cmaketime,@cState,@cVerifier,@iVTid, @iverifystateex,@cAuditDate,@cAuditTime,@csysbarcode)"); SqlParameter[] para = { new SqlParameter("@POID", head_id), new SqlParameter("@cPOID", PO_PomainHead.cPOID), new SqlParameter("@dPODate", PO_PomainHead.dPODate), new SqlParameter("@cVenCode", PO_PomainHead.cVenCode), new SqlParameter("@cexch_name", PO_PomainHead.cexch_name), new SqlParameter("@nflat", PO_PomainHead.nflat), new SqlParameter("@iTaxRate", PO_PomainHead.iTaxRate), new SqlParameter("@cMaker", PO_PomainHead.cMaker), new SqlParameter("@cBusType", PO_PomainHead.cBusType), new SqlParameter("@iDiscountTaxType", PO_PomainHead.iDiscountTaxType), new SqlParameter("@cmaketime", DateTime.Now), new SqlParameter("@cState", PO_PomainHead.cState), new SqlParameter("@cVerifier", PO_PomainHead.cMaker), new SqlParameter("@iVTid", PO_PomainHead.iVTid), new SqlParameter("@iverifystateex", PO_PomainHead.iVerifyStateex), new SqlParameter("@cAuditDate", DateTime.Now.ToShortDateString()), new SqlParameter("@cAuditTime", DateTime.Now), new SqlParameter("@csysbarcode", PO_PomainHead.cSysbarCode), }; int headCount = this.DB_SqlHelper.ExecuteNonQuery(sql, para); if (headCount > 0) { try { List <ExecuteHelp> sqlList = new List <ExecuteHelp>(); PO_PomainHeadID = GetPO_PomainHeadID(PO_PomainHead.cPOID); for (int i = 0; i < detailCount; i++) { EntityPO_PoDetails body = PO_PomainHead.Details[i]; string bodySql = string.Format(@"insert into PO_PoDetails(ID,cInvCode,iQuantity,iUnitPrice,iMoney, iTax,iSum,iNatUnitPrice,iNatMoney,iNatTax,iNatSum,dArriveDate, iPerTaxRate,POID,iTaxPrice) values (@ID,@cInvCode,@iQuantity,@iUnitPrice,@iMoney, @iTax,@iSum,@iNatUnitPrice,@iNatMoney,@iNatTax,@iNatSum,@dArriveDate, @iPerTaxRate,@POID,@iTaxPrice)"); SqlParameter[] bodyPara = { new SqlParameter("@ID", body_en_Id - detailCount + i + 1), new SqlParameter("@cInvCode", body.cInvCode), new SqlParameter("@iQuantity", body.iQuantity), new SqlParameter("@iUnitPrice", body.iUnitPrice), new SqlParameter("@iMoney", body.iMoney), new SqlParameter("@iTax", body.iTax), new SqlParameter("@iSum", body.iSum), new SqlParameter("@iNatUnitPrice", body.iNatUnitPrice), new SqlParameter("@iNatMoney", body.iNatMoney), new SqlParameter("@iNatTax", body.iNatTax), new SqlParameter("@dArriveDate", DateTime.Now), new SqlParameter("@iNatSum", body.iNatSum), new SqlParameter("@iPerTaxRate", body.iPerTaxRate), new SqlParameter("@POID", PO_PomainHeadID), new SqlParameter("@iTaxPrice", body.iTaxPrice), }; sqlList.Add(new ExecuteHelp() { SQL = bodySql, Parameters = bodyPara }); } int bodyCount = this.DB_SqlHelper.ExecuteNonQuery(sqlList); } catch (Exception ex) { DeletePO_Pomain(PO_PomainHead.cPOID); throw ex; } } else { throw new JRException("采购订单表头新增失败"); } return(PO_PomainHeadID == null ? null : PO_PomainHeadID.ToString()); }
/// <summary> /// 新增采购订单 /// </summary> /// <param name="UserCode"></param> /// <param name="PlainPassword"></param> /// <param name="StrAccID"></param> /// <param name="AccYear"></param> /// <param name="Act"></param> /// <param name="Entity"></param> /// <returns></returns> public string AddPO_Pomain(string UserCode, string PlainPassword, string StrAccID, int AccYear, string Act, EntityPO_Pomain entity, out int success) { success = 0; PO_PomainBll bll = new PO_PomainBll(StrAccID, AccYear, UserCode, PlainPassword); #region 验证 string msg = ""; if (!entity.CheckEntity(out msg)) { return(msg); } foreach (EntityPO_PoDetails entitybody in entity.Details) { if (!entitybody.CheckEntity(out msg)) { return(msg); } } if (bll.GetGlmendFlag(entity.dPODate.Year, entity.dPODate.Month, "bflag_PU") == true) { return(string.Format("U8单据{0}日期所在月份已经结账!", entity.cPOID)); } if (!string.IsNullOrEmpty(entity.cVenCode)) { string vendorname = bll.GetVendorName(entity.cVenCode); if (string.IsNullOrEmpty(vendorname)) { return(string.Format("U8中不存在供应商编码:{0}!", entity.cVenCode)); } } #endregion #region 表头 //entity.POID = 0;// //entity.cPOID = ""; //entity.dPODate = DateTime.Now; //entity.cVenCode = ""; entity.cexch_name = entity.cexch_name == null ? "人民币" : entity.cexch_name; //币种名称 entity.nflat = 1; //汇率 //entity.iTaxRate = 17;//表头税率 entity.cMaker = bll.GetUserName(UserCode); entity.iVTid = 8173; //单据模板号 entity.cBusType = "普通采购"; //业务类型 entity.iDiscountTaxType = 0; //扣税类别 entity.cState = 1; //状态默认已审核 entity.iVerifyStateex = 2; //单据审核状态 (-1,终审不同意,0,未提交,1已提交,2,终审同意) entity.cSysbarCode = "||pupo|" + entity.cPOID; #endregion foreach (EntityPO_PoDetails item in entity.Details) { item.ID = 0; //采购订单子表标识 item.iUnitPrice = item.iTaxPrice / (1 + item.iPerTaxRate / 100); item.iMoney = item.iSum / (1 + item.iPerTaxRate / 100); //原币无税金额 item.iTax = item.iSum - item.iMoney; //原币税额 item.iNatUnitPrice = item.iUnitPrice; //本币无税单价 item.iNatMoney = item.iMoney; //本币无税金额 item.iNatTax = item.iTax; //本币税额 item.iNatSum = item.iSum; //本币价税合计 item.iTaxPrice = item.iTaxPrice; //原币含税单价 entity.iTaxRate = item.iPerTaxRate; //表头税率 } string id = bll.InsertPO_Pomain(entity); success = string.IsNullOrWhiteSpace(id) ? 0 : 1; return(id); }