/// <summary> /// 根据类型得到分页的日志数据 /// </summary> /// <param name="page"></param> /// <param name="pagesize"></param> /// <param name="type"></param> /// <param name="totalcount"></param> /// <returns></returns> public static List <AmountChangeLogModel> GetAmountChangeLogByTypeForPage(int pageindex, int pagesize, int type, int memberid, out int totalrowcount) { List <AmountChangeLogModel> list = new List <AmountChangeLogModel>(); string columms = @"ID ,MemberID ,MemberPhone ,MemberName ,ProduceMoney ,Remark ,AddTime ,OrderID ,[Type] ,OrderCode"; string where = ""; if (type > 0) { where += " [Type]=" + type.ToString(); } if (memberid > 0) { where += " [MemberID]=" + memberid.ToString(); } PageProModel page = new PageProModel(); page.colums = columms; page.orderby = "AddTime"; page.pageindex = pageindex; page.pagesize = pagesize; page.tablename = @"dbo.AmountChangeLog"; page.where = where; DataTable dt = PublicHelperDAL.GetTable(page, out totalrowcount); foreach (DataRow item in dt.Rows) { AmountChangeLogModel model = new AmountChangeLogModel(); if (item["ID"].ToString() != "") { model.ID = int.Parse(item["ID"].ToString()); } if (item["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(item["AddTime"].ToString()); } if (item["MemberID"].ToString() != "") { model.MemberID = int.Parse(item["MemberID"].ToString()); } model.MemberPhone = item["MemberPhone"].ToString(); if (item["ProduceMoney"].ToString() != "") { model.ProduceMoney = decimal.Parse(item["ProduceMoney"].ToString()); } model.MemberName = item["MemberName"].ToString(); if (item["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(item["AddTime"].ToString()); } model.Remark = item["Remark"].ToString(); if (item["OrderID"].ToString() != "") { model.OrderID = int.Parse(item["OrderID"].ToString()); } model.OrderCode = item["OrderCode"].ToString(); model.Type = int.Parse(item["Type"].ToString()); list.Add(model); } return(list); }
/// <summary> /// 得到会员的分类激活码信息 /// </summary> /// <param name="model"></param> /// <param name="totalrowcount"></param> /// <returns></returns> public List <MemberActiveCodeModel> GetMemberActiveCodeListForPage(int memberid, int typeid, int pageindex, int pagesize, out int totalrowcount) { List <MemberActiveCodeModel> list = new List <MemberActiveCodeModel>(); string columms = @"ID,ActiveCode,AMType,MemberID,MemberPhone,MemberName,AMStatus,Addtime,UseCode,UserTime,CASE AMStatus WHEN 1 THEN '未使用' WHEN 2 THEN '已使用' WHEN 3 THEN '已过期' END AS AMStatusName"; string where = ""; if (memberid > 0) { where = " MemberID=" + memberid.ToString() + " AND AMType=" + typeid.ToString(); } PageProModel page = new PageProModel(); page.colums = columms; page.orderby = "Addtime"; page.pageindex = pageindex; page.pagesize = pagesize; page.tablename = @"dbo.MemberActiveCode"; page.where = where; DataTable dt = PublicHelperDAL.GetTable(page, out totalrowcount); if (dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { MemberActiveCodeModel activecode = new MemberActiveCodeModel(); if (item["ID"].ToString() != "") { activecode.ID = int.Parse(item["ID"].ToString()); } if (item["UserTime"].ToString() != "") { activecode.UserTime = DateTime.Parse(item["UserTime"].ToString()); } activecode.ActiveCode = item["ActiveCode"].ToString(); if (item["AMType"].ToString() != "") { activecode.AMType = int.Parse(item["AMType"].ToString()); } if (item["MemberID"].ToString() != "") { activecode.MemberID = int.Parse(item["MemberID"].ToString()); } activecode.MemberPhone = item["MemberPhone"].ToString(); activecode.MemberName = item["MemberName"].ToString(); if (item["AMStatus"].ToString() != "") { activecode.AMStatus = int.Parse(item["AMStatus"].ToString()); } if (item["Addtime"].ToString() != "") { activecode.Addtime = DateTime.Parse(item["Addtime"].ToString()); } activecode.UseCode = item["UseCode"].ToString(); activecode.AMStatusName = item["AMStatusName"].ToString(); list.Add(activecode); } } return(list); }
/// <summary> /// 查询所有的待匹配的接受帮助订单 /// </summary> /// <returns></returns> public List <AcceptHelpOrderModel> GetWaitAcceptOrderListForPage(AcceptHelpOrderModel model, out int totalrowcount) { List <AcceptHelpOrderModel> list = new List <AcceptHelpOrderModel>(); string columms = @" ID, AddTime, AStatus, SortIndex, OrderCode, MemberID, MemberPhone, MemberName, Amount, PayType, MatchedAmount, TurnOutOrder,CASE AStatus WHEN 0 THEN '未匹配' WHEN 1 THEN '部分匹配' WHEN 2 THEN '全部匹配' WHEN 3 THEN '已撤销' WHEN 4 THEN '对方已打款' WHEN 5 THEN '已完成' END AS AStatusName,DATEDIFF(DAY,AddTime,GETDATE()) AS diffday "; string where = " AStatus not in (3,5) and (Amount-MatchedAmount)>0 "; PageProModel page = new PageProModel(); page.colums = columms; page.orderby = " (DATEDIFF(DAY,AddTime,GETDATE())) "; page.pageindex = model.PageIndex; page.pagesize = model.PageSize; page.tablename = @"dbo.AcceptHelpOrder"; page.where = where; DataTable dt = PublicHelperDAL.GetTable(page, out totalrowcount); foreach (DataRow item in dt.Rows) { AcceptHelpOrderModel acceptordermodel = new AcceptHelpOrderModel(); if (item["ID"].ToString() != "") { acceptordermodel.ID = int.Parse(item["ID"].ToString()); } if (item["AddTime"].ToString() != "") { acceptordermodel.AddTime = DateTime.Parse(item["AddTime"].ToString()); } if (item["AStatus"].ToString() != "") { acceptordermodel.AStatus = int.Parse(item["AStatus"].ToString()); } if (item["SortIndex"].ToString() != "") { acceptordermodel.SortIndex = int.Parse(item["SortIndex"].ToString()); } acceptordermodel.OrderCode = item["OrderCode"].ToString(); if (item["MemberID"].ToString() != "") { acceptordermodel.MemberID = int.Parse(item["MemberID"].ToString()); } acceptordermodel.MemberPhone = item["MemberPhone"].ToString(); acceptordermodel.MemberName = item["MemberName"].ToString(); if (item["Amount"].ToString() != "") { acceptordermodel.Amount = decimal.Parse(item["Amount"].ToString()); } acceptordermodel.PayType = item["PayType"].ToString(); if (item["MatchedAmount"].ToString() != "") { acceptordermodel.MatchedAmount = decimal.Parse(item["MatchedAmount"].ToString()); } acceptordermodel.TurnOutOrder = item["TurnOutOrder"].ToString(); acceptordermodel.AStatusName = item["AStatusName"].ToString(); acceptordermodel.DiffDay = int.Parse(item["diffday"].ToString()); list.Add(acceptordermodel); } return(list); }
/// <summary> /// 得到会员的激活码使用信息 /// </summary> /// <param name="model"></param> /// <param name="totalrowcount"></param> /// <returns></returns> public List <ActiveCodeLogModel> GetActiveCodeLogListForPage(int memberid, int pageindex, int pagesize, out int totalrowcount) { List <ActiveCodeLogModel> list = new List <ActiveCodeLogModel>(); string columms = @"ID ,MemberID ,MemberName ,MemberPhone ,ActiveCode ,AID ,Remark ,Addtime"; string where = ""; if (memberid > 0) { where = " MemberID=" + memberid.ToString(); } PageProModel page = new PageProModel(); page.colums = columms; page.orderby = "Addtime"; page.pageindex = pageindex; page.pagesize = pagesize; page.tablename = @"dbo.ActiveCodeLog"; page.where = where; DataTable dt = PublicHelperDAL.GetTable(page, out totalrowcount); if (dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { ActiveCodeLogModel activelog = new ActiveCodeLogModel(); if (item["ID"].ToString() != "") { activelog.ID = int.Parse(item["ID"].ToString()); } activelog.ActiveCode = item["ActiveCode"].ToString(); if (item["MemberID"].ToString() != "") { activelog.MemberID = int.Parse(item["MemberID"].ToString()); } activelog.MemberPhone = item["MemberPhone"].ToString(); activelog.MemberName = item["MemberName"].ToString(); if (item["AID"].ToString() != "") { activelog.AID = int.Parse(item["AID"].ToString()); } if (item["Addtime"].ToString() != "") { activelog.Addtime = DateTime.Parse(item["Addtime"].ToString()); } activelog.Remark = item["Remark"].ToString(); list.Add(activelog); } } return(list); }
/// <summary> /// 分页查询方法 /// </summary> /// <param name="page"></param> /// <param name="totalrowcount"></param> /// <returns></returns> public static DataTable GetTable(PageProModel page, out int totalrowcount) { totalrowcount = 0; var totalrowcountpram = new SqlParameter("@totalrecord", System.Data.SqlDbType.Int); totalrowcountpram.Direction = System.Data.ParameterDirection.Output; SqlParameter[] paramter = new[] { new SqlParameter("@orderby", page.orderby), new SqlParameter("@tablename", page.tablename), new SqlParameter("@colums", page.colums), new SqlParameter("@where", page.where), new SqlParameter("@pageindex", page.pageindex), new SqlParameter("@pagesize", page.pagesize), totalrowcountpram }; DataSet ds = helper.RunProcedureDataSet("PagePro", paramter); totalrowcount = Convert.ToInt32(totalrowcountpram.Value); return(ds.Tables[0]); }
/// <summary> /// 查询所有的帮助订单 /// </summary> /// <returns></returns> public List <AcceptHelpOrderModel> GetAllAcceptOrderListForPage(AcceptHelpOrderModel model, out int totalrowcount) { List <AcceptHelpOrderModel> list = new List <AcceptHelpOrderModel>(); string columms = @"ID, AddTime, AStatus, SourceType,SortIndex, OrderCode, MemberID, MemberPhone, MemberName, Amount, PayType, MatchedAmount, TurnOutOrder,CASE AStatus WHEN 0 THEN '未匹配' WHEN 1 THEN '部分匹配' WHEN 2 THEN '全部匹配' WHEN 3 THEN '已撤销' WHEN 4 THEN '对方已打款' WHEN 5 THEN '已完成' END AS AStatusName,CASE SourceType WHEN 1 THEN '静态资金' WHEN 2 THEN '动态资金' END AS SourceTypeName "; string where = ""; if (model != null) { if (!string.IsNullOrWhiteSpace(model.OrderCode)) { where += "OrderCode='" + model.OrderCode + "'"; } if (model.MemberID > 0 && string.IsNullOrWhiteSpace(where)) { where += @" MemberID =" + model.MemberID; } else if (model.MemberID > 0 && !string.IsNullOrWhiteSpace(where)) { where += @" AND MemberID =" + model.MemberID; } if (!string.IsNullOrWhiteSpace(model.MemberPhone) && string.IsNullOrWhiteSpace(where)) { where += @" MemberPhone Like '%" + model.MemberPhone + "%'"; } else if (!string.IsNullOrWhiteSpace(model.MemberPhone) && !string.IsNullOrWhiteSpace(where)) { where += @" AND MemberPhone Like '%" + model.MemberPhone + "%'"; } if (!string.IsNullOrWhiteSpace(model.MemberName) && string.IsNullOrWhiteSpace(where)) { where += @" MemberName ='" + model.MemberName + "'"; } else if (!string.IsNullOrWhiteSpace(model.MemberName) && !string.IsNullOrWhiteSpace(where)) { where += @" AND MemberName ='" + model.MemberName + "'"; } if (model.AStatus > 0 && string.IsNullOrWhiteSpace(where)) { where += @" AStatus =" + model.AStatus; } else if (model.AStatus > 0 && !string.IsNullOrWhiteSpace(where)) { where += @" AND AStatus =" + model.AStatus; } } PageProModel page = new PageProModel(); page.colums = columms; page.orderby = "SortIndex"; page.pageindex = model.PageIndex; page.pagesize = model.PageSize; page.tablename = @"dbo.AcceptHelpOrder"; page.where = where; DataTable dt = PublicHelperDAL.GetTable(page, out totalrowcount); foreach (DataRow item in dt.Rows) { AcceptHelpOrderModel helpeordermodel = new AcceptHelpOrderModel(); if (item["ID"].ToString() != "") { helpeordermodel.ID = int.Parse(item["ID"].ToString()); } if (item["AddTime"].ToString() != "") { helpeordermodel.AddTime = DateTime.Parse(item["AddTime"].ToString()); } if (item["AStatus"].ToString() != "") { helpeordermodel.AStatus = int.Parse(item["AStatus"].ToString()); } if (item["SortIndex"].ToString() != "") { helpeordermodel.SortIndex = int.Parse(item["SortIndex"].ToString()); } helpeordermodel.OrderCode = item["OrderCode"].ToString(); if (item["MemberID"].ToString() != "") { helpeordermodel.MemberID = int.Parse(item["MemberID"].ToString()); } helpeordermodel.MemberPhone = item["MemberPhone"].ToString(); helpeordermodel.MemberName = item["MemberName"].ToString(); if (item["Amount"].ToString() != "") { helpeordermodel.Amount = decimal.Parse(item["Amount"].ToString()); } model.PayType = item["PayType"].ToString(); if (item["MatchedAmount"].ToString() != "") { helpeordermodel.MatchedAmount = decimal.Parse(item["MatchedAmount"].ToString()); } if (item["SourceType"].ToString() != "") { helpeordermodel.SourceType = item["SourceType"].ToString().ParseToInt(0); } helpeordermodel.SourceTypeName = item["SourceTypeName"].ToString(); helpeordermodel.TurnOutOrder = item["TurnOutOrder"].ToString(); helpeordermodel.AStatusName = item["AStatusName"].ToString(); list.Add(helpeordermodel); } return(list); }
/// <summary> /// 得到分页数据 /// </summary> /// <param name="model"></param> /// <param name="totalrowcount"></param> /// <returns></returns> public List <ActiveCodeModel> GetActiveCodeListForPage(ActiveCodeModel model, out int totalrowcount) { List <ActiveCodeModel> list = new List <ActiveCodeModel>(); string columms = @"ID,ActivationCode,AType,CASE AType WHEN 1 THEN '激活码' WHEN 2 THEN '排单币' END ATypeName,AStatus,AddTime,CASE AStatus WHEN 20 THEN '未使用' WHEN 15 THEN '已分配' WHEN 10 THEN '已使用' END AStatusName "; string where = ""; if (model != null) { if (model.AStatus > 0) { where += " AStatus= " + model.AStatus; } if (!string.IsNullOrWhiteSpace(model.ActivationCode) && string.IsNullOrWhiteSpace(where)) { where += @" ActivationCode Like '%" + model.ActivationCode + "%'"; } else if (!string.IsNullOrWhiteSpace(model.ActivationCode) && !string.IsNullOrWhiteSpace(where)) { where += @" AND ActivationCode Like '%" + model.ActivationCode + "%'"; } if (model.AType > 0 && string.IsNullOrWhiteSpace(where)) { where += @" AType =" + model.AType; } else if (model.AType > 0 && !string.IsNullOrWhiteSpace(where)) { where += @" AND AType =" + model.AType; } } PageProModel page = new PageProModel(); page.colums = columms; page.orderby = "ID"; page.pageindex = model.PageIndex; page.pagesize = model.PageSize; page.tablename = @"dbo.ActiveCode"; page.where = where; DataTable dt = PublicHelperDAL.GetTable(page, out totalrowcount); if (dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { ActiveCodeModel active = new ActiveCodeModel(); if (item["ID"].ToString() != "") { active.ID = int.Parse(item["ID"].ToString()); } active.ActivationCode = item["ActivationCode"].ToString(); if (item["AType"].ToString() != "") { active.AType = int.Parse(item["AType"].ToString()); } if (item["AStatus"].ToString() != "") { active.AStatus = int.Parse(item["AStatus"].ToString()); } if (item["AddTime"].ToString() != "") { active.AddTime = DateTime.Parse(item["AddTime"].ToString()); } active.AStatusName = item["AStatusName"].ToString(); active.ATypeName = item["ATypeName"].ToString(); list.Add(active); } } return(list); }
/// <summary> /// 得到会员的激活码信息 /// </summary> /// <param name="model"></param> /// <param name="totalrowcount"></param> /// <returns></returns> public List <MemberActiveCodeModel> GetMemberActiveCodeListForPage(MemberActiveCodeModel model, out int totalrowcount) { List <MemberActiveCodeModel> list = new List <MemberActiveCodeModel>(); string columms = @"ID ,ActiveCode ,AMType,CASE AMType WHEN 1 THEN '激活账户' WHEN 2 THEN '排单专用' END AMTypeName ,MemberID ,MemberPhone ,MemberName ,AMStatus ,Addtime,CASE AMStatus WHEN 1 THEN '未使用' WHEN 2 THEN '已使用' WHEN 3 THEN '已过期' END AMStatusName"; string where = ""; if (model != null) { if (model.AMStatus > 0) { where += " AMStatus= " + model.AMStatus; } if (!string.IsNullOrWhiteSpace(model.MemberPhone) && string.IsNullOrWhiteSpace(where)) { where += @" MemberPhone Like '%" + model.MemberPhone + "%'"; } else if (!string.IsNullOrWhiteSpace(model.MemberPhone) && !string.IsNullOrWhiteSpace(where)) { where += @" AND MemberPhone Like '%" + model.MemberPhone + "%'"; } if (!string.IsNullOrWhiteSpace(model.ActiveCode) && string.IsNullOrWhiteSpace(where)) { where += @" ActiveCode ='" + model.ActiveCode + "'"; } else if (!string.IsNullOrWhiteSpace(model.ActiveCode) && !string.IsNullOrWhiteSpace(where)) { where += @" AND ActiveCode ='" + model.ActiveCode + "'"; } } PageProModel page = new PageProModel(); page.colums = columms; page.orderby = "Addtime"; page.pageindex = model.PageIndex; page.pagesize = model.PageSize; page.tablename = @"dbo.MemberActiveCode"; page.where = where; DataTable dt = PublicHelperDAL.GetTable(page, out totalrowcount); if (dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { MemberActiveCodeModel memberactive = new MemberActiveCodeModel(); if (item["ID"].ToString() != "") { memberactive.ID = int.Parse(item["ID"].ToString()); } memberactive.ActiveCode = item["ActiveCode"].ToString(); if (item["MemberID"].ToString() != "") { memberactive.MemberID = int.Parse(item["MemberID"].ToString()); } memberactive.MemberPhone = item["MemberPhone"].ToString(); memberactive.MemberName = item["MemberName"].ToString(); if (item["AMStatus"].ToString() != "") { memberactive.AMStatus = int.Parse(item["AMStatus"].ToString()); } if (item["Addtime"].ToString() != "") { memberactive.Addtime = DateTime.Parse(item["Addtime"].ToString()); } memberactive.AMStatusName = item["AMStatusName"].ToString(); memberactive.AMTypeName = item["AMTypeName"].ToString(); list.Add(memberactive); } } return(list); }
/// <summary> /// 按页查询匹配的单据信息 /// </summary> /// <param name="model"></param> /// <param name="totalrowcount"></param> /// <returns></returns> public static List <MatchOrderModel> GetMatchedOrderListByPage(MatchOrderModel model, out int totalrowcount) { List <MatchOrderModel> list = new List <MatchOrderModel>(); string columms = @" ID,HelperOrderID,HelperOrderCode,HelperMemberID,AcceptOrderID,AcceptOrderCode,AcceptMemberID,MatchedMoney,MatchTime,MatchStatus,LastUpdateTime,CASE MatchStatus WHEN 1 THEN '已匹配' WHEN 2 THEN '已取消' WHEN 3 THEN '已打款' WHEN 4 THEN '已完成' END AS MatchStatusName,HelperMemberName,HelperMemberPhone,AcceptMemberName,AcceptMemberPhone "; string where = ""; if (model != null) { if (model.MatchStatus > 0) { where += "MatchStatus='" + model.MatchStatus + "'"; } if (!string.IsNullOrWhiteSpace(model.HelperOrderCode) && string.IsNullOrWhiteSpace(where)) { where += " HelperOrderCode='" + model.HelperOrderCode.ToString() + "'"; } else if (!string.IsNullOrWhiteSpace(where) && !string.IsNullOrWhiteSpace(model.HelperOrderCode)) { where += @" AND HelperOrderCode='" + model.HelperOrderCode.ToString() + "'"; } if (!string.IsNullOrWhiteSpace(model.AcceptOrderCode) && string.IsNullOrWhiteSpace(where)) { where += @" AcceptOrderCode = '" + model.AcceptOrderCode + "'"; } else if (!string.IsNullOrWhiteSpace(model.AcceptOrderCode) && !string.IsNullOrWhiteSpace(where)) { where += @" AND AcceptOrderCode = '" + model.AcceptOrderCode + "'"; } } PageProModel page = new PageProModel(); page.colums = columms; page.orderby = "ID"; page.pageindex = model.PageIndex; page.pagesize = model.PageSize; page.tablename = @"dbo.MatchOrder"; page.where = where; DataTable dt = PublicHelperDAL.GetTable(page, out totalrowcount); foreach (DataRow item in dt.Rows) { MatchOrderModel matchordermodel = new MatchOrderModel(); if (item["ID"].ToString() != "") { matchordermodel.ID = int.Parse(item["ID"].ToString()); } if (item["MatchStatus"].ToString() != "") { matchordermodel.MatchStatus = int.Parse(item["MatchStatus"].ToString()); } if (item["LastUpdateTime"].ToString() != "") { matchordermodel.LastUpdateTime = DateTime.Parse(item["LastUpdateTime"].ToString()); } if (item["HelperOrderID"].ToString() != "") { matchordermodel.HelperOrderID = int.Parse(item["HelperOrderID"].ToString()); } matchordermodel.HelperOrderCode = item["HelperOrderCode"].ToString(); matchordermodel.HelperMemberName = item["HelperMemberName"].ToString(); matchordermodel.HelperMemberPhone = item["HelperMemberPhone"].ToString(); matchordermodel.AcceptMemberName = item["AcceptMemberName"].ToString(); matchordermodel.AcceptMemberPhone = item["AcceptMemberPhone"].ToString(); if (item["HelperMemberID"].ToString() != "") { matchordermodel.HelperMemberID = int.Parse(item["HelperMemberID"].ToString()); } if (item["AcceptOrderID"].ToString() != "") { matchordermodel.AcceptOrderID = int.Parse(item["AcceptOrderID"].ToString()); } matchordermodel.AcceptOrderCode = item["AcceptOrderCode"].ToString(); if (item["AcceptMemberID"].ToString() != "") { matchordermodel.AcceptMemberID = int.Parse(item["AcceptMemberID"].ToString()); } if (item["MatchedMoney"].ToString() != "") { matchordermodel.MatchedMoney = decimal.Parse(item["MatchedMoney"].ToString()); } if (item["MatchTime"].ToString() != "") { matchordermodel.MatchTime = DateTime.Parse(item["MatchTime"].ToString()); } matchordermodel.MatchStatusName = item["MatchStatusName"].ToString(); list.Add(matchordermodel); } return(list); }
/// <summary> /// 查询用户操作数据 /// </summary> /// <param name="model"></param> /// <param name="totalrowcount"></param> /// <returns></returns> public static List <UserBehaviorLogModel> GetUserBehaviorLogByPage(UserBehaviorLogModel model, out int totalrowcount) { List <UserBehaviorLogModel> list = new List <UserBehaviorLogModel>(); string columms = @" ID,MemberID,MemberPhone,MemberName,BehaviorSource,BehaviorType,ProcAmount,HOrderCode,AOrderCode,Remark,AddTime,CASE BehaviorType WHEN 1 THEN '登陆' WHEN 2 THEN '提供帮助' WHEN 3 THEN '接受帮助' WHEN 4 THEN '变更打款' WHEN 5 THEN '确认单据' WHEN 6 THEN '撤销单据' WHEN 7 THEN '发放排单币' WHEN 8 THEN '发放激活币' WHEN 9 THEN '奖励会员' WHEN 10 THEN '惩罚会员' WHEN 11 THEN '系统派息' END AS BehaviorTypeName,CASE BehaviorSource WHEN 1 THEN '前端' WHEN 2 THEN '后台' END AS BehaviorSourceName "; string where = ""; if (model != null) { if (model.BehaviorType > 0) { where += @"BehaviorType='" + model.BehaviorType + "'"; } if (!string.IsNullOrWhiteSpace(model.MemberName) && string.IsNullOrWhiteSpace(where)) { where += @" MemberName=" + model.MemberID.ToString(); } else if (!string.IsNullOrWhiteSpace(where) && !string.IsNullOrWhiteSpace(model.MemberName)) { where += @" AND MemberName=" + model.MemberID.ToString(); } if (!string.IsNullOrWhiteSpace(model.MemberPhone) && string.IsNullOrWhiteSpace(where)) { where += @" MemberPhone = '" + model.MemberPhone + "'"; } else if (!string.IsNullOrWhiteSpace(model.MemberPhone) && !string.IsNullOrWhiteSpace(where)) { where += @" AND MemberPhone = '" + model.MemberPhone + "'"; } } PageProModel page = new PageProModel(); page.colums = columms; page.orderby = "ID"; page.pageindex = model.PageIndex; page.pagesize = model.PageSize; page.tablename = @"dbo.UserBehaviorLog"; page.where = where; DataTable dt = PublicHelperDAL.GetTable(page, out totalrowcount); if (dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { UserBehaviorLogModel usermodel = new UserBehaviorLogModel(); if (item["ID"].ToString() != "") { usermodel.ID = int.Parse(item["ID"].ToString()); } usermodel.Remark = item["Remark"].ToString(); if (item["AddTime"].ToString() != "") { usermodel.AddTime = DateTime.Parse(item["AddTime"].ToString()); } if (item["MemberID"].ToString() != "") { usermodel.MemberID = int.Parse(item["MemberID"].ToString()); } usermodel.MemberPhone = item["MemberPhone"].ToString(); usermodel.MemberName = item["MemberName"].ToString(); if (item["BehaviorSource"].ToString() != "") { usermodel.BehaviorSource = int.Parse(item["BehaviorSource"].ToString()); } if (item["BehaviorType"].ToString() != "") { usermodel.BehaviorType = int.Parse(item["BehaviorType"].ToString()); } if (item["ProcAmount"].ToString() != "") { usermodel.ProcAmount = decimal.Parse(item["ProcAmount"].ToString()); } usermodel.HOrderCode = item["HOrderCode"].ToString(); usermodel.AOrderCode = item["AOrderCode"].ToString(); usermodel.BehaviorSourceName = item["BehaviorSourceName"].ToString(); usermodel.BehaviorTypeName = item["BehaviorTypeName"].ToString(); list.Add(usermodel); } } return(list); }
/// <summary> /// 查询所有的帮助订单 /// </summary> /// <returns></returns> public List <HelpeOrderModel> GetAllHelpeOrderListForPage(HelpeOrderModel model, out int totalrowcount) { List <HelpeOrderModel> list = new List <HelpeOrderModel>(); string columms = @"ID, MatchedAmount, AddTime, SortIndex, ActiveCode,OrderCode, MemberID, MemberPhone, MemberName, Amount, Interest, PayType, HStatus,CASE HStatus WHEN 0 THEN '未匹配' WHEN 1 THEN '部分匹配' WHEN 2 THEN '全部匹配' WHEN 3 THEN '已撤销' WHEN 4 THEN '已打款' WHEN 5 THEN '已确认' END AS HStatusName"; string where = ""; if (model != null) { if (!string.IsNullOrWhiteSpace(model.OrderCode)) { where += "OrderCode='" + model.OrderCode + "'"; } if (model.MemberID > 0 && string.IsNullOrWhiteSpace(where)) { where += " MemberID=" + model.MemberID.ToString(); } else if (!string.IsNullOrWhiteSpace(where) && model.MemberID > 0) { where += @" AND MemberID=" + model.MemberID.ToString(); } if (!string.IsNullOrWhiteSpace(model.MemberPhone) && string.IsNullOrWhiteSpace(where)) { where += @" MemberPhone Like '%" + model.MemberPhone + "%'"; } else if (!string.IsNullOrWhiteSpace(model.MemberPhone) && !string.IsNullOrWhiteSpace(where)) { where += @" AND MemberPhone Like '%" + model.MemberPhone + "%'"; } if (!string.IsNullOrWhiteSpace(model.MemberName) && string.IsNullOrWhiteSpace(where)) { where += @" MemberName ='" + model.MemberName + "'"; } else if (!string.IsNullOrWhiteSpace(model.MemberName) && !string.IsNullOrWhiteSpace(where)) { where += @" AND MemberName ='" + model.MemberName + "'"; } if (model.HStatus > -10 && string.IsNullOrWhiteSpace(where)) { where += @" HStatus =" + model.HStatus; } else if (model.HStatus > -10 && !string.IsNullOrWhiteSpace(where)) { where += @" AND HStatus =" + model.HStatus; } } PageProModel page = new PageProModel(); page.colums = columms; page.orderby = "SortIndex"; page.pageindex = model.PageIndex; page.pagesize = model.PageSize; page.tablename = @"dbo.HelpeOrder"; page.where = where; DataTable dt = PublicHelperDAL.GetTable(page, out totalrowcount); foreach (DataRow item in dt.Rows) { HelpeOrderModel helpeordermodel = new HelpeOrderModel(); if (item["ID"].ToString() != "") { helpeordermodel.ID = int.Parse(item["ID"].ToString()); } if (item["MatchedAmount"].ToString() != "") { helpeordermodel.MatchedAmount = decimal.Parse(item["MatchedAmount"].ToString()); } if (item["AddTime"].ToString() != "") { helpeordermodel.AddTime = DateTime.Parse(item["AddTime"].ToString()); } if (item["SortIndex"].ToString() != "") { helpeordermodel.SortIndex = int.Parse(item["SortIndex"].ToString()); } helpeordermodel.OrderCode = item["OrderCode"].ToString(); if (item["MemberID"].ToString() != "") { helpeordermodel.MemberID = int.Parse(item["MemberID"].ToString()); } helpeordermodel.MemberPhone = item["MemberPhone"].ToString(); helpeordermodel.MemberName = item["MemberName"].ToString(); if (item["Amount"].ToString() != "") { helpeordermodel.Amount = decimal.Parse(item["Amount"].ToString()); } if (item["Interest"].ToString() != "") { helpeordermodel.Interest = decimal.Parse(item["Interest"].ToString()); } helpeordermodel.PayType = item["PayType"].ToString(); if (item["HStatus"].ToString() != "") { helpeordermodel.HStatus = int.Parse(item["HStatus"].ToString()); } helpeordermodel.HStatusName = item["HStatusName"].ToString(); helpeordermodel.ActiveCode = item["ActiveCode"].ToString(); list.Add(helpeordermodel); } return(list); }
/// <summary> /// 得到分页数据 /// </summary> /// <param name="model"></param> /// <param name="totalrowcount"></param> /// <returns></returns> public List <MemberInfoModel> GetMemberInfoListForPage(MemberInfoModel model, out int totalrowcount) { List <MemberInfoModel> list = new List <MemberInfoModel>(); string columms = @"ID,TruethName,Sex,TelPhone,MobileNum,Email,IdentificationID,Province,City,Area,ADDRESS,WeixinNum,AliPayName,AliPayNum,SecurityQuestion,SecurityAnswer,MStatus,AddTime,CASE MStatus WHEN 1 THEN '待激活' WHEN 2 THEN '已激活' WHEN 3 THEN '已冻结' END MStatusName"; string where = ""; if (model != null) { if (model.ID > 0) { where += "ID=" + model.ID; } if (!string.IsNullOrWhiteSpace(model.MobileNum) && string.IsNullOrWhiteSpace(where)) { where += @" MobileNum Like '%" + model.MobileNum + "%'"; } else if (!string.IsNullOrWhiteSpace(model.MobileNum) && !string.IsNullOrWhiteSpace(where)) { where += @" AND MobileNum Like '%" + model.MobileNum + "%'"; } if (!string.IsNullOrWhiteSpace(model.TruethName) && string.IsNullOrWhiteSpace(where)) { where += @" TruethName ='" + model.TruethName + "'"; } else if (!string.IsNullOrWhiteSpace(model.TruethName) && !string.IsNullOrWhiteSpace(where)) { where += @" AND TruethName ='" + model.TruethName + "'"; } if (model.MStatus > 0 && string.IsNullOrWhiteSpace(where)) { where += @" MStatus =" + model.MStatus; } else if (model.MStatus > 0 && !string.IsNullOrWhiteSpace(where)) { where += @" AND MStatus =" + model.MStatus; } } PageProModel page = new PageProModel(); page.colums = columms; page.orderby = "ID"; page.pageindex = model.PageIndex; page.pagesize = model.PageSize; page.tablename = @"dbo.MemberInfo"; page.where = where; DataTable dt = PublicHelperDAL.GetTable(page, out totalrowcount); if (dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { MemberInfoModel memberModel = new MemberInfoModel(); if (item["ID"].ToString() != "") { memberModel.ID = int.Parse(item["ID"].ToString()); } memberModel.TruethName = item["TruethName"].ToString(); if (item["Sex"].ToString() != "") { memberModel.Sex = int.Parse(item["Sex"].ToString()); } if (item["MStatus"].ToString() != "") { memberModel.MStatus = int.Parse(item["MStatus"].ToString()); } memberModel.TelPhone = item["TelPhone"].ToString(); if (item["AddTime"].ToString() != "") { memberModel.AddTime = DateTime.Parse(item["AddTime"].ToString()); } memberModel.MobileNum = item["MobileNum"].ToString(); memberModel.Email = item["Email"].ToString(); memberModel.IdentificationID = item["IdentificationID"].ToString(); memberModel.Province = item["Province"].ToString(); memberModel.City = item["City"].ToString(); memberModel.Area = item["Area"].ToString(); memberModel.Address = item["ADDRESS"].ToString(); memberModel.AliPayName = item["AliPayName"].ToString(); memberModel.AliPayNum = item["AliPayNum"].ToString(); memberModel.SecurityQuestion = item["SecurityQuestion"].ToString(); memberModel.WeixinNum = item["WeixinNum"].ToString(); memberModel.SecurityAnswer = item["SecurityAnswer"].ToString(); memberModel.MStatusName = item["MStatusName"].ToString(); list.Add(memberModel); } } return(list); }