/// <summary>
/// 根据会员获取会员提现信息
/// </summary>
/// <param name="context"></param>
private void GetTiXianByMemberID(HttpContext context)
{
int totalRecords = 0;
int PageIndex = 1;
int PageSize = 10;
string[] Search = null;
try
{
string pqGrid_PageIndex = context.Request.QueryString["pqGrid_PageIndex"];
PageIndex = Convert.ToInt32(pqGrid_PageIndex);
string pqGrid_PageSize = context.Request.QueryString["pqGrid_PageSize"];
PageSize = Convert.ToInt32(pqGrid_PageSize);
Search = context.Request.QueryString["Search"].Split('|');//name@value|name@value
}
catch
{
}
string type = context.Request.QueryString["type"];
string pqGrid_OrderField = context.Request.QueryString["pqGrid_OrderField"]; //排序字段名
string pqGrid_OrderType = context.Request.QueryString["pqGrid_OrderType"]; //排序方式 asc desc
string pqGrid_Sort = context.Request.QueryString["pqGrid_Sort"]; //需要查询的字段
string pqGrid = context.Request.QueryString["_"];
if (pqGrid_OrderField == null || pqGrid_OrderField == "")//排序字段不能为空
{
pqGrid_OrderField = "ID";
}
int OrderType = pqGrid_OrderType == "asc" ? 0 : 1;
string Memberid = "";
StringBuilder sb = new StringBuilder();//查询条件
sb.Append(" 1 = 1 ");
if (Search != null && Search.Length > 0)
{
for (int i = 0; i < Search.Length; i++)
{
string[] nv = Search[i].Split('@');
if (nv.Length == 2)
{
var cs = "@obj" + i;
if (nv[0] == "Search")
{
sb.Append(" and (bz like '%" + nv[1] + "%' or wxddh like '%" + nv[1] + "%' )");
}
else if (nv[0] == "UserId")
{
sb.Append(" and UserId='" + nv[1] + "' ");
}
else if (nv[0] == "addtime")
{
sb.Append(" and addtime>='" + nv[1] + "' ");
}
else if (nv[0] == "addtime2")
{
sb.Append(" and addtime<='" + nv[1] + "' ");
}
}
}
}
DataTable dt = DataFactory.SqlDataBase().DbPager("V_Sales_withdraw", pqGrid_Sort, sb.ToString(), pqGrid_OrderField, OrderType, PageSize, PageIndex, out totalRecords);
ArrayList data = new ArrayList();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ArrayList cs = new ArrayList();
for (int j = 1; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].DataType.Name == "DateTime")
{
cs.Add(Convert.ToDateTime(dt.Rows[i][j]).ToString("yyyy-MM-dd HH:mm"));
}
else
{
cs.Add(dt.Rows[i][j].ToString());
}
}
data.Add(cs);
}
}
PqGridHelper pq = new PqGridHelper();
pq.totalRecords = totalRecords;
pq.curPage = PageIndex;
pq.data = data;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(pq);
context.Response.Write(json);
}
/// <summary>
/// 获取信息列表
/// </summary>
/// <param name="context"></param>
private void GetInfoList(HttpContext context)
{
if (RequestSession.GetSessionUser() == null)
{
context.Response.Write("");
return;
}
int totalRecords = 0;
int PageIndex = 1;
int PageSize = 10;
string[] Search = null;
try
{
string pqGrid_PageIndex = context.Request.QueryString["pqGrid_PageIndex"];
PageIndex = Convert.ToInt32(pqGrid_PageIndex);
string pqGrid_PageSize = context.Request.QueryString["pqGrid_PageSize"];
PageSize = Convert.ToInt32(pqGrid_PageSize);
Search = context.Request.QueryString["Search"].Split('|');//name@value|name@value
}
catch
{
}
string type = context.Request.QueryString["type"];
string pqGrid_OrderField = context.Request.QueryString["pqGrid_OrderField"]; //排序字段名
string pqGrid_OrderType = context.Request.QueryString["pqGrid_OrderType"]; //排序方式 asc desc
string pqGrid_Sort = context.Request.QueryString["pqGrid_Sort"]; //需要查询的字段
string pqGrid = context.Request.QueryString["_"];
if (pqGrid_OrderField == null || pqGrid_OrderField == "")//排序字段不能为空
{
pqGrid_OrderField = "CreateDate";
}
int OrderType = pqGrid_OrderType == "asc" ? 0 : 1;
StringBuilder sb = new StringBuilder();//查询条件
sb.Append(" 1 = 1 ");
if (Search != null && Search.Length > 0)
{
for (int i = 0; i < Search.Length; i++)
{
string[] nv = Search[i].Split('@');
if (nv.Length == 2)
{
var cs = "@obj" + i;
if (nv[0] == "kh")
{
sb.Append(" and (User_Account like '%" + nv[1] + "%' or User_Name like '%" + nv[1] + "%' or Roles_Name like '%" + nv[1] + "%' )");
}
else if (nv[0] == "CreateDate")
{
sb.Append(" and CreateDate>='" + nv[1] + "' ");
}
else if (nv[0] == "CreateDate2")
{
sb.Append(" and CreateDate<='" + nv[1] + " 23:59:59" + "' ");
}
else
{
sb.Append(" and " + nv[0] + " = '" + nv[1] + "' ");
}
}
}
}
IList <SqlParam> IList_param = new List <SqlParam>();
DataTable dt = DataFactory.SqlDataBase().DbPager("V_HotelMemberList", pqGrid_Sort, sb.ToString(), pqGrid_OrderField, OrderType, PageSize, PageIndex, out totalRecords);
ArrayList data = new ArrayList();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ArrayList cs = new ArrayList();
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].DataType.Name == "DateTime")
{
cs.Add(Convert.ToDateTime(dt.Rows[i][j]).ToString("yyyy-MM-dd HH:mm"));
}
else if (dt.Columns[j].DataType.Name == "Decimal")
{
cs.Add(dt.Rows[i][j]).ToString();
}
else
{
cs.Add(dt.Rows[i][j].ToString());
}
}
//cs = GetTongJiData(cs);//增加统计数据
data.Add(cs);
}
}
PqGridHelper pq = new PqGridHelper();
pq.totalRecords = totalRecords;
pq.curPage = PageIndex;
pq.data = data;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(pq);
context.Response.Write(json);
}
private void GetInfoList(HttpContext context)
{
int totalRecords = 0;
int PageIndex = 1;
int PageSize = 10;
string[] Search = null;
try
{
string pqGrid_PageIndex = context.Request.QueryString["pqGrid_PageIndex"];
PageIndex = Convert.ToInt32(pqGrid_PageIndex);
string pqGrid_PageSize = context.Request.QueryString["pqGrid_PageSize"];
PageSize = Convert.ToInt32(pqGrid_PageSize);
Search = context.Request.QueryString["Search"].Split('|');//name@value|name@value
}
catch
{
}
string type = context.Request.QueryString["type"];
string pqGrid_OrderField = context.Request.QueryString["pqGrid_OrderField"]; //排序字段名
string pqGrid_OrderType = context.Request.QueryString["pqGrid_OrderType"]; //排序方式 asc desc
string pqGrid_Sort = context.Request.QueryString["pqGrid_Sort"]; //需要查询的字段
string pqGrid = context.Request.QueryString["_"];
if (pqGrid_OrderField == null || pqGrid_OrderField == "")//排序字段不能为空
{
pqGrid_OrderField = "CreateDate";
}
int OrderType = pqGrid_OrderType == "asc" ? 0 : 1;
StringBuilder sb = new StringBuilder();//查询条件
sb.Append(" 1 = 1 ");
if (Search != null && Search.Length > 0)
{
for (int i = 0; i < Search.Length; i++)
{
string[] nv = Search[i].Split('@');
if (nv.Length == 2)
{
if (nv[0] == "USER_NAME")
{
sb.Append(" and (USER_NAME like '%" + nv[1] + "%' or User_Account like '%" + nv[1] + "%' or theme like '%" + nv[1] + "%'");
}
else
{
sb.Append(" and " + nv[0] + " = '" + nv[1] + "' ");
}
}
}
}
if (context.Request.Cookies["dladmin_COOKIE"]["User_Account"].ToLower() != "sewa")
{
sb.Append("and User_Account!='sewa'");
}
DataTable dt = DataFactory.SqlDataBase().DbPager("V_ABase_UserInfo", pqGrid_Sort, sb.ToString(), pqGrid_OrderField, OrderType, PageSize, PageIndex, out totalRecords);
ArrayList data = new ArrayList();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ArrayList cs = new ArrayList();
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].DataType.Name == "DateTime")
{
cs.Add(Convert.ToDateTime(dt.Rows[i][j]).ToString("yyyy-MM-dd"));
}
else
{
cs.Add(dt.Rows[i][j].ToString());
}
}
data.Add(cs);
}
}
PqGridHelper pq = new PqGridHelper();
pq.totalRecords = totalRecords;
pq.curPage = PageIndex;
pq.data = data;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(pq);
context.Response.Write(json);
}
/// <summary>
/// 积分信息
/// </summary>
/// <param name="context"></param>
private void GetIntegralInfoMemberID(HttpContext context)
{
int totalRecords = 0;
int PageIndex = 1;
int PageSize = 10;
string[] Search = null;
try
{
string pqGrid_PageIndex = context.Request.QueryString["pqGrid_PageIndex"];
PageIndex = Convert.ToInt32(pqGrid_PageIndex);
string pqGrid_PageSize = context.Request.QueryString["pqGrid_PageSize"];
PageSize = Convert.ToInt32(pqGrid_PageSize);
Search = context.Request.QueryString["Search"].Split('|');//name@value|name@value
}
catch
{
}
string type = context.Request.QueryString["type"];
string pqGrid_OrderField = context.Request.QueryString["pqGrid_OrderField"]; //排序字段名
string pqGrid_OrderType = context.Request.QueryString["pqGrid_OrderType"]; //排序方式 asc desc
string pqGrid_Sort = context.Request.QueryString["pqGrid_Sort"]; //需要查询的字段
string pqGrid = context.Request.QueryString["_"];
if (pqGrid_OrderField == null || pqGrid_OrderField == "")//排序字段不能为空
{
pqGrid_OrderField = "czrq";
}
int OrderType = pqGrid_OrderType == "asc" ? 0 : 1;
StringBuilder sb = new StringBuilder();//查询条件
sb.AppendFormat(" and AdminHotelid = '{0}' ", RequestSession.GetSessionUser().AdminHotelid.ToString());
if (Search != null && Search.Length > 0)
{
for (int i = 0; i < Search.Length; i++)
{
string[] nv = Search[i].Split('@');
if (nv.Length == 2)
{
var cs = "@obj" + i;
if (nv[0] == "memberID")
{
sb.Append(" and lsh=" + nv[1] + "");
}
}
}
}
DataTable dt = DataFactory.SqlDataBase().GetPageLists("select jf.lsh,jf.kh,hy_hyzlxxb.xm,jf.czrq,jf.zmsm,jf.jf,sjhm from hy_hyxfjlb jf inner join hy_hyzlxxb on hy_hyzlxxb.lsh=jf.lsh where 1=1 and hy_hyzlxxb.carid is not null " + sb, pqGrid_Sort, pqGrid_OrderField, pqGrid_OrderType, PageIndex, PageSize, ref totalRecords);
// DataTable dt = DataFactory.SqlDataBase().DbPager("V_IntegralInfo", pqGrid_Sort, sb.ToString(), pqGrid_OrderField, OrderType, PageSize, PageIndex, out totalRecords);
ArrayList data = new ArrayList();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ArrayList cs = new ArrayList();
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].DataType.Name == "DateTime")
{
cs.Add(Convert.ToDateTime(dt.Rows[i][j]).ToString("yyyy-MM-dd"));
}
else if (dt.Columns[j].DataType.Name == "Decimal")
{
cs.Add(Convert.ToInt32(dt.Rows[i][j]).ToString());
}
else
{
cs.Add(dt.Rows[i][j].ToString());
}
}
data.Add(cs);
}
}
PqGridHelper pq = new PqGridHelper();
pq.totalRecords = totalRecords;
pq.curPage = PageIndex;
pq.data = data;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(pq);
context.Response.Write(json);
}
private void GetInfoListss(HttpContext context)
{
int totalRecords = 0;
int PageIndex = 1;
int PageSize = 10;
string[] Search = null;
try
{
string pqGrid_PageIndex = context.Request.QueryString["pqGrid_PageIndex"];
PageIndex = Convert.ToInt32(pqGrid_PageIndex);
string pqGrid_PageSize = context.Request.QueryString["pqGrid_PageSize"];
PageSize = Convert.ToInt32(pqGrid_PageSize);
Search = context.Request.QueryString["Search"].Split('|');//name@value|name@value
}
catch
{
}
string type = context.Request.QueryString["type"];
string pqGrid_OrderField = context.Request.QueryString["pqGrid_OrderField"]; //排序字段名
string pqGrid_OrderType = context.Request.QueryString["pqGrid_OrderType"]; //排序方式 asc desc
string pqGrid_Sort = context.Request.QueryString["pqGrid_Sort"]; //需要查询的字段
string pqGrid = context.Request.QueryString["_"];
if (pqGrid_OrderField == null || pqGrid_OrderField == "")//排序字段不能为空
{
pqGrid_OrderField = "AddTime";
}
int OrderType = pqGrid_OrderType == "asc" ? 0 : 1;
string lsh = context.Request["lsh"];
StringBuilder sb = new StringBuilder();//查询条件
sb.Append(" 1 = 1 ");
//if (Search != null && Search.Length > 0)
//{
// for (int i = 0; i < Search.Length; i++)
// {
// string[] nv = Search[i].Split('@');
// if (nv.Length == 2)
// {
// var cs = "@obj" + i;
// if (nv[0] == "ordernum")
// sb.Append(" and (OrderNum like '%" + nv[1] + "%' or hotelname like '%" + nv[1] + "%' or Name like '%" + nv[1] + "%' or Mobile like '%" + nv[1] + "%' )");
// if (nv[0] == "branch")
// sb.Append(" and hotelname ='" + nv[1] + "'");
// if (nv[0] == "roomType")
// sb.Append(" and RoomType ='" + nv[1] + "'");
// if (nv[0] == "Pay")
// sb.Append(" and Pay ='" + nv[1] + "'");
// }
// }
//}
if (RequestSession.GetSessionUser() == null)
{
context.Response.Write("");
return;
}
sb.Append(" and AdminHotelid='" + RequestSession.GetSessionUser().AdminHotelid.ToString() + "' ");
sb.Append(" and MemberId = '" + lsh + "' ");
string sqls = string.Format("select hotelid from Base_UserInfo where AdminHotelid='{0}'", RequestSession.GetSessionUser().AdminHotelid.ToString());
DataTable ds = DataFactory.SqlDataBase().GetDataTableBySQL(new StringBuilder(sqls));
if (ds != null && ds.Rows.Count > 0)
{
if (ds.Rows[0]["hotelid"] != null && ds.Rows[0]["hotelid"].ToString() != "" && ds.Rows[0]["hotelid"].ToString() != "0")
{
sb.AppendFormat("and hotelid='{0}'", ds.Rows[0]["hotelid"]);
}
}
DataTable dt = DataFactory.SqlDataBase().DbPager("V_Reservations", pqGrid_Sort, sb.ToString(), pqGrid_OrderField, OrderType, PageSize, PageIndex, out totalRecords);
ArrayList data = new ArrayList();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ArrayList cs = new ArrayList();
for (int j = 1; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].DataType.Name == "DateTime")
{
cs.Add(Convert.ToDateTime(dt.Rows[i][j]).ToString("yyyy-MM-dd HH:mm"));
}
else
{
cs.Add(dt.Rows[i][j].ToString());
}
}
data.Add(cs);
}
}
PqGridHelper pq = new PqGridHelper();
pq.totalRecords = totalRecords;
pq.curPage = PageIndex;
pq.data = data;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(pq);
context.Response.Write(json);
}
private void GetInfoListsR(HttpContext context)
{
int totalRecords = 0;
int PageIndex = 1;
int PageSize = 10;
string[] Search = null;
try
{
string pqGrid_PageIndex = context.Request.QueryString["pqGrid_PageIndex"];
PageIndex = Convert.ToInt32(pqGrid_PageIndex);
string pqGrid_PageSize = context.Request.QueryString["pqGrid_PageSize"];
PageSize = Convert.ToInt32(pqGrid_PageSize);
Search = context.Request.QueryString["Search"].Split('|');//name≌value|name≌value
}
catch
{
}
string type = context.Request.QueryString["type"];
string pqGrid_OrderField = context.Request.QueryString["pqGrid_OrderField"]; //排序字段名
string pqGrid_OrderType = context.Request.QueryString["pqGrid_OrderType"]; //排序方式 asc desc
string pqGrid_Sort = context.Request.QueryString["pqGrid_Sort"]; //需要查询的字段
string pqGrid = context.Request.QueryString["_"];
if (pqGrid_OrderField == null || pqGrid_OrderField == "")//排序字段不能为空
{
pqGrid_OrderField = "AddTime";
}
int OrderType = pqGrid_OrderType == "DESC" ? 0 : 1;
StringBuilder sb = new StringBuilder();//查询条件
sb.Append(" AdminHotelid = '" + RequestSession.GetSessionUser().AdminHotelid.ToString() + "' ");
if (Search != null && Search.Length > 0)
{
for (int i = 0; i < Search.Length; i++)
{
string[] nv = Search[i].Split('@');
if (nv.Length == 2)
{
if (nv[0] == "start")
{
sb.Append(String.Format(" and CONVERT(varchar(100), AddTime, 23)>='{0}' ", nv[1]));
}
else if (nv[0] == "end")
{
sb.Append(String.Format(" and CONVERT(varchar(100), AddTime, 23)<='{0} 23:59:59' ", nv[1]));
}
else if (nv[0] == "type")
{
//sb.Append(String.Format(" and type={0} ", nv[1]));
}
else if (nv[0] == "text")
{
sb.Append(" and (Name like '%" + nv[1] + "%' or Number like '%" + nv[1] + "%' or CardNum like '%" + nv[1] + "%' )");
}
}
}
}
//DataTable dt = DataFactory.SqlDataBase().GetPageLists("SELECT * FROM (SELECT Number,Phone AS CardNum,Name,Phone AS sjhm,Monery,Detail AS sm,'' as bz,wxddh,AddTime,Id,AdminHotelid FROM dbo.Finance WHERE (Type='4' or Type='41')) AS a WHERE 1=1 " + sb + " ", pqGrid_Sort, pqGrid_OrderField, pqGrid_OrderType, PageIndex, PageSize, ref totalRecords);
DataTable dt = DataFactory.SqlDataBase().DbPager("V_RechargeList", pqGrid_Sort, sb.ToString(), pqGrid_OrderField, OrderType, PageSize, PageIndex, out totalRecords);
ArrayList data = new ArrayList();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ArrayList cs = new ArrayList();
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].DataType.Name == "DateTime")
{
if (dt.Rows[i][j] != null && dt.Rows[i][j].ToString() != "")
{
cs.Add(Convert.ToDateTime(dt.Rows[i][j]).ToString("yyyy-MM-dd HH:mm"));
}
else
{
cs.Add("");
}
}
//else if (dt.Columns[j].DataType.Name == "decimal")
//{
// if (dt.Rows[i][j] != null && dt.Rows[i][j].ToString() != "")
// {
// cs.Add(Convert.ToInt32(dt.Rows[i][j]));
// }
// else
// {
// cs.Add("");
// }
//}
else
{
cs.Add(dt.Rows[i][j].ToString());
}
}
data.Add(cs);
}
}
PqGridHelper pq = new PqGridHelper();
pq.totalRecords = totalRecords;
pq.curPage = PageIndex;
pq.data = data;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(pq);
context.Response.Write(json);
}
/// <summary>
/// 获取信息列表
/// </summary>
/// <param name="context"></param>
private void GetInfoList(HttpContext context)
{
int totalRecords = 0;
int PageIndex = 1;
int PageSize = 10;
string[] Search = null;
try
{
string pqGrid_PageIndex = context.Request.QueryString["pqGrid_PageIndex"];
PageIndex = Convert.ToInt32(pqGrid_PageIndex);
string pqGrid_PageSize = context.Request.QueryString["pqGrid_PageSize"];
PageSize = Convert.ToInt32(pqGrid_PageSize);
Search = context.Request.QueryString["Search"].Split('|');//name≌value|name≌value
}
catch
{
}
string type = context.Request.QueryString["type"];
string pqGrid_OrderField = context.Request.QueryString["pqGrid_OrderField"]; //排序字段名
string pqGrid_OrderType = context.Request.QueryString["pqGrid_OrderType"]; //排序方式 asc desc
string pqGrid_Sort = context.Request.QueryString["pqGrid_Sort"]; //需要查询的字段
string pqGrid = context.Request.QueryString["_"];
if (pqGrid_OrderField == null || pqGrid_OrderField == "")//排序字段不能为空
{
pqGrid_OrderField = "addtime";
}
int OrderType = pqGrid_OrderType == "asc" ? 0 : 1;
StringBuilder sql = new StringBuilder();//统计会员卡信息
sql.AppendFormat("SELECT ISNULL(f.MemberId,0) AS MemberId,(SELECT ISNULL(SUM(Monery),0) FROM Finance WHERE Type=4 AND AdminHotelid='{0}' and 1=1 and 2=2 AND MemberId=f.MemberId) AS ljcz,(SELECT ISNULL(SUM(Monery),0) FROM Finance WHERE Type=9 AND AdminHotelid='{0}' and 1=1 and 2=2 AND MemberId=f.MemberId) AS czzs,(SELECT ISNULL(SUM(Monery),0) FROM Finance WHERE Type=2 AND AdminHotelid='{0}' and 1=1 and 2=2 AND MemberId=f.MemberId) AS ljxf FROM Finance f WHERE f.AdminHotelid='{0}' and 1=1 and 2=2 GROUP BY f.MemberId", RequestSession.GetSessionUser().AdminHotelid.ToString());
StringBuilder sb = new StringBuilder();//查询条件
if (Search != null && Search.Length > 0)
{
for (int i = 0; i < Search.Length; i++)
{
string[] nv = Search[i].Split('@');
if (nv.Length == 2)
{
if (nv[0] == "start")
{
sb.AppendFormat(" and CONVERT(varchar(100), hy.AddTime, 23)>='{0}' ", nv[1]);
}
else if (nv[0] == "end")
{
sb.AppendFormat(" and CONVERT(varchar(100), hy.AddTime, 23)<='{0}' ", nv[1]);
}
else if (nv[0] == "text")
{
sb.Append(" and (hy.xm like '%" + nv[1] + "%' or hy.kh like '%" + nv[1] + "%' or hy.sjhm like '%" + nv[1] + "%' ) ");
}
}
}
}
sb.AppendFormat(" and hy.AdminHotelid='{0}' ", RequestSession.GetSessionUser().AdminHotelid.ToString());
//会员信息
DataTable dt = DataFactory.SqlDataBase(RequestSession.GetSessionUser().AdminHotelid.ToString()).GetPageLists("SELECT hy.lsh,hy.kh,hy.xm,hy.sjhm,mb.hylxname,CONVERT(varchar(100), hy.addtime, 23) AS addtime,ISNULL(hy.hykye,0) AS hykye FROM hy_hyzlxxb hy,hy_hylxbmb mb WHERE hy.hylx=mb.hylxcode and hy.carid is not null " + sb, pqGrid_Sort, pqGrid_OrderField, pqGrid_OrderType, PageIndex, PageSize, ref totalRecords);
//会员卡信息
DataTable dts = DataFactory.SqlDataBase().GetDataTableBySQL(sql);
var reslut = (from b in dt.AsEnumerable()
join a in dts.AsEnumerable()
on new { temp = b.Field <object>("lsh").ToString() } equals new { temp = a.Field <object>("MemberId").ToString() }
into temp
from t in temp.DefaultIfEmpty()
select
new
{
kh = b.Field <object>("kh"),
xm = b.Field <object>("xm"),
sjhm = b.Field <object>("sjhm"),
hylxname = b.Field <object>("hylxname"),
addtime = b.Field <object>("addtime"),
ljcz = t == null ? 0 : t["ljcz"],
czzs = t == null ? 0 : t["czzs"],
ljxf = t == null ? 0 : t["ljxf"],
hykye = b.Field <object>("hykye"),
lsh = b.Field <object>("lsh")
}).ToList();
ArrayList data = new ArrayList();
foreach (var obj in reslut)
{
ArrayList list = new ArrayList();
list.Add(obj.kh);
list.Add(obj.xm);
list.Add(obj.sjhm);
list.Add(obj.hylxname);
list.Add(obj.addtime);
list.Add(obj.ljcz);
list.Add(obj.czzs);
list.Add(obj.ljxf);
list.Add(obj.hykye);
list.Add(obj.lsh);
data.Add(list);
}
PqGridHelper pq = new PqGridHelper();
pq.totalRecords = totalRecords;
pq.curPage = PageIndex;
pq.data = data;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(pq);
context.Response.Write(json);
}
private void GetInfoLists(HttpContext context)
{
int totalRecords = 0;
int PageIndex = 1;
int PageSize = 10;
string[] Search = null;
try
{
string pqGrid_PageIndex = context.Request.QueryString["pqGrid_PageIndex"];
PageIndex = Convert.ToInt32(pqGrid_PageIndex);
string pqGrid_PageSize = context.Request.QueryString["pqGrid_PageSize"];
PageSize = Convert.ToInt32(pqGrid_PageSize);
Search = context.Request.QueryString["Search"].Split('|');//name≌value|name≌value
}
catch
{
}
string type = context.Request.QueryString["type"];
string pqGrid_OrderField = context.Request.QueryString["pqGrid_OrderField"]; //排序字段名
string pqGrid_OrderType = context.Request.QueryString["pqGrid_OrderType"]; //排序方式 asc desc
string pqGrid_Sort = context.Request.QueryString["pqGrid_Sort"]; //需要查询的字段
string pqGrid = context.Request.QueryString["_"];
if (pqGrid_OrderField == null || pqGrid_OrderField == "")//排序字段不能为空
{
pqGrid_OrderField = "addtime";
}
int OrderType = pqGrid_OrderType == "asc" ? 0 : 1;
string lsh = context.Request["lsh"];
StringBuilder sb = new StringBuilder();//查询条件
sb.Append(" and AdminHotelid = '" + RequestSession.GetSessionUser().AdminHotelid.ToString() + "' ");
sb.Append(" and MemberId = '" + lsh + "' ");
if (Search != null && Search.Length > 0)
{
for (int i = 0; i < Search.Length; i++)
{
string[] nv = Search[i].Split('@');
if (nv.Length == 2)
{
if (nv[0] == "start")
{
sb.Append(String.Format(" and CONVERT(varchar(100), AddTime, 23)>='{0}' ", nv[1]));
}
else if (nv[0] == "end")
{
sb.Append(String.Format(" and CONVERT(varchar(100), AddTime, 23)<='{0} 23:59:59' ", nv[1]));
}
else if (nv[0] == "type")
{
sb.Append(String.Format(" and type={0} ", nv[1]));
}
else if (nv[0] == "text")
{
sb.Append(" and number like '%" + nv[1] + "%' ");
}
}
}
}
DataTable dt = DataFactory.SqlDataBase().GetPageLists("SELECT id,Number,payname,AddTime,CASE Type WHEN 4 THEN Monery WHEN 8 THEN Monery WHEN 9 THEN Monery WHEN 44 THEN Monery ELSE NULL END AS czje,CASE Type WHEN 2 THEN Monery WHEN 41 THEN Monery WHEN 42 THEN Monery WHEN 45 THEN Monery ELSE NULL END AS xfje,Detail FROM V_Finance WHERE Type IN (4,8,9,2,41,42,44,45) " + sb, pqGrid_Sort, pqGrid_OrderField, pqGrid_OrderType, PageIndex, PageSize, ref totalRecords);
ArrayList data = new ArrayList();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ArrayList cs = new ArrayList();
for (int j = 1; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].DataType.Name == "DateTime")
{
if (dt.Rows[i][j] != null && dt.Rows[i][j].ToString() != "")
{
cs.Add(Convert.ToDateTime(dt.Rows[i][j]).ToString("yyyy-MM-dd HH:mm"));
}
else
{
cs.Add("");
}
}
else
{
cs.Add(dt.Rows[i][j].ToString());
}
}
data.Add(cs);
}
}
PqGridHelper pq = new PqGridHelper();
pq.totalRecords = totalRecords;
pq.curPage = PageIndex;
pq.data = data;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(pq);
context.Response.Write(json);
}
/// <summary>
/// 操作记录
/// </summary>
/// <param name="context"></param>
private void OperationLogList(HttpContext context)
{
int totalRecords = 0;
int PageIndex = 1;
int PageSize = 10;
string[] Search = null;
try
{
string pqGrid_PageIndex = context.Request.QueryString["pqGrid_PageIndex"];
PageIndex = Convert.ToInt32(pqGrid_PageIndex);
string pqGrid_PageSize = context.Request.QueryString["pqGrid_PageSize"];
PageSize = Convert.ToInt32(pqGrid_PageSize);
Search = context.Request.QueryString["Search"].Split('|');//name≌value|name≌value
}
catch
{
}
string type = context.Request.QueryString["type"];
string pqGrid_OrderField = context.Request.QueryString["pqGrid_OrderField"]; //排序字段名
string pqGrid_OrderType = context.Request.QueryString["pqGrid_OrderType"]; //排序方式 asc desc
string pqGrid_Sort = context.Request.QueryString["pqGrid_Sort"]; //需要查询的字段
string pqGrid = context.Request.QueryString["_"];
if (pqGrid_OrderField == null || pqGrid_OrderField == "")//排序字段不能为空
{
pqGrid_OrderField = "OperationDate";
}
int OrderType = pqGrid_OrderType == "asc" ? 0 : 1;
string AdminHotelid = RequestSession.GetSessionUser().AdminHotelid.ToString();
StringBuilder sb = new StringBuilder();//查询条件
sb.Append(" 1 = 1 ");
if (Search != null && Search.Length > 0)
{
for (int i = 0; i < Search.Length; i++)
{
string[] nv = Search[i].Split('@');
if (nv.Length == 2)
{
if (nv[0] == "text")
{
sb.AppendFormat(" AND Remarks like '%{0}%'", nv[1]);
}
if (nv[0] == "openid")
{
sb.AppendFormat(" AND OpenId = '{0}'", nv[1]);
}
}
}
}
DataTable dt = DataFactory.SqlDataBase().DbPager("MemberOperationLog", pqGrid_Sort, sb.ToString(), pqGrid_OrderField, OrderType, PageSize, PageIndex, out totalRecords);
ArrayList data = new ArrayList();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ArrayList cs = new ArrayList();
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].DataType.Name == "DateTime")
{
if (dt.Rows[i][j] != null && dt.Rows[i][j].ToString() != "")
{
cs.Add(Convert.ToDateTime(dt.Rows[i][j]).ToString("yyyy-MM-dd HH:mm"));
}
else
{
cs.Add("");
}
}
else
{
cs.Add(dt.Rows[i][j].ToString());
}
}
data.Add(cs);
}
}
PqGridHelper pq = new PqGridHelper();
pq.totalRecords = totalRecords;
pq.curPage = PageIndex;
pq.data = data;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(pq);
context.Response.Write(json);
}
/// <summary>
/// 积分记录
/// </summary>
/// <param name="context"></param>
private void GetIntegraList(HttpContext context)
{
int totalRecords = 0;
int PageIndex = 1;
int PageSize = 10;
string[] Search = null;
try
{
string pqGrid_PageIndex = context.Request.QueryString["pqGrid_PageIndex"];
PageIndex = Convert.ToInt32(pqGrid_PageIndex);
string pqGrid_PageSize = context.Request.QueryString["pqGrid_PageSize"];
PageSize = Convert.ToInt32(pqGrid_PageSize);
Search = context.Request.QueryString["Search"].Split('|');//name≌value|name≌value
}
catch
{
}
string type = context.Request.QueryString["type"];
string pqGrid_OrderField = context.Request.QueryString["pqGrid_OrderField"]; //排序字段名
string pqGrid_OrderType = context.Request.QueryString["pqGrid_OrderType"]; //排序方式 asc desc
string pqGrid_Sort = context.Request.QueryString["pqGrid_Sort"]; //需要查询的字段
string pqGrid = context.Request.QueryString["_"];
if (pqGrid_OrderField == null || pqGrid_OrderField == "")//排序字段不能为空
{
pqGrid_OrderField = "czrq";
}
int OrderType = pqGrid_OrderType == "asc" ? 0 : 1;
string AdminHotelid = RequestSession.GetSessionUser().AdminHotelid.ToString();
StringBuilder sb = new StringBuilder();//查询条件
sb.Append(@"
SELECT b.lsh ,
b.kh ,
b.xm ,
b.sjhm ,
a.zmsm ,
a.czrq ,
a.jf ,
a.bz
FROM HY_HYXFJLB a
LEFT JOIN hy_hyzlxxb b ON a.lsh = b.lsh
WHERE jf <> 0
");
IList <SqlParam> ilParams = new List <SqlParam>();
if (Search != null && Search.Length > 0)
{
for (int i = 0; i < Search.Length; i++)
{
string[] nv = Search[i].Split('@');
if (nv.Length == 2)
{
if (nv[0] == "text")
{
sb.AppendFormat(" AND a.bz like @bz", nv[1]);
ilParams.Add(new SqlParam("@bz", "%" + nv[1] + "%"));
}
if (nv[0] == "lsh")
{
sb.AppendFormat(" AND b.lsh = @lsh", nv[1]);
ilParams.Add(new SqlParam("@lsh", nv[1]));
}
}
}
}
SqlParam[] param = ilParams.ToArray();
//ORDER BY czrq DESC
//会员信息
DataTable dt = DataFactory.SqlDataBase(AdminHotelid).GetPageList(sb.ToString(), param, pqGrid_OrderField, pqGrid_OrderType, PageIndex, PageSize, ref totalRecords);
ArrayList data = new ArrayList();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ArrayList cs = new ArrayList();
for (int j = 1; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].DataType.Name == "DateTime")
{
if (dt.Rows[i][j] != null && dt.Rows[i][j].ToString() != "")
{
cs.Add(Convert.ToDateTime(dt.Rows[i][j]).ToString("yyyy-MM-dd HH:mm"));
}
else
{
cs.Add("");
}
}
else
{
cs.Add(dt.Rows[i][j].ToString());
}
}
data.Add(cs);
}
}
PqGridHelper pq = new PqGridHelper();
pq.totalRecords = totalRecords;
pq.curPage = PageIndex;
pq.data = data;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(pq);
context.Response.Write(json);
}
private void GetRoleList(HttpContext context)
{
if (RequestSession.GetSessionUser() == null)
{
context.Response.Write("");
return;
}
int totalRecords = 0;
int PageIndex = 1;
int PageSize = 10;
string[] Search = null;
try
{
string pqGrid_PageIndex = context.Request.QueryString["pqGrid_PageIndex"];
PageIndex = Convert.ToInt32(pqGrid_PageIndex);
string pqGrid_PageSize = context.Request.QueryString["pqGrid_PageSize"];
PageSize = Convert.ToInt32(pqGrid_PageSize);
Search = context.Request.QueryString["Search"].Split('|');//name@value|name@value
}
catch
{
}
string type = context.Request.QueryString["type"];
string pqGrid_OrderField = context.Request.QueryString["pqGrid_OrderField"]; //排序字段名
string pqGrid_OrderType = context.Request.QueryString["pqGrid_OrderType"]; //排序方式 asc desc
string pqGrid_Sort = context.Request.QueryString["pqGrid_Sort"]; //需要查询的字段
string pqGrid = context.Request.QueryString["_"];
if (pqGrid_OrderField == null || pqGrid_OrderField == "")//排序字段不能为空
{
pqGrid_OrderField = "SortCode";
}
int OrderType = pqGrid_OrderType == "asc" ? 1 : 0;
StringBuilder sb = new StringBuilder();//查询条件
sb.Append(" DeleteMark = 1 ");
if (Search != null && Search.Length > 0)
{
for (int i = 0; i < Search.Length; i++)
{
string[] nv = Search[i].Split('@');
if (nv.Length == 2)
{
if (nv[0] == "SearchText")
{
sb.Append(" and (Roles_Name like '%" + nv[1] + "%') ");
}
else
{
sb.Append(" and " + nv[0] + " = '" + nv[1] + "' ");
}
}
}
}
DataTable dt = DataFactory.SqlDataBase().DbPager("Base_Roles", pqGrid_Sort, sb.ToString(), pqGrid_OrderField, OrderType, PageSize, PageIndex, out totalRecords);
ArrayList data = new ArrayList();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ArrayList cs = new ArrayList();
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].DataType.Name == "DateTime")
{
cs.Add(Convert.ToDateTime(dt.Rows[i][j]).ToString("yyyy-MM-dd HH:mm:ss"));
}
else
{
cs.Add(dt.Rows[i][j].ToString());
}
}
data.Add(cs);
}
}
PqGridHelper pq = new PqGridHelper();
pq.totalRecords = totalRecords;
pq.curPage = PageIndex;
pq.data = data;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(pq);
context.Response.Write(json);
}
/// <summary>
/// 获取信息列表
/// </summary>
/// <param name="context"></param>
private void GetInfoList(HttpContext context)
{
int totalRecords = 0;
int PageIndex = 1;
int PageSize = 10;
string[] Search = null;
try
{
string pqGrid_PageIndex = context.Request.QueryString["pqGrid_PageIndex"];
PageIndex = Convert.ToInt32(pqGrid_PageIndex);
string pqGrid_PageSize = context.Request.QueryString["pqGrid_PageSize"];
PageSize = Convert.ToInt32(pqGrid_PageSize);
Search = context.Request.QueryString["Search"].Split('|');//name≌value|name≌value
}
catch
{
}
string type = context.Request.QueryString["type"];
string pqGrid_OrderField = context.Request.QueryString["pqGrid_OrderField"]; //排序字段名
string pqGrid_OrderType = context.Request.QueryString["pqGrid_OrderType"]; //排序方式 asc desc
string pqGrid_Sort = context.Request.QueryString["pqGrid_Sort"]; //需要查询的字段
string pqGrid = context.Request.QueryString["_"];
if (pqGrid_OrderField == null || pqGrid_OrderField == "")//排序字段不能为空
{
pqGrid_OrderField = "EffectiveDateTime";
}
int OrderType = pqGrid_OrderType == "asc" ? 0 : 1;
StringBuilder sb = new StringBuilder();//查询条件
sb.Append(" AdminHotelid = '" + RequestSession.GetSessionUser().AdminHotelid.ToString() + "' ");
sb.Append(" and AdminHotelid='" + RequestSession.GetSessionUser().AdminHotelid.ToString() + "' ");
if (Search != null && Search.Length > 0)
{
for (int i = 0; i < Search.Length; i++)
{
string[] nv = Search[i].Split('≌');
if (nv.Length == 2)
{
var cs = "@obj" + i;
if (nv[0] == "number")
{
sb.Append(" and (ordernum like '%" + nv[1] + "%' or couponname like '%" + nv[1] + "%')");
}
else
{
sb.Append(" and (" + nv[0] + " = '" + nv[1] + "' or isReceive ='" + nv[1] + "') ");
}
}
}
}
DataTable dt = DataFactory.SqlDataBase().DbPager("v_ClientCoupon", pqGrid_Sort, sb.ToString(), pqGrid_OrderField, OrderType, PageSize, PageIndex, out totalRecords);
IList <SqlParam> IList_param = new List <SqlParam>();
ArrayList data = new ArrayList();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ArrayList cs = new ArrayList();
for (int j = 1; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].DataType.Name == "DateTime")
{
if (dt.Rows[i][j] != null && dt.Rows[i][j].ToString() != "")
{
cs.Add(Convert.ToDateTime(dt.Rows[i][j]).ToString("yyyy-MM-dd HH:mm"));
}
else
{
cs.Add("");
}
}
else
{
cs.Add(dt.Rows[i][j].ToString());
}
}
data.Add(cs);
}
}
PqGridHelper pq = new PqGridHelper();
pq.totalRecords = totalRecords;
pq.curPage = PageIndex;
pq.data = data;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(pq);
context.Response.Write(json);
}
/// <summary>
/// 获取信息列表
/// </summary>
/// <param name="context"></param>
private void GetPreferentialType(HttpContext context)
{
int totalRecords = 0;
int PageIndex = 1;
int PageSize = 10;
string[] Search = null;
try
{
string pqGrid_PageIndex = context.Request.QueryString["pqGrid_PageIndex"];
PageIndex = Convert.ToInt32(pqGrid_PageIndex);
string pqGrid_PageSize = context.Request.QueryString["pqGrid_PageSize"];
PageSize = Convert.ToInt32(pqGrid_PageSize);
Search = context.Request.QueryString["Search"].Split('|');//name≌value|name≌value
}
catch
{
}
string type = context.Request.QueryString["type"];
string pqGrid_OrderField = context.Request.QueryString["pqGrid_OrderField"]; //排序字段名
string pqGrid_OrderType = context.Request.QueryString["pqGrid_OrderType"]; //排序方式 asc desc
string pqGrid_Sort = context.Request.QueryString["pqGrid_Sort"]; //需要查询的字段
string pqGrid = context.Request.QueryString["_"];
if (pqGrid_OrderField == null || pqGrid_OrderField == "")//排序字段不能为空
{
pqGrid_OrderField = "Id";
}
int OrderType = pqGrid_OrderType == "asc" ? 0 : 1;
StringBuilder sb = new StringBuilder();//查询条件
sb.Append(" 1 = 1 ");
if (Search != null && Search.Length > 0)
{
for (int i = 0; i < Search.Length; i++)
{
string[] nv = Search[i].Split('≌');
if (nv.Length == 2)
{
var cs = "@obj" + i;
if (nv[0] == "number")
{
sb.Append(" and (TypeName like '%" + nv[1] + "%')");
}
else
{
sb.Append(" and (" + nv[0] + " = '" + nv[1] + "') ");
}
}
}
}
IList <SqlParam> IList_param = new List <SqlParam>();
DataTable dt = DataFactory.SqlDataBase().GetPageList("SELECT id,TypeName FROM PreferentialType where " + sb, IList_param.ToArray(), pqGrid_OrderField, "desc", PageIndex, PageSize, ref totalRecords);
ArrayList data = new ArrayList();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ArrayList cs = new ArrayList();
for (int j = 1; j < dt.Columns.Count; j++)
{
cs.Add(dt.Rows[i][j].ToString());
}
data.Add(cs);
}
}
PqGridHelper pq = new PqGridHelper();
pq.totalRecords = totalRecords;
pq.curPage = PageIndex;
pq.data = data;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(pq);
context.Response.Write(json);
}
/// <summary>
/// 获取信息列表
/// </summary>
/// <param name="context"></param>
private void GetBookOrderList(HttpContext context)
{
if (RequestSession.GetSessionUser() == null)
{
context.Response.Write("");
return;
}
int totalRecords = 0;
int PageIndex = 1;
int PageSize = 10;
string hotelid = context.Request.QueryString["hotelid"];
string type = context.Request.QueryString["type"];
string start = context.Request.QueryString["start"];
string end = context.Request.QueryString["end"];
string content = context.Request.QueryString["content"];
try
{
string pqGrid_PageIndex = context.Request.QueryString["pqGrid_PageIndex"];
PageIndex = Convert.ToInt32(pqGrid_PageIndex);
string pqGrid_PageSize = context.Request.QueryString["pqGrid_PageSize"];
PageSize = Convert.ToInt32(pqGrid_PageSize);
}
catch
{
}
string pqGrid_OrderField = context.Request.QueryString["pqGrid_OrderField"]; //排序字段名
string pqGrid_OrderType = context.Request.QueryString["pqGrid_OrderType"]; //排序方式 asc desc
string pqGrid_Sort = context.Request.QueryString["pqGrid_Sort"]; //需要查询的字段
string pqGrid = context.Request.QueryString["_"];
if (pqGrid_OrderField == null || pqGrid_OrderField == "")//排序字段不能为空
{
pqGrid_OrderField = "Sort";
}
int OrderType = pqGrid_OrderType == "asc" ? 0 : 1;
StringBuilder sb = new StringBuilder();//查询条件
sb.Append(" 1 = 1 and DeleteMark=1 ");
sb.Append(" and AdminHotelid='" + RequestSession.GetSessionUser().AdminHotelid.ToString() + "' ");
if (hotelid != null && hotelid != "")
{
sb.Append(" and HotelId='" + hotelid + "' ");
}
if (type != null && type != "-1")
{
sb.Append(" and BusinessId='" + type + "' ");
}
if (start != null && start != "" && end != null && end != "")
{
string sql = end + " 23:59:59";
sb.AppendFormat(" and OrderTime>='{0} 00:00:00' and OrderTime<='{1}'", start, sql);
}
else
{
if (start != null && start != "")
{
sb.AppendFormat(" and OrderTime>='{0} 00:00:00'", start);
}
else if (end != null && end != "")
{
sb.AppendFormat("and OrderTime<='{0} 23:59:59'", end);
}
}
if (content != "" && content != null)
{
sb.AppendFormat(" and (OrderNumber like '{0}' or BusinessName like '{0}' or Contact like '{0}' or ContactPhone like '{0}' or Address like '{0}' )", "%" + content + "%");
}
DataTable dt = DataFactory.SqlDataBase().DbPager("V_BookOrder", pqGrid_Sort, sb.ToString(), pqGrid_OrderField, OrderType, PageSize, PageIndex, out totalRecords);
ArrayList data = new ArrayList();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ArrayList cs = new ArrayList();
for (int j = 1; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].DataType.Name == "DateTime")
{
cs.Add(Convert.ToDateTime(dt.Rows[i][j]).ToString("yyyy-MM-dd"));
}
else
{
cs.Add(dt.Rows[i][j].ToString());
}
}
data.Add(cs);
}
}
PqGridHelper pq = new PqGridHelper();
pq.totalRecords = totalRecords;
pq.curPage = PageIndex;
pq.data = data;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(pq);
context.Response.Write(json);
}
/// <summary>
/// 获取信息列表
/// </summary>
/// <param name="context"></param>
private void GetBookTypeList(HttpContext context)
{
if (RequestSession.GetSessionUser() == null)
{
context.Response.Write("");
return;
}
int totalRecords = 0;
int PageIndex = 1;
int PageSize = 10;
string[] Search = null;
try
{
string pqGrid_PageIndex = context.Request.QueryString["pqGrid_PageIndex"];
PageIndex = Convert.ToInt32(pqGrid_PageIndex);
string pqGrid_PageSize = context.Request.QueryString["pqGrid_PageSize"];
PageSize = Convert.ToInt32(pqGrid_PageSize);
Search = context.Request.QueryString["Search"].Split('|');//name@value|name@value
}
catch
{
}
string hotelid = context.Request.QueryString["hotelid"];
string content = context.Request.QueryString["content"];
string pqGrid_OrderField = context.Request.QueryString["pqGrid_OrderField"]; //排序字段名
string pqGrid_OrderType = context.Request.QueryString["pqGrid_OrderType"]; //排序方式 asc desc
string pqGrid_Sort = context.Request.QueryString["pqGrid_Sort"]; //需要查询的字段
string pqGrid = context.Request.QueryString["_"];
if (pqGrid_OrderField == null || pqGrid_OrderField == "")//排序字段不能为空
{
pqGrid_OrderField = "Sort";
}
int OrderType = pqGrid_OrderType == "asc" ? 0 : 1;
StringBuilder sb = new StringBuilder();//查询条件
sb.Append(" 1 = 1 and DeleteMark=1 ");
sb.Append(" and AdminHotelid='" + RequestSession.GetSessionUser().AdminHotelid.ToString() + "' ");
if (hotelid != null && hotelid != "")
{
sb.Append(" and hotelid='" + hotelid + "' ");
}
if (content != "" && content != null)
{
sb.AppendFormat(" and (TypeName like '{0}' or Instructions like '{0}' )", "%" + content + "%");
}
DataTable dt = DataFactory.SqlDataBase().DbPager("V_BookType", pqGrid_Sort, sb.ToString(), pqGrid_OrderField, OrderType, PageSize, PageIndex, out totalRecords);
ArrayList data = new ArrayList();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ArrayList cs = new ArrayList();
for (int j = 1; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].DataType.Name == "DateTime")
{
cs.Add(Convert.ToDateTime(dt.Rows[i][j]).ToString("yyyy-MM-dd"));
}
else
{
cs.Add(dt.Rows[i][j].ToString());
}
}
data.Add(cs);
}
}
PqGridHelper pq = new PqGridHelper();
pq.totalRecords = totalRecords;
pq.curPage = PageIndex;
pq.data = data;
string json = Newtonsoft.Json.JsonConvert.SerializeObject(pq);
context.Response.Write(json);
}
