public static PurchaseOrderInfo CreatePO(PurchaseOrderInfo poInfo) { DataCommand command = DataCommandManager.GetDataCommand("CreatePOMaster"); command.SetParameterValue("@SysNo", poInfo.SysNo.Value); command.SetParameterValue("@POID", poInfo.PurchaseOrderBasicInfo.PurchaseOrderID); command.SetParameterValue("@VendorSysNo", int.Parse(poInfo.VendorInfo.VendorID)); command.SetParameterValue("@ITStockSysNo", DBNull.Value); command.SetParameterValue("@StockSysNo", poInfo.PurchaseOrderBasicInfo.StockInfo.SysNo); command.SetParameterValue("@ShipTypeSysNo", 0); command.SetParameterValue("@PayTypeSysNo", 0); command.SetParameterValue("@CurrencySysNo", poInfo.PurchaseOrderBasicInfo.CurrencyCode); command.SetParameterValue("@ExchangeRate", poInfo.PurchaseOrderBasicInfo.ExchangeRate); command.SetParameterValue("@TotalAmt", poInfo.PurchaseOrderBasicInfo.TotalAmt); command.SetParameterValue("@CreateTime", DateTime.Now); command.SetParameterValue("@CreateUserSysNo", poInfo.InUserSysNo); command.SetParameterValue("@AuditTime", DBNull.Value); command.SetParameterValue("@AuditUserSysNo", DBNull.Value); command.SetParameterValue("@InTime", DBNull.Value); command.SetParameterValue("@InUserSysNo", DBNull.Value); command.SetParameterValue("@IsApportion", poInfo.PurchaseOrderBasicInfo.IsApportion); command.SetParameterValue("@ApportionTime", DBNull.Value); command.SetParameterValue("@ApportionUserSysNo", DBNull.Value); command.SetParameterValue("@Memo", poInfo.PurchaseOrderBasicInfo.MemoInfo.Memo); command.SetParameterValue("@InStockMemo", poInfo.PurchaseOrderBasicInfo.MemoInfo.InStockMemo); command.SetParameterValue("@Status", (int)poInfo.PurchaseOrderBasicInfo.PurchaseOrderStatus); command.SetParameterValue("@ETP", poInfo.PurchaseOrderBasicInfo.ETP); command.SetParameterValue("@IsConsign", (int)poInfo.PurchaseOrderBasicInfo.ConsignFlag); command.SetParameterValue("@POType", (int)poInfo.PurchaseOrderBasicInfo.PurchaseOrderType); command.SetParameterValue("@TaxRate", poInfo.PurchaseOrderBasicInfo.TaxRate); command.SetParameterValue("@PurchaseStockSysno", DBNull.Value); command.SetParameterValue("@PMSysNo", 1); command.SetParameterValue("@ETATime", poInfo.PurchaseOrderBasicInfo.ETATimeInfo.ETATime.HasValue ? poInfo.PurchaseOrderBasicInfo.ETATimeInfo.ETATime.Value.ToString("yyyy-MM-dd 00:00:00") : null); command.SetParameterValue("@ETAHalfDay", poInfo.PurchaseOrderBasicInfo.ETATimeInfo.HalfDay); command.SetParameterValue("@AutoSendMail", poInfo.PurchaseOrderBasicInfo.AutoSendMailAddress == "-999" ? "" : poInfo.PurchaseOrderBasicInfo.AutoSendMailAddress); command.SetParameterValue("@CompanyCode", poInfo.CompanyCode); command.ExecuteScalar(); return(poInfo); }
/// <summary> /// 根据SysNo获得货币实体信息 /// </summary> /// <returns></returns> public static AutoClose.Model.CurrencyInfo QueryCurrencyInfoBySysNo(int SysNo) { CurrencyInfo result = new AutoClose.Model.CurrencyInfo(); DataCommand cmd = DataCommandManager.GetDataCommand("GetCurrencyBySysNo"); cmd.SetParameterValue("@SysNo", SysNo); cmd.SetParameterValue("@CompanyCode", Settings.CompanyCode); //DataCommand selectCommand = DataCommandManager.GetDataCommand("GetCurrencyBySysNo"); //ProviderHelper.SetCommonParams(selectCommand); //selectCommand.SetParameterValue("@SysNo", SysNo); List <CurrencyInfo> list = cmd.ExecuteEntityList <CurrencyInfo>(); if (list.Count > 0) { return(list[0]); } else { return(null); } }
public void SynSysUser(ControlPanelUser controlPanelUser, int userSysNo, int generateUserSysNo) { DataCommand cmd; if (userSysNo == 0) { cmd = DataCommandManager.GetDataCommand("InsertNewUserInOldData"); cmd.SetParameterValue("@GenerateUserSysNo", generateUserSysNo); cmd.SetParameterValue("@UserID", controlPanelUser.LoginName); } else { cmd = DataCommandManager.GetDataCommand("UpdateExistUserInOldData"); cmd.SetParameterValue("@SysNo", userSysNo); } cmd.SetParameterValue("@UserName", controlPanelUser.DisplayName); cmd.SetParameterValue("@Email", controlPanelUser.EmailAddress); cmd.SetParameterValue("@Phone", controlPanelUser.PhoneNumber); cmd.SetParameterValue("@Status", MappingStatus(controlPanelUser.Status)); cmd.ExecuteNonQuery(); }
public List <int> GetBackUpPMList(int userSysNo, string companyCode) { DataCommand dataCommand = DataCommandManager.GetDataCommand("GetBackupUserListBySysNo"); dataCommand.SetParameterValue("@PMUserSysNo", userSysNo); dataCommand.SetParameterValue("@CompanyCode", companyCode); string userList = dataCommand.ExecuteScalar() as string; List <int> result = new List <int>(); if (!string.IsNullOrEmpty(userList)) { string[] pms = userList.Split(';'); int[] pmlist = Array.ConvertAll(pms, str => { int p = 0; int.TryParse(str, out p); return(p); }); result.AddRange(pmlist); } return(result); }
public BizEntity.PO.CommissionRule CreateCommission(BizEntity.PO.CommissionRule newCommissionRule) { DataCommand command = DataCommandManager.GetDataCommand("InsertCommissionRule"); command.SetParameterValue("@BrandSysNo", newCommissionRule.BrandSysNo); command.SetParameterValue("@ManufacturerSysNo", newCommissionRule.ManufacturerSysNo); command.SetParameterValue("@CostValue", newCommissionRule.CostValue); command.SetParameterValue("@RuleType", newCommissionRule.RuleType); command.SetParameterValue("@IsDefaultRule", newCommissionRule.IsDefaultRule); command.SetParameterValue("@Level", newCommissionRule.Level); command.SetParameterValue("@InUser", newCommissionRule.InUser); command.SetParameterValue("@EditUser", newCommissionRule.EditUser); #region [根据佣金等级获取类别编号:] int?categorySysNo = null; switch (newCommissionRule.Level) { case "0": categorySysNo = null; break; case "1": categorySysNo = newCommissionRule.C1SysNo; break; case "2": categorySysNo = newCommissionRule.C2SysNo; break; case "3": categorySysNo = newCommissionRule.C3SysNo; break; } #endregion command.SetParameterValue("@CategorySysNo", categorySysNo); command.ExecuteNonQuery(); return(newCommissionRule); }
/// <summary> /// 修改分仓库存 /// </summary> /// <param name="list"></param> public static void ModifyQty(List <ProductEntity> list) { CommonConst commonConst = new CommonConst(); foreach (ProductEntity entity in list) { if (entity.InventoryAlarmQty.HasValue) { DataCommand command = DataCommandManager.GetDataCommand("ModifyStockQty"); command.SetParameterValue("@ProductMappingSysNo", entity.ProductMappingSysNo); command.SetParameterValue("@WarehouseNumber", entity.WarehouseNumber); command.SetParameterValue("@InventoryQty", entity.ResultQty); command.SetParameterValue("@CompanyCode", commonConst.CompanyCode); command.ExecuteNonQuery(); } else { InsertStockQty(entity); } } }
public int?CreateMaster(SaleGiftInfo info) { DataCommand cmd = DataCommandManager.GetDataCommand("SaleGift_CreateSaleGiftMaster"); cmd.SetParameterValue("@PromotionName", info.Title.Content); cmd.SetParameterValue("@PromotionDesc", info.Description.Content); cmd.SetParameterValue("@Type", info.Type); cmd.SetParameterValue("@Status", SaleGiftStatus.Init); cmd.SetParameterValue("@BeginDate", info.BeginDate); cmd.SetParameterValue("@Enddate", info.EndDate); cmd.SetParameterValue("@AmountLimit", info.OrderCondition.OrderMinAmount == null ? 0 : info.OrderCondition.OrderMinAmount.Value); cmd.SetParameterValue("@PromotionLink", info.PromotionLink); cmd.SetParameterValue("@Memo", info.Memo); cmd.SetParameterValue("@InUser", info.InUser ?? ""); cmd.SetParameterValue("@DisCountType", info.DisCountType); cmd.SetParameterValue("@IsGlobal", info.IsGlobalProduct.HasValue && info.IsGlobalProduct.Value ? "Y" : "N"); cmd.SetParameterValue("@CompanyCode", info.CompanyCode); cmd.SetParameterValue("@VendorSysNo", info.VendorSysNo); cmd.ExecuteNonQuery(); info.SysNo = (int)cmd.GetParameterValue("@SysNo"); return(info.SysNo); }
public override object OnGet(OrderProducts_Alvin request) { DataCommand dataCommand = null; List <OrderProductsEntity> list = null; if (request.OrderListID != null) { dataCommand = DataCommandManager .GetDataCommand("Alvin_GetOrderProductByID"); list = dataCommand.ExecuteEntityList <OrderProductsEntity>( new { OrderListID = request.OrderListID } ); } return(new ResultEntity <List <OrderProductsEntity> > { Result = "成功", ResultCode = 200, ResultContent = list }); }
public void UpdateProductCommonInfoBasicInfo(ProductCommonInfo productCommonInfo, UserInfo operationUser) { DataCommand dc = DataCommandManager.GetDataCommand("UpdateProductCommonInfoBasicInfo"); dc.SetParameterValue("@ProductCommonInfoSysNo", productCommonInfo.ProductCommonInfoSysNo); dc.SetParameterValue("@ProductTitle", productCommonInfo.ProductBasicInfo.ProductTitle.Content); dc.SetParameterValue("@ProductBriefName", productCommonInfo.ProductBasicInfo.ProductBriefName); dc.SetParameterValue("@Keywords", productCommonInfo.ProductBasicInfo.Keywords.Content); dc.SetParameterValue("@ProductModel", productCommonInfo.ProductBasicInfo.ProductModel.Content); dc.SetParameterValue("@ProductType", productCommonInfo.ProductBasicInfo.ProductType); dc.SetParameterValue("@PMUserSysNo", productCommonInfo.ProductBasicInfo.ProductManager.SysNo); dc.SetParameterValue("@ProductDescription", productCommonInfo.ProductBasicInfo.ShortDescription.Content); dc.SetParameterValue("@PackageList", productCommonInfo.ProductBasicInfo.PackageList.Content); dc.SetParameterValue("@ProductLink", productCommonInfo.ProductBasicInfo.ProductLink); dc.SetParameterValue("@Attention", productCommonInfo.ProductBasicInfo.Attention.Content); dc.SetParameterValue("@IsTakePicture", productCommonInfo.ProductBasicInfo.IsTakePicture); dc.SetParameterValue("@UPCCode", productCommonInfo.ProductBasicInfo.UPCCode); dc.SetParameterValue("@BMCode", productCommonInfo.ProductBasicInfo.BMCode); dc.SetParameterValue("@EditUser", operationUser.UserDisplayName); dc.SetParameterValue("@EditUserSysNo", operationUser.SysNo); dc.ExecuteNonQuery(); }
/// <summary> /// 创建厂商信息 /// </summary> /// <param name="entity"></param> /// <returns></returns> public virtual ManufacturerInfo CreateManufacturer(ManufacturerInfo entity) { DataCommand cmd = DataCommandManager.GetDataCommand("CreateManufacturer"); cmd.SetParameterValue("@ManufacturerName", entity.ManufacturerNameLocal != null ? entity.ManufacturerNameLocal.Content : null); cmd.SetParameterValue("@BriefName", entity.ManufacturerNameGlobal); cmd.SetParameterValue("@Note", entity.ManufacturerDescription != null ? entity.ManufacturerDescription.Content : null); cmd.SetParameterValue("@Status", entity.Status); cmd.SetParameterValue("@ManufacturerWebSite", entity.SupportInfo.ManufacturerUrl); cmd.SetParameterValue("@SupportEmail", entity.SupportInfo.ServiceEmail); cmd.SetParameterValue("@SupportURL", entity.SupportInfo.ServiceUrl); cmd.SetParameterValue("@Type", 0); cmd.SetParameterValue("@CustomerServicePhone", entity.SupportInfo.ServicePhone); cmd.SetParameterValue("@CompanyCode", entity.CompanyCode); cmd.SetParameterValue("@LanguageCode", entity.LanguageCode); cmd.ExecuteNonQuery(); if (entity.SysNo == 0 || entity.SysNo == null) { entity.SysNo = (int)cmd.GetParameterValue("@SysNo"); } return(entity); }
public void CreateRMAPolicyLog(RmaPolicyInfo info, RmaLogActionType actionType) { DataCommand cmd = DataCommandManager.GetDataCommand("CreateRMAPolicyLog"); cmd.SetParameterValue("@RMAPolicyName", info.RMAPolicyName); cmd.SetParameterValue("@RMAPolicySysNo", info.SysNo); cmd.SetParameterValue("@Priority", info.Priority); cmd.SetParameterValue("@Type", info.RmaType); cmd.SetParameterValue("@Status", info.Status); cmd.SetParameterValue("@ECDisplayName", info.ECDisplayName); cmd.SetParameterValue("@ECDisplayDesc", info.ECDisplayDesc); cmd.SetParameterValue("@ECDisplayMoreDesc", info.ECDisplayMoreDesc); cmd.SetParameterValue("@ReturnDate", info.ReturnDate); cmd.SetParameterValue("@ChangeDate", info.ChangeDate); cmd.SetParameterValue("@IsOnlineRequst", info.IsOnlineRequest); cmd.SetParameterValue("@InUser", info.User.UserDisplayName); cmd.SetParameterValue("@CompanyCode", info.CompanyCode); cmd.SetParameterValue("@StoreCompanyCode", info.CompanyCode); cmd.SetParameterValue("@LanguageCode", info.LanguageCode); cmd.SetParameterValue("@OperationType", actionType); cmd.ExecuteNonQuery(); }
public Result <MessageModel> SendSms(int userId, string content) { var result = new Result <MessageModel>(); using (var cmd = DataCommandManager.GetDataCommand("InsertMessage")) { cmd.SetParameterValue("@UserId", userId); cmd.SetParameterValue("@MsgContent", content); cmd.SetParameterValue("@CreateTime", DateTime.Now); cmd.SetParameterValue("@Status", 0); result.Status = new Status(); if (cmd.ExecuteNonQuery() > 0) { result.Status.Code = "1"; } else { result.Status.Code = "0"; } } return(result); }
public virtual DataTable QueryProductCardsByProductSysNo(int productSysNo) { DataCommand cmd = DataCommandManager.GetDataCommand("QueryProductCards"); cmd.SetParameterValue("@ProductSysNo", productSysNo); DataTable dt = cmd.ExecuteDataTable(); dt.Columns.Add("ThenQty", typeof(int)); if (dt != null && dt.Rows.Count > 0) { // 针对一个已按 RecordTime 降序排列的货卡 List // 该货卡长度为 M 的话,第 N (0 < N <= M) 个货卡的 ThenQty 值就等于 // 第 N + 1 个货卡的 ThenQty 与第 N 个货卡的 AffectQty 之和 // 而第 M 个货卡的 ThenQty 则等于 0 与第 M 个货卡的 AffectQty 之和 for (int then = 0, i = dt.Rows.Count - 1; i > -1; --i) { then += Convert.ToInt32(dt.Rows[i]["AffectQty"]); dt.Rows[i]["ThenQty"] = then; } } return(dt); }
public AdvertisingInfo Load(int sysNo) { AdvertisingInfo info = null; DataCommand cmd = DataCommandManager.GetDataCommand("LoadAdInfo"); cmd.SetParameterValue("@SysNo", sysNo); EnumColumnList enumList = new EnumColumnList(); enumList.Add("Type", typeof(AdvertisingType)); enumList.Add("Status", typeof(ValidStatus)); DataTable dtMaster = cmd.ExecuteDataTable(enumList); if (dtMaster == null || dtMaster.Rows.Count == 0) { return(null); } info = DataMapper.GetEntity <AdvertisingInfo>(dtMaster.Rows[0], null); return(info); }
public static OnlineList Insert(OnlineList entity) { DataCommand command = DataCommandManager.GetDataCommand("InsertOnlineList"); command.SetParameterValue("@OnlineListlocationSysNo", entity.OnlineLocationSysNo); command.SetParameterValue("@ProductID", entity.ProductID); command.SetParameterValue("@Priority", entity.Priority); command.SetParameterValue("@BeginDate", DateTime.Now); command.SetParameterValue("@EndDate", DateTime.Now.AddDays(1)); command.SetParameterValue("@InDate", DateTime.Now); command.SetParameterValue("@InUser", "System"); command.SetParameterValue("@EditDate", DateTime.Now); command.SetParameterValue("@EditUser", "System"); command.SetParameterValue("@Status", "A"); command.SetParameterValue("@CompanyCode", CompanyCode); command.SetParameterValue("@LanguageCode", LanguageCode); command.SetParameterValue("@StoreCompanyCode", CompanyCode); command.ExecuteNonQuery(); entity.SysNo = (int)command.GetParameterValue("@SysNo"); return(entity); }
/// <summary> /// 设置产品讨论回复的状态 /// </summary> /// <param name="itemID"></param> /// <param name="status"></param> public void BatchSetProductDiscussReplyStatus(List <int> items, string status) { foreach (int sysNo in items) { DataCommand dc = DataCommandManager.GetDataCommand("ProductDiscuss_UpdateProductDiscussStatusForUpdateReplyStatus"); dc.SetParameterValue("@SysNo", sysNo); dc.SetParameterValue("@Status", status); dc.SetParameterValueAsCurrentUserAcct("EditUser"); dc.ExecuteNonQuery(); } //StringBuilder message = new StringBuilder(); //foreach (var i in items) //{ // message.Append(i.ToString() + ","); //} //DataCommand dc = DataCommandManager.GetDataCommand("ProductDiscuss_BatchUpdateProductDiscussReplyStatus"); //dc.SetParameterValue("@SysNoString", message.ToString().TrimEnd(',')); //dc.SetParameterValue("@Status", status); //dc.SetParameterValueAsCurrentUserAcct("EditUser"); //dc.ExecuteNonQuery(); }
public SOInstallmentInfo UpdateSOInstallmentWithoutCreditCardInfo(SOInstallmentInfo entity) { DataCommand dc = DataCommandManager.GetDataCommand("UpdateSOInstallmentWithoutCreditCardInfo"); dc.SetParameterValue("@CompanyCode", "8601"); dc.SetParameterValue("@SOSysNo", entity.SOSysNo); dc.SetParameterValue("@BankSysNo", entity.BankSysNo); dc.SetParameterValue("@PhaseCount", entity.PhaseCount); dc.SetParameterValue("@Status", entity.Status); dc.SetParameterValue("@ContractNumber", entity.ContractNumber); dc.SetParameterValue("@RealName", entity.RealName); dc.SetParameterValue("@CreditCardNumber", entity.CreditCardNumber); dc.SetParameterValue("@CreditCardNumberEnc", entity.CreditCardNumberEnc); dc.SetParameterValue("@IDNumber", entity.IDNumber); dc.SetParameterValue("@ExpireDate", entity.ExpireDate); dc.SetParameterValue("@InUser", entity.InUser); dc.SetParameterValue("@EditUser", entity.EditUser); dc.ExecuteNonQuery(); return(entity); }
/// <summary> /// 更新 订单更近日志 /// </summary> /// <param name="entity"></param> /// <returns></returns> public void UpdateSOInternalMemoInfo(SOInternalMemoInfo info) { DataCommand command = DataCommandManager.GetDataCommand("UpdateSO_InternalMemo"); command.SetParameterValue("@SysNo", info.SysNo); command.SetParameterValue("@SOSysNo", info.SOSysNo); command.SetParameterValue("@Content", info.Content); command.SetParameterValue("@UpdateUserSysNo", info.OperatorSysNo);//处理人 command.SetParameterValue("@Status", info.Status); command.SetParameterValue("@UpdateTime", DateTime.Now); command.SetParameterValue("@RemindTime", info.RemindTime); if (info.Status == SOInternalMemoStatus.Complete) { command.SetParameterValue("@RemindTime", DBNull.Value); command.SetParameterValue("@UpdateTime", DBNull.Value); } command.SetParameterValue("@Note", info.Note); command.SetParameterValue("@CallType", info.CallType); command.SetParameterValue("@ResponsibleDepCode", info.DepartmentCode); command.SetParameterValue("@Importance", info.Importance); command.ExecuteNonQuery(); }
/// <summary> /// 创建佣金兑现申请 /// </summary> /// <param name="data"></param> public static int CreateRequestToCashRecord(CommissionToCashRecordEntity recordEntity) { //1.创建兑现申请单 //2.修改对应的佣金结算单信息【CommissionToCashRecordSysNo,Status】 //设置命令对象信息 DataCommand command = DataCommandManager.GetDataCommand("Settled.CreateRequestToCash"); command.SetParameterValue("@UserSysNo", recordEntity.UserSysNo); command.SetParameterValue("@Status", recordEntity.Status); command.SetParameterValue("@ToCashAmt", recordEntity.ToCashAmt); command.SetParameterValue("@AfterTaxAmt", recordEntity.AfterTaxAmt); command.SetParameterValue("@BankCode", recordEntity.BankCode); command.SetParameterValue("@BankName", recordEntity.BankName); command.SetParameterValue("@BranchBank", recordEntity.BranchBank); command.SetParameterValue("@BankCardNumber", recordEntity.BankCardNumber); command.SetParameterValue("@ReceivableName", recordEntity.ReceivableName); command.SetParameterValue("@IsHasInvoice", recordEntity.IsHasInvoice); command.SetParameterValue("@InUser", recordEntity.InUser); return(command.ExecuteScalar <int>()); }
/// <summary> /// 获取热门关键字的最大长度,根据已经存在的关键字 /// </summary> /// <param name="item"></param> /// <returns></returns> public bool GetHotKeywordsMaxLenthBySysNo(HotSearchKeyWords item) { DataCommand dc = DataCommandManager.GetDataCommand("Keywords_CheckKeywordMaxLenthBySysNo"); dc.SetParameterValue <HotSearchKeyWords>(item); DataTable dt = dc.ExecuteDataTable(); StringBuilder maxKeywords = new StringBuilder(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { maxKeywords.Append(dr[0].ToString()); } } maxKeywords.Append(item.Keywords.Content); if (maxKeywords.ToString().Length > 41) { return(false); } return(true); }
public VendorPresetContent GetVendorPresetContent() { var command = DataCommandManager.GetDataCommand("GetVendorPresetContent"); string configString = Convert.ToString(command.ExecuteScalar()); if (string.IsNullOrWhiteSpace(configString)) { return(null); } var data = SerializationUtility.XmlDeserialize <VendorPresetContent>(configString); data.StorePageInfos.ForEach(page => { var pageTemplate = GetStorePageTemplate(page.TemplateKey, page.PageTypeKey); if (pageTemplate != null) { page.DataValue = pageTemplate.DataValue; } }); return(data); }
public PagedList <UserModel> GetSourceUsers(int pageIndex, int pageSize) { var userList = new List <UserModel>(); var count = 0; using (var cmd = DataCommandManager.GetDataCommand("GetSourceUserByPageList")) { cmd.SetParameterValue("@PageIndex", pageIndex); cmd.SetParameterValue("@PageSize", pageSize); using (var ds = cmd.ExecuteDataSet()) { if (ds.Tables.Count >= 2) { foreach (DataRow dr in ds.Tables[0].Rows) { var user = new UserModel(); user.UserId = !Convert.IsDBNull(dr["ID"]) ? int.Parse(dr["ID"].ToString()) : 0; user.Mobile = !Convert.IsDBNull(dr["Mobile"]) ? dr["Mobile"].ToString() : string.Empty; user.WxOpenId = !Convert.IsDBNull(dr["WxOpenId"]) ? dr["WxOpenId"].ToString() : string.Empty; user.WxNickName = !Convert.IsDBNull(dr["WxNickName"]) ? dr["WxNickName"].ToString() : string.Empty; user.WxSex = !Convert.IsDBNull(dr["WxSex"]) ? int.Parse(dr["WxSex"].ToString()) : 0; user.WxHeadUrl = !Convert.IsDBNull(dr["WxHeadUrl"]) ? dr["WxHeadUrl"].ToString() : string.Empty; user.WxSubTime = !Convert.IsDBNull(dr["WxSubTime"]) ? Convert.ToDateTime(dr["WxSubTime"]) : DateTime.MinValue; user.WxUnionId = !Convert.IsDBNull(dr["WxUnionId"]) ? dr["WxUnionId"].ToString() : string.Empty; user.WxRemark = !Convert.IsDBNull(dr["WxRemark"]) ? dr["WxRemark"].ToString() : string.Empty; user.WxGroupId = !Convert.IsDBNull(dr["WxGroupId"]) ? int.Parse(dr["WxGroupId"].ToString()) : 0; user.Status = !Convert.IsDBNull(dr["Status"]) ? int.Parse(dr["Status"].ToString()) : 0; user.CreateTime = !Convert.IsDBNull(dr["CreateTime"]) ? Convert.ToDateTime(dr["CreateTime"]) : DateTime.MinValue; user.SourceCount = !Convert.IsDBNull(dr["SourceCount"]) ? int.Parse(dr["SourceCount"].ToString()) : 0; userList.Add(user); } var countDr = ds.Tables[1].Rows[0][0]; count = !Convert.IsDBNull(countDr) ? Convert.ToInt32(countDr) : 0; } } var result = new PagedList <UserModel>(userList, pageIndex, pageSize, count); return(result); } }
public int Update(ProductInfo model) { using (DataCommand cmd = DataCommandManager.GetDataCommand("UpdateProductById")) { cmd.SetParameterValue("@id", model.Id); cmd.SetParameterValue("@title", model.Title); cmd.SetParameterValue("@cid", model.CategoryId); cmd.SetParameterValue("@price", model.Price); cmd.SetParameterValue("@desc", model.Desc); cmd.SetParameterValue("@content", model.Content); cmd.SetParameterValue("@isonline", model.IsOnline); cmd.SetParameterValue("@bigpicture", model.BigPicture); cmd.SetParameterValue("@smallpicture", model.SmallPicture); cmd.SetParameterValue("@mediumpicture", model.MediumPicture); cmd.SetParameterValue("@specifications", model.Specifications); cmd.SetParameterValue("@afterservice", model.AfterService); cmd.SetParameterValue("@FileUrl", model.FileUrl); cmd.SetParameterValue("@Keywords", model.Keywords); cmd.SetParameterValue("@MetaDesc", model.MetaDesc); return(cmd.ExecuteNonQuery()); } }
public PayItemStatus?GetPOPrePayItemStatus(int poSysNo) { PayItemStatus status; var cmd = DataCommandManager.GetDataCommand("GetPOPrepay"); cmd.SetParameterValue("@PoSysNO", poSysNo); DataTable dt = cmd.ExecuteDataTable(); if (null != dt && dt.Rows.Count > 0) { if (!Enum.TryParse <PayItemStatus>(dt.Rows[0]["Status"].ToString(), out status)) { return(null); } return(status); } else { return(null); } }
/// <summary> /// 根据讨论论编号,加载相应的讨论回复 /// </summary> /// <param name="sysNo">The system no.</param> /// <returns></returns> public static List <ProductReviewReplyInfo> GetProductReviewReplyList(int sysNo) { DataCommand dataCommand = DataCommandManager.GetDataCommand("ProductReview_GetProductReviewReplyList"); dataCommand.SetParameterValue("@ReviewSysNo", sysNo); CodeNamePairColumnList pairList = new CodeNamePairColumnList(); pairList.Add("Status", "MKT", "ReplyStatus"); //评论状态 pairList.Add("Type", "MKT", "ReplySource"); //回复类型 DataTable dataTable = dataCommand.ExecuteDataTable(pairList); List <ProductReviewReplyInfo> list = new List <ProductReviewReplyInfo>(); foreach (DataRow row in dataTable.Rows) { list.Add(DataMapper.GetEntity <ProductReviewReplyInfo>(row)); } return(list); }
public static PurchaseOrderItemInfo UpdatePOItem(PurchaseOrderItemInfo entity) { DataCommand command = DataCommandManager.GetDataCommand("UpdatePOItem"); command.SetParameterValue("@SysNo", entity.ItemSysNo.Value); command.SetParameterValue("@POSysNo", entity.POSysNo); command.SetParameterValue("@ProductSysNo", entity.ProductSysNo); command.SetParameterValue("@BriefName", entity.BriefName); command.SetParameterValue("@Quantity", entity.Quantity); command.SetParameterValue("@Weight", entity.Weight); command.SetParameterValue("@OrderPrice", entity.OrderPrice); command.SetParameterValue("@ApportionAddOn", entity.ApportionAddOn); command.SetParameterValue("@UnitCost", entity.UnitCost); command.SetParameterValue("@ReturnCost", entity.ReturnCost); command.SetParameterValue("@PurchaseQty", entity.PurchaseQty.Value); command.SetParameterValue("@CurrencySysNo", entity.CurrencyCode); command.SetParameterValue("@ExecptStatus", entity.ExecptStatus); command.SetParameterValue("@UnitCostWithoutTax", entity.UnitCostWithoutTax); command.SetParameterValue("@AvailableQty", entity.AvailableQty); command.SetParameterValue("@m1", entity.M1); command.SetParameterValue("@CurrentUnitCost", entity.UnitCost); command.SetParameterValue("@CurrentPrice", entity.OrderPrice); command.SetParameterValue("@LastAdjustPriceDate", entity.LastAdjustPriceDate); command.SetParameterValue("@LastInTime", entity.LastInTime); command.SetParameterValue("@lastOrderPrice", entity.LastOrderPrice); if (command.ExecuteNonQuery() <= 0) { return(null); } return(entity); }
public int Insert(User user) { using (DataCommand cmd = DataCommandManager.GetDataCommand("InsertUser")) { cmd.SetParameterValue("@UserId", user.UserId); cmd.SetParameterValue("@NickName", user.NickName); cmd.SetParameterValue("@Name", user.Name); cmd.SetParameterValue("@Password", user.Password); cmd.SetParameterValue("@Sex", user.Sex); cmd.SetParameterValue("@Cellphone", user.Cellphone); cmd.SetParameterValue("@Telephone", user.Telephone); cmd.SetParameterValue("@Email", user.Email); cmd.SetParameterValue("@Activity", user.Activity); cmd.SetParameterValue("@Address", user.Address); cmd.SetParameterValue("@QQ", user.QQ); cmd.SetParameterValue("@Fax", user.Fax); cmd.SetParameterValue("@Postcode", user.Postcode); cmd.SetParameterValue("@InUserId", user.InUserId); cmd.SetParameterValue("@InDate", user.InDate); cmd.SetParameterValue("@EditUserId", user.EditUserId); cmd.SetParameterValue("@EditDate", user.EditDate); cmd.SetParameterValue("@Enabled", user.Enabled); cmd.SetParameterValue("@FirstVisit", user.FirstVisit); cmd.SetParameterValue("@PreviousVisit", user.PreviousVisit); cmd.SetParameterValue("@LastVisit", user.LastVisit); cmd.SetParameterValue("@Question", user.Question); cmd.SetParameterValue("@Answer", user.Answer); int result = cmd.ExecuteNonQuery(); if (result > 0) { return(user.UserId); } return(result); // if (result != null) // return Convert.ToInt32(result); //return -1; } }
public DataTable QueryRmaPolicy(RmaPolicyQueryFilter query, out int totalCount) { DataCommand cmd = DataCommandManager.GetDataCommand("QueryRmaPolicy"); cmd.SetParameterValue("@RmaStatus", query.Status); cmd.SetParameterValue("@RmaType", query.Type); cmd.SetParameterValue("@CreateUserName", query.CreateUserName); cmd.SetParameterValue("@SysNo", query.SysNo); cmd.SetParameterValue("@pageIndex", query.PagingInfo.PageIndex); cmd.SetParameterValue("@pageSize", query.PagingInfo.PageSize); cmd.SetParameterValue("@sortField", query.PagingInfo.SortBy); EnumColumnList enumList = new EnumColumnList { { "Status", typeof(RmaPolicyStatus) }, { "Type", typeof(RmaPolicyType) }, { "IsOnlineRequst", typeof(IsOnlineRequst) }, }; DataTable dt = new DataTable(); dt = cmd.ExecuteDataTable(enumList); totalCount = (int)cmd.GetParameterValue("@totalCount"); return(dt); }
public CostChangeInfo CreateCostChange(CostChangeInfo costChangeInfo) { DataCommand command = DataCommandManager.GetDataCommand("CreateCostChange"); command.SetParameterValue("@VendorSysNo", costChangeInfo.CostChangeBasicInfo.VendorSysNo); command.SetParameterValue("@PMSysNo", costChangeInfo.CostChangeBasicInfo.PMSysNo); command.SetParameterValue("@Status", (int)costChangeInfo.CostChangeBasicInfo.Status); command.SetParameterValue("@Memo", costChangeInfo.CostChangeBasicInfo.Memo); command.SetParameterValue("@InUser", costChangeInfo.CostChangeBasicInfo.InUser); command.SetParameterValue("@TotalDiffAmt", costChangeInfo.CostChangeBasicInfo.TotalDiffAmt); command.SetParameterValue("@CompanyCode", "8601"); costChangeInfo.SysNo = Convert.ToInt32(command.ExecuteScalar()); if (costChangeInfo.CostChangeItems != null && costChangeInfo.CostChangeItems.Count > 0) { foreach (CostChangeItemsInfo item in costChangeInfo.CostChangeItems) { CreateCostChangeItemInfo(item, costChangeInfo.SysNo.Value); } } return(costChangeInfo); }
public static void CreateRefundBankInfo(SOIncomeRefundInfo refundInfo) { DataCommand command = DataCommandManager.GetDataCommand("CreateRMARefundBankInfo"); command.SetParameterValue("@OrderType", refundInfo.OrderType); command.SetParameterValue("@OrderSysNo", refundInfo.OrderSysNo); command.SetParameterValue("@SOSysNo", refundInfo.SOSysNo); command.SetParameterValue("@BankName", refundInfo.BankName); command.SetParameterValue("@CardNumber", refundInfo.CardNumber); command.SetParameterValue("@CardOwnerName", refundInfo.CardOwnerName); command.SetParameterValue("@RefundPayType", refundInfo.RefundPayType); command.SetParameterValue("@CreateUserSysNo", refundInfo.CreateUserSysNo); command.SetParameterValue("@CreateUserName", refundInfo.CreateUserName); command.SetParameterValue("@Status", refundInfo.Status); command.SetParameterValue("@HaveAutoRMA", refundInfo.HaveAutoRMA == true ? 1 : 0); command.SetParameterValue("@RefundCashAmt", refundInfo.RefundCashAmt); command.SetParameterValue("@RefundPoint", refundInfo.RefundPoint); command.SetParameterValue("@RefundGiftCard", refundInfo.RefundGiftCard); command.SetParameterValue("@CompanyCode", refundInfo.CompanyCode); command.SetParameterValue("@LanguageCode", refundInfo.LanguageCode); command.SetParameterValue("@StoreCompanyCode", refundInfo.CompanyCode); command.ExecuteNonQuery(); }