|
Server : Microsoft-IIS/10.0 System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586 User : jxgj ( 0) PHP Version : 7.0.33 Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server Directory : D:/tmp_aspnet/root/c7cbaa85/f3ad987/ |
?#pragma checksum "D:\wwwroot\kefucrm\wwwroot\Manager_Customer.aspx.cs" "{ff1816ec-aa5e-4d10-87f7-6f4963833460}" "9637D499FF1693A6D36D4FC6ADBCBD47E7B906F7"
#line 1 "D:\wwwroot\kefucrm\wwwroot\Manager_Customer.aspx.cs"
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Text;
public partial class Manager_Customer : System.Web.UI.Page
{
public Company company = new Company();
public int i_userid = 0;
public int currentPage = 1, pageSize = 12, allNum = 0;
public StringBuilder sb = new StringBuilder();
public string strTitle = "",strAction="";
public string rank = string.Empty, selecttype = string.Empty, selectvalue = string.Empty,selectTypeName=string.Empty;
private Staff doStaff = null;
List<Staff> listStaff = null;
int i = 0;
protected void Page_Load(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(Request.QueryString["class"]))
{
rank = Sun_KY.SqlAccess.ClearInputString(Request.QueryString["class"], Request.QueryString["class"].Length);
if (rank != "E" && rank != "0")
{
strTitle = rank + "类客户";
}
else if (rank == "0")
{
strTitle = "公？突";
}
else
{
strTitle = "成交客户";
}
strAction = "normal";
}
if (!String.IsNullOrEmpty(Request.QueryString["selecttype"]))
{
selecttype = Sun_KY.SqlAccess.ClearInputString(Request.QueryString["selecttype"], Request.QueryString["selecttype"].Length);
switch (selecttype)
{
case "username":
selectTypeName = "用户名";
break;
case "tel":
selectTypeName = "移动电话";
break;
case "phone":
selectTypeName = "固定电话";
break;
case "danwei":
selectTypeName = "单元名称";
break;
}
}
if (!String.IsNullOrEmpty(Request.QueryString["selectvalue"]))
{
selectvalue = Sun_KY.SqlAccess.ClearInputString(Request.QueryString["selectvalue"], Request.QueryString["selectvalue"].Length);
}
if (!String.IsNullOrEmpty(Request.QueryString["page"]))
{
currentPage = Convert.ToInt32(Request.QueryString["page"]);
}
if (Request.Cookies["sunid"] != null)
{
string strUserID = Request.Cookies["sunid"].Value.ToString();
string _userid = Microsoft.JScript.GlobalObject.unescape(strUserID);
_userid = _userid.Replace("%3D", "=");
string decry_userid = Sun_Encrypt.AESDecrypt(_userid);
if (SunFunction.IsNumber(decry_userid))
{
i_userid = Convert.ToInt32(decry_userid);
try
{
doStaff = new Staff(i_userid);
company = new Company(doStaff.companyid);
listStaff = Staff.GetStaffByCid(doStaff.companyid);
if (rank.Length > 0)
{
//BindData(rank, i_userid, currentPage, pageSize);
}
else if (selecttype.Length > 0 && selectvalue.Length > 0)
{
strTitle = "查找客户：按" + selectTypeName + "查找" + selectvalue;
// BindSelectData(selecttype,selectvalue, i_userid, currentPage, pageSize);
}
}
catch (Exception ex)
{
Sun_KY.SqlAccess.h(ex.Message);
}
}
else
{
Response.Write("解密不为数字");
}
// BindResume(_id, userid);
}
else
{
Response.Write("获取用户信息失败，请沉新登陆");
}
}
public string GetOrder()
{
return (++i).ToString();
}
public string showBeiZhu(object ob)
{
string rt = string.Empty;
if (ob != DBNull.Value && ob.ToString().Trim().Length > 0)
{
rt = "<a href='javascript:void(0)' onclick='beizhu_customer(\"" + ob.ToString() + "\")'>备注</a> ";
}
return rt;
}
public string CustomerButton(int customerid)
{
string rt = string.Empty;
Customer customer=new Customer(customerid);
string strBtnEditCustomer = "<a href='javascript:void(0)' onclick='edit_customer(" + customerid.ToString() + ")'>批改资料</a>";
string strBtnDelCustomer = "<a href='javascript:void(0)' onclick='del_customer(" + customerid.ToString() + ")'>删除客户</a>";
string strBtnAddOrders = "<a href='javascript:void(0)' onclick='add_orders(" + customerid.ToString() + ")'>提交订单</a>";
string strBtnTelRecords = "<a href='javascript:void(0)' onclick='add_tel_records(" + customerid.ToString() + ")'>新增纪录</a>";
string strBtnApplyCustomer = "<a href='javascript:void(0)' onclick='apply_customer(" + customerid.ToString() + ")'>申请客户</a>";
string strBtnEditCustomerRank = "<a href='javascript:void(0)' onclick='edit_customerrank(" + customerid.ToString() + ")'>批改类型</a>";
string strBtnShowOrders = "<a href='javascript:void(0)' onclick='show_orders(" + customerid.ToString() + ")'>显示订单</a>";
if (customer.rank.Equals("0"))
{
if (doStaff.manager == 1)
{
rt = strBtnApplyCustomer + strBtnEditCustomer + strBtnDelCustomer;
}
else
{
rt = strBtnApplyCustomer;
}
}
else
{
if (doStaff.manager == 1)
{
if (customer.rank.Equals("E"))
{
rt = strBtnEditCustomer + strBtnShowOrders + strBtnEditCustomerRank + strBtnAddOrders + strBtnTelRecords;
}
else
{
rt = strBtnEditCustomer + strBtnDelCustomer + strBtnEditCustomerRank + strBtnAddOrders + strBtnTelRecords;
}
}
else
{
if (rank != "E")
{
rt = strBtnEditCustomer + strBtnEditCustomerRank + strBtnTelRecords + strBtnAddOrders;
}
else
{
rt = strBtnShowOrders;
}
}
}
return rt;
}
public string GetRank(string rank)
{
string rt = string.Empty;
if(rank.Equals("0"))
{
rt = "公？突";
}
else if (rank.Equals("E"))
{
rt = "成交客户";
}
else
{
rt = rank;
}
return rt;
}
public string GetUserName(int userid)
{
string rt = string.Empty;
if (userid.Equals(0))
{
rt = "公？突";
}
else
{
for (int i = 0; i < listStaff.Count; i++)
{
if (listStaff[i].userid == userid)
{
rt = listStaff[i].username;
break;
}
}
}
return rt;
}
private void BindSelectData(string selecttype,string selectvalue, int userid, int currentpage, int pagesize)
{
SqlDataReader dr = null;
try
{
using (SqlConnection conn = new SqlConnection(Sun_KY.SqlAccess.ConnectionString))
{
string sql = "sjm_SelectCustomer";
SqlParameter[] sp = new SqlParameter[6];
sp[0] = new SqlParameter("@selecttype", SqlDbType.NVarChar, 20);
sp[0].Value = selecttype;
sp[1] = new SqlParameter("@selectvalue", SqlDbType.NVarChar, 30);
sp[1].Value = selectvalue;
sp[2] = new SqlParameter("@userid", SqlDbType.Int);
sp[2].Value = userid;
sp[3] = new SqlParameter("@currentpage", SqlDbType.Int);
sp[3].Value = currentpage;
sp[4] = new SqlParameter("@pagesize", SqlDbType.Int);
sp[4].Value = pagesize;
sp[5] = new SqlParameter("@allnum", SqlDbType.Int);
sp[5].Direction = ParameterDirection.Output;
SqlCommand cmd = new SqlCommand();
if (conn.State != ConnectionState.Open)
conn.Open();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(sp[0]);
cmd.Parameters.Add(sp[1]);
cmd.Parameters.Add(sp[2]);
cmd.Parameters.Add(sp[3]);
cmd.Parameters.Add(sp[4]);
cmd.Parameters.Add(sp[5]);
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
Repeater1.DataSource = dr;
Repeater1.DataBind();
}
dr.Close();
if (cmd.Parameters["@allnum"].Value != DBNull.Value)
{
allNum = Convert.ToInt32(cmd.Parameters["@allnum"].Value);
BindNav(currentpage, pagesize, allNum);
}
cmd.Parameters.Clear();
cmd.Dispose();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void BindData(string rank, int userid, int currentpage, int pagesize)
{
SqlDataReader dr = null;
try
{
using (SqlConnection conn = new SqlConnection(Sun_KY.SqlAccess.ConnectionString))
{
string sql = "sjm_GetABCCustomer";
SqlParameter[] sp = new SqlParameter[5];
sp[0] = new SqlParameter("@rank", SqlDbType.NVarChar, 10);
sp[0].Value = rank;
sp[1] = new SqlParameter("@userid", SqlDbType.Int);
sp[1].Value = userid;
sp[2] = new SqlParameter("@currentpage", SqlDbType.Int);
sp[2].Value = currentpage;
sp[3] = new SqlParameter("@pagesize", SqlDbType.Int);
sp[3].Value = pagesize;
sp[4] = new SqlParameter("@allnum", SqlDbType.Int);
sp[4].Direction = ParameterDirection.Output;
SqlCommand cmd = new SqlCommand();
if (conn.State != ConnectionState.Open)
conn.Open();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(sp[0]);
cmd.Parameters.Add(sp[1]);
cmd.Parameters.Add(sp[2]);
cmd.Parameters.Add(sp[3]);
cmd.Parameters.Add(sp[4]);
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
Repeater1.DataSource = dr;
Repeater1.DataBind();
}
dr.Close();
if (cmd.Parameters["@allnum"].Value != DBNull.Value)
{
allNum = Convert.ToInt32(cmd.Parameters["@allnum"].Value);
BindNav(currentpage, pagesize, allNum);
}
cmd.Parameters.Clear();
cmd.Dispose();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void BindNav(int currentpage, int pagesize, int allnum)
{
int i = 0;
int allpage = 0;
if (allnum % pagesize == 0)
{
allpage = allnum / pagesize;
}
else
{
allpage = allnum / pagesize + 1;
}
if (currentpage > 1)
{
if (rank.Length != 0)
{
sb.Append("<li><a href='Manager_Customer.aspx?class=" + rank + "&page=1'>首页</a></li>");
}
else
{
sb.Append("<li><a href='Manager_Customer.aspx?selecttype="+selecttype+"&selectvalue="+selectvalue+"&page=1'>首页</a></li>");
}
}
string activeCss = "";
for (i = currentpage - 5; i <= currentpage; i++)
{
if (i > 0)
{
if (i == currentpage)
{
activeCss = " class='active'";
}
if (rank.Length != 0)
{
sb.Append("<li" + activeCss + "><a href='Manager_Customer.aspx?class=" + rank + "&page=" + i + "'>" + i + "</a></li>"); ;
}
else
{
sb.Append("<li" + activeCss + "><a href='Manager_Customer.aspx?selecttype=" + selecttype + "&selectvalue=" + selectvalue + "&page=" + i + "'>" + i + "</a></li>"); ;
}
}
}
for (i = currentpage + 1; i <= currentpage + 5; i++)
{
if (i < allpage)
{
if (rank.Length != 0)
{
sb.Append("<li><a href='Manager_Customer.aspx?class=" + rank + "&page=" + i + "'>" + i + "</a></li>");
}
else
{
sb.Append("<li><a href='Manager_Customer.aspx?selecttype=" + selecttype + "&selectvalue=" + selectvalue + "&page=" + i + "'>" + i + "</a></li>");
}
}
}
if (currentpage < allpage)
{
if (rank.Length != 0)
{
sb.Append("<li><a href='Manager_Customer.aspx?class=" + rank + "&page=" + allpage + "'>尾页</a></li>");
}
else
{
sb.Append("<li><a href='Manager_Customer.aspx?selecttype=" + selecttype + "&selectvalue=" + selectvalue + "&page=" + allpage + "'>尾页</a></li>");
}
}
sb.Append("<li><a href='javascript:void(0);'>共" + allnum + "笔纪录</a></li>");
}
public string GetBirthday(object yangli, object nongli)
{
string rt = string.Empty;
if (yangli != DBNull.Value)
{
rt = Convert.ToDateTime(yangli).ToString("yyyy-MM-dd") + " [阳]<br>";
}
if (nongli != DBNull.Value)
{
rt += Convert.ToDateTime(nongli).ToString("yyyy-MM-dd") + " [农]";
}
return rt;
}
}
#line default
#line hidden