/// <summary> /// 更新POItems /// </summary> /// <param name="entity"></param> /// <param name="docNo"></param> public virtual void UpdatePOItem(APInvoicePOItemInfo entity, int docNo) { DataCommand command = DataCommandManager.GetDataCommand("UpdateAPInvoicePOItem"); command.SetParameterValue("@DocNo", docNo); command.SetParameterValue("@PoNo", entity.PoNo); command.SetParameterValue("@PoWarehouseNo", entity.PoStockSysNo ?? 0); command.SetParameterValue("@PoCurrency", 1); command.SetParameterValue("@PoAmt", entity.PoAmt ?? 0); command.SetParameterValue("@EIMSNo", entity.EIMSNo); if (entity.EIMSAmt == null) { entity.EIMSAmt = 0; } command.SetParameterValue("@EIMSAmt", entity.EIMSAmt); if (entity.EIMSNetAmt == null) { entity.EIMSNetAmt = 0; } command.SetParameterValue("@EIMSNetAmt", entity.EIMSNetAmt); command.SetParameterValue("@EIMSNetTaxAmt", entity.EIMSNetTaxAmt); command.SetParameterValue("@PoNetAmt", entity.PoNetAmt); command.SetParameterValue("@PaymentAmt", entity.PaymentAmt ?? 0); command.SetParameterValue("@PoBaselineDate", entity.PoBaselineDate); command.SetParameterValue("@PoPaymentTerm", entity.PoPaymentTerm); command.SetParameterValue("@Status", entity.Status); command.SetParameterValue("@EditDate", DateTime.Now); command.SetParameterValueAsCurrentUserAcct("@EditUser"); command.SetParameterValue("@OrderType", (int)entity.OrderType); command.SetParameterValue("@BatchNumber", entity.BatchNumber); command.SetParameterValue("@PayableTaxAmt", entity.PayableTaxAmt); command.ExecuteNonQuery(); }
/// <summary> /// 批量设置咨询回复的状态及置顶情况 /// </summary> /// <param name="items"></param> /// <param name="status"></param> public void BatchSetProductConsultReplyStatus(List <int> items, string status) { StringBuilder message = new StringBuilder(); if (status == "Y" || status == "N")//置顶情况 { foreach (var i in items) { message.Append(i.ToString() + ","); } DataCommand dc = DataCommandManager.GetDataCommand("ProductConsult_BatchUpdateProductConsultReplyIsTop"); dc.SetParameterValue("@SysNoString", message.ToString().TrimEnd(',')); dc.SetParameterValue("@IsTop", status); dc.SetParameterValueAsCurrentUserAcct("EditUser"); dc.ExecuteNonQuery(); } else { foreach (int sysNo in items) { DataCommand dc = DataCommandManager.GetDataCommand("ProductConsult_UpdateProductConsultStatusForUpdateReplyStatus"); dc.SetParameterValue("@SysNo", sysNo); dc.SetParameterValue("@Status", status); dc.SetParameterValueAsCurrentUserAcct("EditUser"); dc.ExecuteNonQuery(); } //DataCommand dc = DataCommandManager.GetDataCommand("ProductConsult_BatchUpdateProductConsultReplyStatus"); //dc.SetParameterValue("@SysNoString", message.ToString().TrimEnd(',')); //dc.SetParameterValue("@Status", status); //dc.SetParameterValueAsCurrentUserAcct("EditUser"); //dc.ExecuteNonQuery(); } }
/// <summary> /// 新建APInvoice Master信息 /// </summary> /// <param name="entity"></param> /// <returns></returns> public virtual int InsertAPInvoiceMaster(APInvoiceInfo entity) { DataCommand command = DataCommandManager.GetDataCommand("InsertMaster"); //command.SetParameterValue("@DocDate", entity.DocDate); command.SetParameterValue("@WareHouseNo", entity.StockSysNo); command.SetParameterValue("@VendorSysNo", entity.VendorSysNo); command.SetParameterValue("@VendorName", entity.VendorName); command.SetParameterValue("@VendorTaxRate", entity.VendorTaxRate); command.SetParameterValue("@Memo", entity.Memo); command.SetParameterValue("@DiffMemo", entity.DiffMemo); command.SetParameterValue("@PoNetAmt", entity.PoNetAmt); command.SetParameterValue("@PoNetTaxAmt", entity.PoNetTaxAmt); command.SetParameterValue("@InvoiceAmt", entity.InvoiceAmt ?? 0); command.SetParameterValue("@InvoiceTaxAmt", entity.InvoiceTaxAmt ?? 0); command.SetParameterValue("@DiffTaxAmt", entity.DiffTaxAmt); command.SetParameterValue("@DiffTaxTreatmentType", entity.DiffTaxTreatmentType); command.SetParameterValueAsCurrentUserAcct("@InUser"); //command.SetParameterValue("@InDate", entity.InDate); command.SetParameterValue("@ConfirmUser", entity.ConfirmUser); command.SetParameterValue("@ConfirmDate", entity.ConfirmDate); command.SetParameterValue("@Status", entity.Status); //command.SetParameterValue("LanguageCode", entity.LanguageCode); //command.SetParameterValue("CurrencyCode", entity.CurrencyCode); command.SetParameterValue("CompanyCode", entity.CompanyCode); //command.SetParameterValue("StoreCompanyCode", entity.StoreCompanyCode); return(Convert.ToInt32(command.ExecuteScalar())); }
/// <summary> /// 更新APInvoice Master信息 /// </summary> /// <param name="entity"></param> public virtual void UpdateAPInvoiceMaster(APInvoiceInfo entity) { DataCommand command = DataCommandManager.GetDataCommand("UpdateAPInvoiceMaster"); command.SetParameterValue("@WareHouseNo", entity.StockSysNo); command.SetParameterValue("@VendorSysNo", entity.VendorSysNo); command.SetParameterValue("@VendorName", entity.VendorName); command.SetParameterValue("@VendorTaxRate", entity.VendorTaxRate); command.SetParameterValue("@Memo", entity.Memo); if (entity.DiffMemo == null) { entity.DiffMemo = ""; } command.SetParameterValue("@DiffMemo", entity.DiffMemo); command.SetParameterValue("@PoNetAmt", entity.PoNetAmt); command.SetParameterValue("@PoNetTaxAmt", entity.PoNetTaxAmt); command.SetParameterValue("@InvoiceAmt", entity.InvoiceAmt); command.SetParameterValue("@InvoiceTaxAmt", entity.InvoiceTaxAmt); command.SetParameterValue("@DiffTaxAmt", entity.DiffTaxAmt); command.SetParameterValue("@DiffTaxTreatmentType", entity.DiffTaxTreatmentType); command.SetParameterValue("@Status", entity.Status); command.SetParameterValue("@EditDate", DateTime.Now); command.SetParameterValueAsCurrentUserAcct("@EditUser"); command.SetParameterValue("@DocNo", entity.SysNo); command.ExecuteNonQuery(); }
public void DeleteCategoryMapping(int dynamicCategorySysNo) { DataCommand cmd = DataCommandManager.GetDataCommand("MKT_DeleteCategoryMapping"); cmd.SetParameterValue("@DynamicCategorySysNo", dynamicCategorySysNo); cmd.SetParameterValueAsCurrentUserAcct("@EditUser"); cmd.ExecuteNonQuery(); }
/// <summary> /// 删除 /// </summary> /// <param name="SysNo"></param> public void DeleteAdvertising(int SysNo) { DataCommand cmd = DataCommandManager.GetDataCommand("DeleteAd"); cmd.SetParameterValue("@SysNo", SysNo); cmd.SetParameterValueAsCurrentUserAcct("@EditUser"); cmd.ExecuteNonQuery(); }
public void Deactive(int sysNo) { DataCommand cmd = DataCommandManager.GetDataCommand("ProductRecommend_Deactive"); cmd.SetParameterValue("@SysNo", sysNo); cmd.SetParameterValueAsCurrentUserAcct("@EditUser"); cmd.ExecuteNonQuery(); }
/// <summary> /// 讨论回复加1,并设置相关状态 /// </summary> /// <param name="discussSysNo"></param> public void UpdateProductDiscussReplyCount(int discussSysNo) { DataCommand dc = DataCommandManager.GetDataCommand("ProductDiscuss_UpdateProductDiscussCount"); dc.SetParameterValue("@DiscussSysNo", discussSysNo); dc.SetParameterValueAsCurrentUserAcct("InUser"); dc.ExecuteNonQuery(); }
public void ReadGroupbuyingFeedback(int sysNo) { DataCommand command = DataCommandManager.GetDataCommand("ReadGroupbuyingFeedback"); command.SetParameterValue("@SysNo", sysNo); command.SetParameterValueAsCurrentUserAcct("@EditUser"); command.ExecuteNonQuery(); }
public void HandleGroupbuyingBusinessCooperation(int sysNo) { DataCommand command = DataCommandManager.GetDataCommand("HandleGroupbuyingBusinessCooperation"); command.SetParameterValue("@SysNo", sysNo); command.SetParameterValueAsCurrentUserAcct("@EditUser"); command.ExecuteNonQuery(); }
public void AuditComputerConfigMaster(int masterSysNo, ComputerConfigStatus targetStatus) { DataCommand command = DataCommandManager.GetDataCommand("AuditComputerConfigMaster"); command.SetParameterValue("@ComputerConfigMasterSysNo", masterSysNo); command.SetParameterValue("@Status", targetStatus); command.SetParameterValueAsCurrentUserAcct("@AuditUser"); command.ExecuteNonQuery(); }
public void AbandonResponsibleUser(int sysNo) { DataCommand cmd = DataCommandManager.GetDataCommand("AbandonResponsibleUser"); cmd.SetParameterValue("@SysNo", sysNo); cmd.SetParameterValueAsCurrentUserAcct("@EditUser"); cmd.ExecuteNonQuery(); }
/// <summary> /// 通过通过电汇邮局收款单系统编号更新订单关联信息状态 /// </summary> /// <param name="postIncomeSysNo">通过电汇邮局收款单系统编号</param> /// <param name="status">需要更新到的状态</param> public void UpdatePostIncomeConfirmStatus(int postIncomeSysNo, PostIncomeConfirmStatus status) { DataCommand command = DataCommandManager.GetDataCommand("UpdatePostIncomeConfirm"); command.SetParameterValue("@SysNo", postIncomeSysNo); command.SetParameterValue("@Status", status); command.SetParameterValueAsCurrentUserAcct("@EditUser"); command.ExecuteNonQuery(); }
/// <summary> /// 创建Alipay退款信息 /// </summary> /// <param name="soSysNo"></param> /// <param name="companyCode"></param> public virtual void CreateAliPayRefund(int soSysNo) { DataCommand command = DataCommandManager.GetDataCommand("CreateAliPayRefund"); command.SetParameterValue("@SoSysNo", soSysNo); command.SetParameterValueAsCurrentUserAcct("@InUser"); command.ExecuteNonQuery(); }
/// <summary> /// 更新评论之后更新Homepage中的记录 /// </summary> /// <param name="sysNo"></param> /// <param name="type"></param> public void UpdateHomepageForProductReview(int sysNo, string type) { DataCommand dc = DataCommandManager.GetDataCommand("ProductReview_UpdateHomepageSetting"); dc.SetParameterValue("@SysNo", sysNo); dc.SetParameterValue("@Type", type); dc.SetParameterValueAsCurrentUserAcct("EditUser"); dc.ExecuteNonQuery(); }
public void InsertProductBatchManagementLog(ProductBatchManagementInfoLog entity) { DataCommand command = DataCommandManager.GetDataCommand("InsertProductBatchManagementLog"); command.SetParameterValue("@BatchManagementSysNo", entity.BatchManagementSysNo); command.SetParameterValue("@Note", entity.Note); command.SetParameterValueAsCurrentUserAcct("@InUser"); command.ExecuteNonQuery(); }
public void InsertCategoryProductMapping(int ecCategorySysNo, int productSysNo) { DataCommand cmd = DataCommandManager.GetDataCommand("MKT_InsertECCategoryProductMapping"); cmd.SetParameterValue("@ECCategorySysNo", ecCategorySysNo); cmd.SetParameterValue("@ProductSysNo", productSysNo); cmd.SetParameterValueAsCurrentUserAcct("@InUser"); cmd.ExecuteNonQuery(); }
/// <summary> /// 更新InvoiceItem状态 /// </summary> /// <param name="docNo"></param> public virtual void UpdateInvoItemStatus(int docNo) { DataCommand command = DataCommandManager.GetDataCommand("UpdateInvoItemStatus"); command.SetParameterValue("@DocNo", docNo); command.SetParameterValueAsCurrentUserAcct("@EditUser"); command.ExecuteNonQuery(); }
public virtual void Audit(int refundRequestSysNo, BizEntity.Customer.RefundRequestStatus refundRequestStatus, string memo) { DataCommand cmd = DataCommandManager.GetDataCommand("RefundRequestAudit"); cmd.SetParameterValue("@SysNo", refundRequestSysNo); cmd.SetParameterValue("@Status", refundRequestStatus); cmd.SetParameterValue("@RejectionReason", memo); cmd.SetParameterValueAsCurrentUserAcct("@EditUserName"); cmd.ExecuteNonQuery(); }
/// <summary> /// 删除 /// </summary> /// <param name="item"></param> public void DeleteGiftCardFabrication(int sysNo) { DataCommand cmd = DataCommandManager.GetDataCommand("GiftCard_DeleteGiftCardFabrications"); cmd.SetParameterValue("@SysNo", sysNo); cmd.SetParameterValueAsCurrentUserAcct("@EditUser"); cmd.ExecuteNonQuery(); }
public void Create(int AreaSysNo, int RefSysNo, BizEntity.MKT.AreaRelationType Type) { DataCommand dc = DataCommandManager.GetDataCommand("AreaRelation_Create"); dc.SetParameterValue("@AreaSysNo", AreaSysNo); dc.SetParameterValue("@RefSysNo", RefSysNo); dc.SetParameterValue("@Type", Type); dc.SetParameterValueAsCurrentUserAcct("@InUser"); dc.ExecuteNonQuery(); }
public void UpdateTrackingInfoResponsibleUserName(TrackingInfo entity) { DataCommand cmd = DataCommandManager.GetDataCommand("UpdateTrackingInfoResponsibleUserName"); cmd.SetParameterValue("@SysNo", entity.SysNo); cmd.SetParameterValue("@ResponsibleUserName", entity.ResponsibleUserName); cmd.SetParameterValueAsCurrentUserAcct("@EditUser"); cmd.ExecuteNonQuery(); }
/// <summary> /// 更新APInvoice状态及处理人 /// </summary> /// <param name="entity"></param> public virtual void UpdateAPInvoiceStatusWithConfirmUser(APInvoiceInfo entity) { DataCommand command = DataCommandManager.GetDataCommand("UpdateAPInvoiceStatusWithConfirmUser"); command.SetParameterValue("@Status", entity.Status); command.SetParameterValue("@DocNo", entity.SysNo); command.SetParameterValueAsCurrentUserSysNo("@EditUser"); command.SetParameterValueAsCurrentUserAcct("@ConfirmUser"); command.ExecuteNonQuery(); }
public int UpdateShiftBasket(BizEntity.Inventory.ShiftRequestItemInfo item) { DataCommand dc = DataCommandManager.GetDataCommand("UpdateShiftBasket"); dc.SetParameterValue("@SysNo", item.SysNo); dc.SetParameterValue("@ShiftQty", item.ShiftQuantity); dc.SetParameterValue("@EditDate", DateTime.Now); dc.SetParameterValueAsCurrentUserAcct("@EditUser"); return(dc.ExecuteNonQuery()); }
public void UpdateTrackingInfoStatus(TrackingInfo entity) { DataCommand cmd = DataCommandManager.GetDataCommand("UpdateTrackingInfoStatus"); cmd.SetParameterValue("@SysNo", entity.SysNo); cmd.SetParameterValue("@Status", entity.Status); cmd.SetParameterValueAsCurrentUserAcct("@EditUser"); cmd.ExecuteNonQuery(); }
public virtual bool UpdateCustomerRight(int customerSysNo, int right) { DataCommand cmd = DataCommandManager.GetDataCommand("UpdateCustomerRight"); cmd.SetParameterValue("@Right", right); cmd.SetParameterValue("@CustomerSysNo", customerSysNo); cmd.SetParameterValueAsCurrentUserAcct("@EidtUserName"); cmd.ExecuteNonQuery(); return(true); }
public void CreateGroupBuyingActivityRel(int groupBuyingSysNo, int vendorStoreSysNo) { DataCommand command = DataCommandManager.GetDataCommand("CreateGroupBuyingActivityRel"); command.SetParameterValue("@GroupBuyingSysNo", groupBuyingSysNo); command.SetParameterValue("@VendorStoreSysNo", vendorStoreSysNo); command.SetParameterValueAsCurrentUserAcct("@CreateUser"); command.ExecuteNonQuery(); }
public void UpdateGroupBuyingSettlementStatus(int sysNo, SettlementBillStatus status) { DataCommand command = DataCommandManager.GetDataCommand("UpdateGroupBuyingSettlementStatus"); command.SetParameterValue("@SysNo", sysNo); command.SetParameterValue("@Status", status); command.SetParameterValueAsCurrentUserAcct("@EditUser"); command.ExecuteNonQuery(); }
public void MaintainCountdownStatus(CountdownInfo entity) { DataCommand command = DataCommandManager.GetDataCommand("MaintainCountdownStatus"); command.SetParameterValue("@SysNo", entity.SysNo); command.SetParameterValue("@Status", entity.Status); command.SetParameterValue("@CompanyCode", entity.CompanyCode); command.SetParameterValueAsCurrentUserAcct("@EditUser"); command.ExecuteNonQuery(); }
public void VerifyCountdown(CountdownInfo entity) { DataCommand command = DataCommandManager.GetDataCommand("VerifyCountdown"); command.SetParameterValue("@SysNo", entity.SysNo); command.SetParameterValue("@Status", entity.Status); command.SetParameterValue("@VerifyMemo", entity.VerifyMemo); command.SetParameterValue("@CompanyCode", entity.CompanyCode); command.SetParameterValueAsCurrentUserAcct("@AuditUser"); command.ExecuteNonQuery(); }