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