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