/// <summary>
/// 获取基础数据
/// </summary>
/// <returns></returns>
public string getData()
{
regionId = Convert.ToInt32(Request["regionId"]);
string search = "";
StringBuilder strb = new StringBuilder();
string op = Request["op"];
if (regionId > 0)
{
if (user.RoleId.RoleName == "超级管理员")
{
search = " and regionId=" + regionId;
region = regionBll.selectById(regionId);
kinds = repBll.getMonkinds(regionId, 0);
counts = repBll.getTotalMon(regionId, 0);
}
}
else
{
if (user.RoleId.RoleName == "超级管理员")
{
search = "";
counts = 0;
kinds = 0;
region = "";
}
else
{
regionId = user.ReginId.RegionId;
search = " and regionId=" + regionId;
kinds = repBll.getMonkinds(regionId, 0);
counts = repBll.getTotalMon(regionId, 0);
region = regionBll.selectById(regionId);
}
}
//获取分页数据
int currentPage = Convert.ToInt32(Request["page"]);
if (currentPage == 0)
{
currentPage = 1;
}
TableBuilder tb = new TableBuilder();
tb.StrTable = "V_ReplenishMentMononer";
tb.OrderBy = "rsMononerID";
tb.StrColumnlist = "regionName,customerName,rsMononerID,bookNum,ISBN,bookName,sum(count) as count,dateTime";
tb.IntPageSize = pageSize;
tb.IntPageNum = currentPage;
tb.StrWhere = "ISNULL(finishTime) and deleteState=0" + search + " group by regionName,customerName,rsMononerID,bookNum,ISBN,bookName";
//获取展示的客户数据
ds = saleBll.selectBypage(tb, out totalCount, out intPageCount);
//生成table
strb.Append("<tbody>");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
strb.Append("<tr><td>" + (i + 1 + ((currentPage - 1) * pageSize)) + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["ISBN"].ToString() + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["bookNum"].ToString() + "</td>");
strb.Append("<td><nobr>" + ds.Tables[0].Rows[i]["bookName"].ToString() + "</nobr></td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["count"].ToString() + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["customerName"].ToString() + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["regionName"].ToString() + "</td>");
strb.Append("<td><nobr>" + Convert.ToDateTime(ds.Tables[0].Rows[i]["dateTime"].ToString()).ToString("yyyy/MM/dd") + "</nobr></td></tr>");
}
strb.Append("<input type='hidden' value='" + intPageCount + "' id='intPageCount' />");
strb.Append("</tbody>");
if (op == "paging")
{
Response.Write(strb.ToString() + ":|" + kinds + ":|" + counts + ":|" + region);
Response.End();
}
return(strb.ToString());
}
public void ProcessRequest(HttpContext context)
{
string op = context.Request["op"];
if (op == "isbn")
{
isbn(context);
}
if (op == "choose")
{
choose(context);
}
if (op == "bookNum")
{
bookNum(context);
}
if (op == "insert")
{
insert(context);
}
if (op == "openid")
{
openid(context);
}
if (op == "checkDetail")
{
checkDetail(context);
}
if (op == "del")
{
del(context);
}
if (op == "regionSubmit")
{
string userId = context.Request["userId"];
Result isUser = userBll.isUser(userId);
int regionId = Convert.ToInt32(userId.Substring(0, userId.Length - 2));
string regionName = regionBll.selectById(regionId);
if (isUser == Result.记录不存在)
{
retailM.type = "未查询到相关组织信息";
string json = JsonHelper.JsonSerializerBySingleData(retailM);
context.Response.Write(json);
context.Response.End();
}
else
{
retailM.type = "成功";
retailM.userid = userId;
retailM.regionId = regionId.ToString();
retailM.regionName = regionName;
string json = JsonHelper.JsonSerializerBySingleData(retailM);
context.Response.Write(json);
context.Response.End();
}
}
if (op == "getOpenid")
{
getOponid(context);
}
}
