/// <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);
}
public static QueryResult <QR_Consum> QueryCustomerConsumList(QF_Consum filter)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("QueryCustomerConsumList");
//DataCommand cmd = new DataCommand("QueryCustomerConsumList");
cmd.QuerySetCondition("ND.NursingStatus", ConditionOperation.NotIn, DbType.Int32, "0");
cmd.QuerySetCondition("CustomerSysNo", ConditionOperation.Equal, DbType.Int32, filter.CustomerSysNo);
QueryResult <QR_Consum> result = cmd.Query <QR_Consum>(filter, " ND.SysNo DESC");
return(result);
}
public static QueryResult <QR_Recharge> QueryCustomerRechargeList(QF_Recharge filter)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("QueryCustomerRechargeList");
//DataCommand cmd = new DataCommand("QueryCustomerRechargeList");
cmd.QuerySetCondition("CustomerSysNo", ConditionOperation.Equal, DbType.Int32, filter.CustomerSysNo);
cmd.QuerySetCondition("RechargeStatus", ConditionOperation.NotEqual, DbType.Int32, -2);
QueryResult <QR_Recharge> result = cmd.Query <QR_Recharge>(filter, " SysNo DESC");
return(result);
}
/// <summary>
/// 分页查询Topic信息
/// </summary>
public QueryResult <QR_Topic> QueryTopicList(QF_Topic filter)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("QueryTopicList");
//DataCommand cmd = new DataCommand("QueryTopicList");
cmd.QuerySetCondition("TopicCategorySysNo", ConditionOperation.Equal, DbType.Int32, filter.TopicCategorySysNo);
cmd.QuerySetCondition("TopicStatus", ConditionOperation.Equal, DbType.Int32, 1);
cmd.QuerySetCondition("StartTime", ConditionOperation.LessThanEqual, DbType.DateTime, DateTime.Now);
cmd.QuerySetCondition("EndTime", ConditionOperation.MoreThanEqual, DbType.DateTime, DateTime.Now);
QueryResult <QR_Topic> result = cmd.Query <QR_Topic>(filter, " SysNo DESC");
return(result);
}
/// <summary>
/// 分页查询RMAMaster信息
/// </summary>
public static QueryResult <QR_RMAMaster> QueryRMAMasterList(QF_RMAMaster filter)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("QueryRMAMasterList");
//DataCommand cmd = new DataCommand("QueryRMAMasterList");
cmd.QuerySetCondition("SOSysNo", ConditionOperation.Equal, DbType.Int32, filter.SOSysNo);
cmd.QuerySetCondition("CustomerSysNo", ConditionOperation.Equal, DbType.Int32, filter.CustomerSysNo);
QueryResult <QR_RMAMaster> result = cmd.Query <QR_RMAMaster>(filter, " SysNo DESC");
return(result);
}
/// <summary>
/// 分页查询ShippingAddress信息
/// </summary>
public QueryResult <QR_ShippingAddress> QueryShippingAddressList(QF_ShippingAddress filter)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("QueryShippingAddressList");
//DataCommand cmd = new DataCommand("QueryShippingAddressList");
cmd.QuerySetCondition("CustomerSysNo", ConditionOperation.Equal, DbType.Int32, filter.CustomerSysNo);
cmd.QuerySetCondition("IsDefault", ConditionOperation.Equal, DbType.Int32, filter.IsDefault);
QueryResult <QR_ShippingAddress> result = cmd.Query <QR_ShippingAddress>(filter, " 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 <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>
/// 预约列表
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public static QueryResult <QR_ReservationRecords> GetCustomerReservationRecords(QF_ReservationRecords filter)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("QueryCustomerReservationRecords");
//DataCommand cmd = new DataCommand("QueryCustomerReservationRecords");
cmd.QuerySetCondition("CustomerSysNo", ConditionOperation.Equal, DbType.Int32, filter.CustomerSysNo);
QueryResult <QR_ReservationRecords> result = cmd.Query <QR_ReservationRecords>(filter, " SysNo DESC");
return(result);
}
/// <summary>
/// 分页查询FavoriteProduct信息
/// </summary>
public QueryResult <FavoriteProduct> QueryFavoriteProductList(QF_FavoriteProduct filter)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("QueryFavoriteProductList");
//DataCommand cmd = new DataCommand("QueryFavoriteProductList");
cmd.QuerySetCondition("CustomerSysNo", ConditionOperation.Equal, DbType.Int32, filter.CustomerSysNo);
QueryResult <FavoriteProduct> result = cmd.Query <FavoriteProduct>(filter, "F.InDate DESC");
return(result);
}
public QueryResult <CouponReceivingRecord> QueryCouponReceivingRecordList(QF_CouponReceivingRecord filter)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("QueryCouponReceivingRecordList");
//DataCommand cmd = new DataCommand("QueryCouponReceivingRecordList");
cmd.QuerySetCondition("UserSysNo", ConditionOperation.Like, DbType.Int32, filter.CustomerSysNo);
QueryResult <CouponReceivingRecord> result = cmd.Query <CouponReceivingRecord>(filter, "ReceivingDate DESC");
return(result);
}
public QueryResult <SOMaster> QueryOrderList(QF_SO filter)
{
IDataCommand cmd = IocManager.Instance.Resolve <IDataCommand>();
cmd.CreateCommand("QueryOrderList");
//DataCommand cmd = new DataCommand("QueryOrderList");
cmd.QuerySetCondition("CustomerSysNo", ConditionOperation.Equal, DbType.Int32, filter.CustomerSysNo);
if (filter.SOStatus.HasValue && filter.SOStatus.Value == 101)
{
cmd.QuerySetCondition("and exists(select 1 from [ECCenter].[dbo].SOItem as si with (nolock) left join [ECCenter].[dbo].[ProductComment] as pc with (nolock) on si.ProductSysNo=pc.ProductSysNo and si.SOSysNo=pc.SOSysNo where si.SOSysNo=[ECCenter].[dbo].[SOMaster].SysNo and pc.SysNo is null )");
cmd.QuerySetCondition("SOStatus", ConditionOperation.Equal, DbType.Int32, 100);
cmd.QuerySetCondition("and DATEDIFF(M, SODATE ,GETDATE())<=1");
}
else
{
cmd.QuerySetCondition("SOStatus", ConditionOperation.Equal, DbType.Int32, filter.SOStatus);
}
QueryResult <SOMaster> result = cmd.Query <SOMaster>(filter, " SODate DESC");
return(result);
}
