/// <summary> /// 分页查询ProductComment信息 /// </summary> public QueryResult <QR_ProductComment> QueryProductCommentList(QF_ProductComment filter) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("QueryProductCommentList"); //DataCommand cmd = new DataCommand("QueryProductCommentList"); cmd.QuerySetCondition("pc.ProductSysNo", ConditionOperation.Equal, DbType.Int32, filter.ProductSysNo); cmd.QuerySetCondition("pc.CommonStatus", ConditionOperation.Equal, DbType.Int32, 1); if (filter.Condition == 1) { cmd.QuerySetCondition("pc.Rate", ConditionOperation.MoreThan, DbType.Int32, 1); } if (filter.Condition == 2) { cmd.QuerySetCondition("pc.Rate", ConditionOperation.LessThanEqual, DbType.Int32, 1); } if (filter.Condition == 3) { cmd.QuerySetCondition("pc.HasPic", ConditionOperation.Equal, DbType.Int32, 1); } QueryResult <QR_ProductComment> result = cmd.Query <QR_ProductComment>(filter, " pc.SysNo DESC"); return(result); }
/// <summary> /// 分页查询Area /// </summary> /// <param name="filter"></param> /// <returns></returns> public QueryResult <QR_Area> QueryAreaList(QF_Area filter) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("QueryAreaList"); //DataCommand cmd = new DataCommand("QueryAreaList"); cmd.QuerySetCondition("Status", ConditionOperation.NotEqual, DbType.Int32, -999); if (filter.ProvinceSysNo.HasValue) { cmd.QuerySetCondition("ProvinceSysNo", ConditionOperation.Equal, DbType.Int32, filter.ProvinceSysNo); } else { cmd.QuerySetCondition("and ProvinceSysNo is null"); } if (filter.CitySysNo.HasValue) { cmd.QuerySetCondition("CitySysNo", ConditionOperation.Equal, DbType.String, filter.CitySysNo); } else { cmd.QuerySetCondition("and CitySysNo is null"); } cmd.QuerySetCondition("SysNo", ConditionOperation.Equal, DbType.String, filter.SysNo); cmd.QuerySetCondition("Status", ConditionOperation.Equal, DbType.Int32, filter.Status); QueryResult <QR_Area> result = cmd.Query <QR_Area>(filter, "OrderNumber ASC"); return(result); }
public List <SODiscountMaster> GetSODiscountBySOSysNo(int sosysno) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("GetSODiscountBySOSysNo"); //DataCommand cmd = new DataCommand("GetSODiscountBySOSysNo"); cmd.SetParameter("@SOSysNo", DbType.Int32, sosysno); DataSet ds = cmd.ExecuteDataSet(); List <SODiscountMaster> dmList = null; if (ds != null && ds.Tables.Count > 1) { dmList = DataMapperHelper.GetEntityList <SODiscountMaster, List <SODiscountMaster> >(ds.Tables[0].Rows); if (dmList != null && dmList.Count > 0) { List <SODiscountDetail> ddList = DataMapperHelper.GetEntityList <SODiscountDetail, List <SODiscountDetail> >(ds.Tables[1].Rows); foreach (var dm in dmList) { dm.Details = ddList.FindAll(dd => dd.MasterSysNo == dm.SysNo); } } } return(dmList); }
/// <summary> /// 分页查询Area /// </summary> /// <param name="filter"></param> /// <returns></returns> public List <QR_Saler> GetSalerList() { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("GetSalerList"); //DataCommand cmd = new DataCommand("GetSalerList"); return(cmd.ExecuteEntityList <QR_Saler>()); }
public ActionResult <string> Get(int id) { IocManager.Instance.Resolve <CookieHelper>().SaveCookie("cookieName", "123"); //IDataCommand command = IocManager.Instance.Resolve<IDataCommand>(); cmd.CreateCommand("GetAllChannelList"); var list = cmd.ExecuteEntityList <Channel>(); return("value"); }
public int GenerateRechargeSysNo() { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); //new DataCommand("CustomerCheckTelIsExist"); cmd.CreateCommand("GenerateRechargeSysNo"); //DataCommand cmd = new DataCommand("GenerateRechargeSysNo"); return(cmd.ExecuteScalar <int>()); }
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(); }
public static List <ProductCategory> LoadTopCategories() { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("LoadTopCategories"); //var cmd = new DataCommand("LoadTopCategories"); return(cmd.ExecuteEntityList <ProductCategory>()); }
public List <SOItem> GetSOItemBySOSysNo(int sosysno) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("GetSOItemBySOSysNo"); //DataCommand cmd = new DataCommand("GetSOItemBySOSysNo"); cmd.SetParameter("@SOSysNo", DbType.Int32, sosysno); return(cmd.ExecuteEntityList <SOItem>()); }
/// <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(); }
/// <summary> /// 获取单个ProductPrice信息 /// </summary> public ProductPrice LoadProductPrice(int sysNo) { IDataCommand cmd = IocManager.Instance.Resolve<IDataCommand>(); cmd.CreateCommand("LoadProductPrice"); //DataCommand cmd = new DataCommand("LoadProductPrice"); cmd.SetParameter("@SysNo", DbType.Int32, sysNo); ProductPrice result = cmd.ExecuteEntity<ProductPrice>(); return result; }
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> /// <param name="TradeNumber">流水号</param> /// <returns></returns> public int GetSOSysNoByTradeNumber(string TradeNumber) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("GetSOSysNoByTradeNumber"); //DataCommand cmd = new DataCommand("GetSOSysNoByTradeNumber"); cmd.SetParameter("@BankTrackingNumber", DbType.String, TradeNumber); return(cmd.ExecuteScalar <int>()); }
public List <SOStatistics> GetSOStatistics(int customersysno) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("GetSOStatistics"); //DataCommand cmd = new DataCommand("GetSOStatistics"); cmd.SetParameter("@CustomerSysNo", DbType.Int32, customersysno); return(cmd.ExecuteEntityList <SOStatistics>()); }
/// <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> /// 更新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(); }
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> /// 预约商品列表 /// </summary> /// <param name="filter"></param> /// <returns></returns> public static List <GetReservationProduct> GetReservationProduct(int customerSysNo) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("GetReservationProduct"); //DataCommand cmd = new DataCommand("GetReservationProduct"); cmd.SetParameter("@CustomerSysNo", DbType.Int32, customerSysNo); return(cmd.ExecuteEntityList <GetReservationProduct>()); }
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(); }
public QR_ProductCommentStatistics QueryProductCommentStatistics(int productSysNo) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("QueryProductCommentStatistics"); //var cmd = new DataCommand("QueryProductCommentStatistics"); cmd.SetParameter("ProductSysNo", DbType.Int32, productSysNo); return(cmd.ExecuteEntity <QR_ProductCommentStatistics>()); }
/// <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> /// 创建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(); }
/// <summary> /// 获取商品所有属性值信息 /// </summary> public List <ProductProperty> LoadProductProperty(int ProductCommonSysNo) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("LoadProductProperty"); //DataCommand cmd = new DataCommand("LoadProductProperty"); cmd.CommandText = cmd.CommandText.Replace("#ProductCommonSysNo#", cmd.SetSafeParameter(ProductCommonSysNo.ToString())); return(cmd.ExecuteEntityList <ProductProperty>()); }
public SORefund GetSORefund(int sysNo) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("Order_GetSORefund"); //DataCommand cmd = new DataCommand("Order_GetSORefund"); cmd.SetParameter("@SysNo", DbType.Int32, sysNo); return(cmd.ExecuteEntity <SORefund>()); }
public static List <ProductCategory> LoadCategoriesByParentCategoryCode(string parentCategoryCode) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("LoadCategoriesByParentCategoryCode"); //var cmd = new DataCommand("LoadCategoriesByParentCategoryCode"); cmd.SetParameter("@ParentCategoryCode", DbType.String, parentCategoryCode); return(cmd.ExecuteEntityList <ProductCategory>()); }
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 List<ProductPrice> LoadProductPrice(IEnumerable<int> productSysNoList) { IDataCommand cmd = IocManager.Instance.Resolve<IDataCommand>(); cmd.CreateCommand("ProductPrice_GetByProdcutSysNos"); if (productSysNoList == null || productSysNoList.Count() == 0) return null; //DataCommand cmd = new DataCommand("ProductPrice_GetByProdcutSysNos"); cmd.CommandText = cmd.CommandText.Replace("#ProductSysNos#", cmd.SetSafeParameter(string.Join(",", productSysNoList))); return cmd.ExecuteEntityList<ProductPrice>(); }
public List <SOItem> GetSOItemProducts(List <int> sosysnos) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("GetSOItemProducts"); //DataCommand cmd = new DataCommand("GetSOItemProducts"); cmd.QuerySetCondition("si.SOSysNo", ConditionOperation.In, DbType.Int32, sosysnos); return(cmd.ExecuteEntityList <SOItem>("#DynamicParameters#")); }
/// <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 SOMaster GetSOMaster(int sosysno) { IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>(); cmd.CreateCommand("GetSOMaster"); //DataCommand cmd = new DataCommand("GetSOMaster"); cmd.SetParameter("@SysNo", DbType.Int32, sosysno); return(cmd.ExecuteEntity <SOMaster>()); }