public void CreateCustomerExt(int customerSysNo) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist"); cmd.CreateCommand("CreateCustomerExt"); //DataCommand cmd = new DataCommand("CreateCustomerExt"); cmd.SetParameter("@CustomerSysNo", DbType.Int32, customerSysNo); cmd.ExecuteNonQuery(); }
/// <summary> /// 删除Authentication信息 /// </summary> public void DeleteAuthentication(int sysNo) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist"); cmd.CreateCommand("DeleteAuthentication"); //DataCommand cmd = new DataCommand("DeleteAuthentication"); cmd.SetParameter("@SysNo", DbType.Int32, sysNo); cmd.ExecuteNonQuery(); }
/// <summary> /// 更新Authentication信息 /// </summary> public void UpdateAuthentication(Authentication entity) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist"); cmd.CreateCommand("UpdateAuthentication"); //DataCommand cmd = new DataCommand("UpdateAuthentication"); cmd.SetParameter <Authentication>(entity); cmd.ExecuteNonQuery(); }
/// <summary> /// 删除RMAItem信息 /// </summary> public void DeleteRMAItemByRMASysNo(int rmaSysNo) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("DeleteRMAItemByRMASysNo"); // DataCommand cmd = new DataCommand("DeleteRMAItemByRMASysNo"); cmd.SetParameter("@SysNo", DbType.Int32, rmaSysNo); cmd.ExecuteNonQuery(); }
/// <summary> /// 更新RMAItem信息 /// </summary> public void UpdateRMAItem(RMAItem entity) { IDataCommand dataCommand = IocManager.Instance.Resolve <IDataCommand>(); dataCommand.CreateCommand("UpdateRMAItem"); //DataCommand cmd = new DataCommand("UpdateRMAItem"); dataCommand.SetParameter <RMAItem>(entity); dataCommand.ExecuteNonQuery(); }
/// <summary> /// 更新RMAMaster信息 /// </summary> public static void UpdateRMAMaster(RMAMaster entity) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("UpdateRMAMaster"); //DataCommand cmd = new DataCommand("UpdateRMAMaster"); cmd.SetParameter <RMAMaster>(entity); cmd.ExecuteNonQuery(); }
public void InsertNewSMS(SMSInfo item) { IDataCommand datacommand = IocManager.Instance.Resolve <IDataCommand>(); datacommand.CreateCommand("CustomerInsertNewSMS"); //DataCommand datacommand = new DataCommand("CustomerInsertNewSMS"); datacommand.SetParameter <SMSInfo>(item); datacommand.ExecuteNonQuery(); }
/// <summary> /// 更新Topic信息 /// </summary> public void UpdateTopic(Topic entity) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("UpdateTopic"); //DataCommand cmd = new DataCommand("UpdateTopic"); cmd.SetParameter <Topic>(entity); cmd.ExecuteNonQuery(); }
public void UpdateCellPhoneConfirmTempStatusExpired(string tel) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("UpdateCellPhoneConfirmTempStatusExpired"); //DataCommand cmd = new DataCommand("UpdateCellPhoneConfirmTempStatusExpired"); cmd.SetParameter("@tel", DbType.String, tel); cmd.ExecuteNonQuery(); }
public void CreatePushMessage(PushMessage msg) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("CreatePushMessage"); //DataCommand cmd = new DataCommand("CreatePushMessage"); cmd.SetParameter <PushMessage>(msg); cmd.ExecuteNonQuery(); }
/// <summary> /// 删除ShippingAddress信息 /// </summary> public void DeleteShippingAddress(int sysNo) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("DeleteShippingAddress"); //DataCommand cmd = new DataCommand("DeleteShippingAddress"); cmd.SetParameter("@SysNo", DbType.Int32, sysNo); cmd.ExecuteNonQuery(); }
/// <summary> /// 创建CustomerMapping信息 /// </summary> public void InsertCustomerMapping(CustomerMapping entity) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist"); cmd.CreateCommand("InsertCustomerMapping"); //DataCommand cmd = new DataCommand("InsertCustomerMapping"); cmd.SetParameter <CustomerMapping>(entity); cmd.ExecuteNonQuery(); }
public void CreateRechargeRequest(RechargeRequest request) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist"); cmd.CreateCommand("InsertRechargeRequest"); //DataCommand cmd = new DataCommand("InsertRechargeRequest"); cmd.SetParameter <RechargeRequest>(request); int result = cmd.ExecuteNonQuery(); }
/// <summary> /// 删除PromotionProduct信息 /// </summary> public static void DeletePromotionProduct(int sysNo) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("DeletePromotionProduct"); //DataCommand cmd = new DataCommand("DeletePromotionProduct"); cmd.SetParameter("@SysNo", DbType.Int32, sysNo); cmd.ExecuteNonQuery(); }
public void UpdateRMACompleteStatus(int rmaSysNo) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("Order_UpdateRMACompleteStatus"); //DataCommand cmd = new DataCommand("Order_UpdateRMACompleteStatus"); cmd.SetParameter("@SysNo", DbType.Int32, rmaSysNo); cmd.ExecuteNonQuery(); }
public static void UpdateRecharge(RechargeRequest rechargedetail) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("UpdateRecharge"); //DataCommand cmd = new DataCommand("UpdateRecharge"); cmd.SetParameter <RechargeRequest>(rechargedetail); cmd.ExecuteNonQuery(); }
/// <summary> /// 充值增加账户余额 /// </summary> public void UpdateCustomerBalance(int CustomerSysNo, decimal BalancePayAmount) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist"); cmd.CreateCommand("UpdateCustomerBalance"); //DataCommand cmd = new DataCommand("UpdateCustomerBalance"); cmd.SetParameter("@CustomerSysNo", DbType.Int32, CustomerSysNo); cmd.SetParameter("@Balance", DbType.Decimal, BalancePayAmount); cmd.ExecuteNonQuery(); }
/// <summary> /// 作废订单调整顾客账户余额 /// </summary> /// <param name="soSysNo"></param> public void AbandonOrderAdjustCustomerAccount(int soSysNo) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("AbandonOrderAdjustCustomerAccount"); //DataCommand cmd = new DataCommand("AbandonOrderAdjustCustomerAccount"); cmd.SetParameter("@SOSysNo", DbType.Int32, soSysNo); cmd.ExecuteNonQuery(); }
/// <summary> /// 更新ShippingAddress信息 /// </summary> public void UpdateShippingAddress(ShippingAddress entity) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("UpdateShippingAddress"); //DataCommand cmd = new DataCommand("UpdateShippingAddress"); cmd.SetParameter <ShippingAddress>(entity); cmd.ExecuteNonQuery(); }
public static void SaveCustomerSetting(Model.CustomerSetting customerSetting) { IDataCommand dataCommand = DataCommandManager.GetCommand("Customer_SaveCustomerSetting"); dataCommand.SetParameter("@CustomerSysNo", customerSetting.CustomerSysNo); dataCommand.SetParameter("@Setting", customerSetting.Setting); dataCommand.ExecuteNonQuery(); customerSetting.SysNo = Convert.ToInt32(dataCommand.Parameters["@SysNo"].Value); }
/// <summary> /// 更新CustomerInfo信息 /// </summary> public void UpdateCustomerInfo(CustomerInfo entity) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist"); cmd.CreateCommand("UpdateCustomerInfo"); //DataCommand cmd = new DataCommand("UpdateCustomerInfo"); cmd.SetParameter <CustomerInfo>(entity); cmd.ExecuteNonQuery(); }
/// <summary> /// 更新PromotionProduct信息 /// </summary> public static void UpdatePromotionProduct(PromotionProduct entity) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("UpdatePromotionProduct"); //DataCommand cmd = new DataCommand("UpdatePromotionProduct"); cmd.SetParameter <PromotionProduct>(entity); cmd.ExecuteNonQuery(); }
public void AbandonSOAdjustProductInventory(int soSysNo) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("AbandonSOAdjustProductInventory"); //DataCommand cmd = new DataCommand("AbandonSOAdjustProductInventory"); cmd.SetParameter("@SOSysNo", DbType.Int32, soSysNo); cmd.ExecuteNonQuery(); }
/// <summary> /// 确认消费记录 /// </summary> public static void Confirmconsum(int sysno, int score) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("Confirmconsum"); //DataCommand cmd = new DataCommand("Confirmconsum"); cmd.SetParameter("@SysNo", DbType.Int32, sysno); cmd.SetParameter("@Rate", DbType.Int32, score); cmd.ExecuteNonQuery(); }
public void AbandonOrderAdjustCountDownProductInventory(int soSysNo) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("AbandonOrderAdjustCountDownProductInventory"); //DataCommand cmd = new DataCommand("AbandonOrderAdjustCountDownProductInventory"); cmd.SetParameter("@SOSysNo", DbType.Int32, soSysNo); cmd.SetParameter("@PromotionType", DbType.Int32, (int)PromotionType.Countdown); cmd.ExecuteNonQuery(); }
/// <summary> /// 删除FavoriteProduct信息 /// </summary> public void DeleteFavoriteProduct(int usersysno, int productsysno) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("DeleteFavoriteProduct"); //DataCommand cmd = new DataCommand("DeleteFavoriteProduct"); cmd.SetParameter("@ProductSysNo", DbType.Int32, productsysno); cmd.SetParameter("@CustomerSysNo", DbType.Int32, usersysno); cmd.ExecuteNonQuery(); }
//注册送积分 public void UpdateCustomerPoint(int SysNo, int point) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist"); cmd.CreateCommand("UpdateCustomerPoint"); //DataCommand cmd = new DataCommand("UpdateCustomerPoint"); cmd.SetParameter("@SysNo", DbType.Int32, SysNo); cmd.SetParameter("@point", DbType.Int32, point); cmd.ExecuteNonQuery(); }
public static void UpdateRetrieveTaskStatus(Model.RetrieveTask retrieveTask) { IDataCommand dataCommand = DataCommandManager.GetCommand("Task_UpdateRetrieveTaskStatus"); dataCommand.SetParameter("@TaskSysNo", retrieveTask.RunTaskSysNo); dataCommand.SetParameter("@RetrieveTask", retrieveTask.SysNo); dataCommand.SetParameter("@Status", retrieveTask.Status); dataCommand.SetParameter("@Description", retrieveTask.Description); dataCommand.ExecuteNonQuery(); }
public void WriteLog(OperationLog log) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist"); cmd.CreateCommand("ControlPanel_InsertOperationLog"); // DataCommand cmd = new DataCommand("ControlPanel_InsertOperationLog"); cmd.CommandText = cmd.CommandText.Replace("#BizObjectName#", cmd.SetSafeParameter(log.BizObjectType)); cmd.SetParameter <OperationLog>(log); cmd.ExecuteNonQuery(); }
public void UpdateCellPhoneConfirmTempStatus(CellPhoneConfirmTemp item) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist"); cmd.CreateCommand("UpdateCellPhoneConfirmTempStatus"); //DataCommand cmd = new DataCommand("UpdateCellPhoneConfirmTempStatus"); cmd.SetParameter("@SysNo", DbType.Int32, item.SysNo); cmd.SetParameter("@Status", DbType.Int32, item.Status); cmd.ExecuteNonQuery(); }
private void ExecuteGalleryCmd(IDataCommand cmd, Gallery gallery) { cmd.Parameters["applicationName"].Value = this.ApplicationName; cmd.Parameters["id"].Value = gallery.ID; cmd.Parameters["author"].Value = gallery.Author; if (!string.IsNullOrEmpty(gallery.Content)) cmd.Parameters["content"].Value = gallery.Content; cmd.Parameters["dateCreated"].Value = gallery.DateCreated; if (!string.IsNullOrEmpty(gallery.Description)) cmd.Parameters["description"].Value = gallery.Description; cmd.Parameters["isVisible"].Value = gallery.IsVisible; if (!string.IsNullOrEmpty(gallery.Keywords)) cmd.Parameters["keywords"].Value = gallery.Keywords; if (gallery.LastUpdated.HasValue && gallery.LastUpdated != DateTime.MinValue) cmd.Parameters["lastUpdated"].Value = gallery.LastUpdated; if (!string.IsNullOrEmpty(gallery.LastUpdatedBy)) cmd.Parameters["lastUpdatedBy"].Value = gallery.LastUpdatedBy; if (!string.IsNullOrEmpty(gallery.Slug)) cmd.Parameters["slug"].Value = gallery.Slug; cmd.Parameters["title"].Value = gallery.Title; cmd.Parameters["status"].Value = gallery.Status.ToString(); int affectedRows = cmd.ExecuteNonQuery(); }