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