/// <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();
}