protected void Page_Load(object sender, EventArgs e)
{
User user = (User)Session["user"];
userName = user.UserName;
regionName = user.ReginId.RegionName;
string op = Request["op"];
if (op == "paging")
{
getData();
}
if (op == "exportAll")
{
//export();
exportAll();
}
if (op == "exportDe")
{
//exportDe();
exportDetail();
}
else
{
permission();
//获取供应商
dsSupplier = bookBll.selectSupplier();
//获取组织
dsRegion = regionBll.select();
//获取客户
dsCustom = customBll.select();
}
if (op == "logout")
{
//删除身份凭证
FormsAuthentication.SignOut();
//设置Cookie的值为空
Response.Cookies[FormsAuthentication.FormsCookieName].Value = null;
//设置Cookie的过期时间为上个月今天
Response.Cookies[FormsAuthentication.FormsCookieName].Expires = DateTime.Now.AddMonths(-1);
}
if (op == "print")
{
Response.Write(print());
Response.End();
}
}
/// <summary>
/// 获取基础数据及查询方法
/// </summary>
public string getData()
{
User user = (User)Session["user"];
int regionId = user.ReginId.RegionId;
string roleName = user.RoleId.RoleName;
//获取分页数据
int currentPage = Convert.ToInt32(Request["page"]);
if (currentPage == 0)
{
currentPage = 1;
}
string search = Request["search"];
if (search == "" || search == null)
{
if (roleName == "超级管理员")
{
search = "deleteState=0";
}
else
{
search = "deleteState=0 and regionId=" + regionId;
}
}
else
{
if (roleName == "超级管理员")
{
search = String.Format(" saleTaskId {0} or userName {0} or customerName {0} and deleteState=0 ", "like '%" + search + "%'");
}
else
{
search = String.Format(" saleTaskId {0} or userName {0} or customerName {0} and deleteState=0 and regionId=" + regionId, "like '%" + search + "%'");
}
}
TableBuilder tb = new TableBuilder();
tb.StrTable = "V_SaleTask";
tb.OrderBy = "startTime desc";
tb.StrColumnlist = "saleTaskId,defaultDiscount,defaultCopy,priceLimit,numberLimit,totalPriceLimit,startTime,finishTime,userId,userName,customerName,regionId";
tb.IntPageSize = pageSize;
tb.IntPageNum = currentPage;
tb.StrWhere = search;
//获取展示的客户数据
ds = saleBll.selectBypage(tb, out totalCount, out intPageCount);
//获取客户下拉数据
customerds = custBll.select();
//生成table
StringBuilder strb = new StringBuilder();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string time = ds.Tables[0].Rows[i]["finishTime"].ToString();
if (time == "" || time == null)
{
time = "销售任务采集中";
}
strb.Append("<tr><td>" + ds.Tables[0].Rows[i]["saleTaskId"].ToString() + "</td>");
strb.Append("<td><nobr>" + ds.Tables[0].Rows[i]["customerName"].ToString() + "</nobr></td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["userName"].ToString() + "</td>");
string defaultDiscount = ds.Tables[0].Rows[i]["defaultDiscount"].ToString();
if (defaultDiscount == "-1")
{
defaultDiscount = "";
}
strb.Append("<td>" + defaultDiscount + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["numberLimit"].ToString() + "</td>");
strb.Append("<td>" + ds.Tables[0].Rows[i]["defaultCopy"].ToString() + "</td>");
strb.Append("<td>" + (ds.Tables[0].Rows[i]["priceLimit"].ToString() + ".00") + "</td>");
strb.Append("<td><nobr>" + ds.Tables[0].Rows[i]["startTime"].ToString() + "</nobr></td>");
strb.Append("<td><nobr>" + time + "</nobr></td>");
strb.Append("<td style='width:100px;'>" + "<button class='btn btn-success btn-sm btn_sale'>销售</button>");
strb.Append("<button class='btn btn-success btn-sm btn_back'>销退</button></td>");
strb.Append("<td><button class='btn btn-success btn-sm btn_search'>查看</button> <button class='btn btn-sm btn-success edited' value='" + ds.Tables[0].Rows[i]["totalPriceLimit"].ToString() + "' >编辑</button>");
strb.Append("<button class='btn btn-danger btn-sm btn_del'><i class='fa fa-trash'></i></button>" + "</td></tr>");
}
strb.Append("<input type='hidden' value='" + intPageCount + "' id='intPageCount' />");
string op = Request["op"];
if (op == "paging")
{
Response.Write(strb.ToString());
Response.End();
}
return(strb.ToString());
}