//销售员客户查询处理
public ActionResult select_client()
{
int saleID = Convert.ToInt32(Request["saleID"]);
SqlParameter[] saleIDparam = { new SqlParameter("@saleID", saleID) };
var clientds = SQLHelper.ExecuteDataset(connStr, System.Data.CommandType.StoredProcedure, "sale_select_client", saleIDparam);
if (clientds.Tables[0].Rows.Count > 0)
{
List<Client> clients = new List<Client>();
for (int i = 0; i < clientds.Tables[0].Rows.Count; i++)
{
Client client = new Client();
client.id = Convert.ToInt32(clientds.Tables[0].Rows[i]["id"]);
client.clientname = clientds.Tables[0].Rows[i]["clientname"].ToString();
client.industry = clientds.Tables[0].Rows[i]["industry"].ToString();
client.address = clientds.Tables[0].Rows[i]["address"].ToString();
client.area = clientds.Tables[0].Rows[i]["area"].ToString();
client.contact = clientds.Tables[0].Rows[i]["contact"].ToString();
client.contactphone = clientds.Tables[0].Rows[i]["contactphone"].ToString();
client.presigntime = clientds.Tables[0].Rows[i]["presigntime"].ToString();
client.signtime = clientds.Tables[0].Rows[i]["signtime"].ToString();
client.preamt = clientds.Tables[0].Rows[i]["preamt"].ToString();
client.amt = clientds.Tables[0].Rows[i]["amt"].ToString();
clients.Add(client);
}
var result = new { code = "0", rows = clients };
return Json(result, JsonRequestBehavior.AllowGet);
}
else
{
var result = new { code = "1" };
return Json(result, JsonRequestBehavior.AllowGet);
}
}
//查询客户详情处理
public ActionResult totalmessageclient()
{
int id = Convert.ToInt32(Request["id"]);
SqlParameter[] messageparam = { new SqlParameter("@id", id) };
var totalmessageres = SQLHelper.ExecuteDataset(connStr, System.Data.CommandType.StoredProcedure, "client_total_message", messageparam);
if (totalmessageres.Tables[0].Rows.Count > 0)
{
List<Client> totalclient = new List<Client>();
for (int i = 0; i < totalmessageres.Tables[0].Rows.Count; i++)
{
Client client = new Client();
client.clientname = totalmessageres.Tables[0].Rows[i]["clientname"].ToString();
client.industry = totalmessageres.Tables[0].Rows[i]["industry"].ToString();
client.address = totalmessageres.Tables[0].Rows[i]["address"].ToString();
client.area = totalmessageres.Tables[0].Rows[i]["area"].ToString();
client.areavalue = Convert.ToInt32(totalmessageres.Tables[0].Rows[i]["areavalue"]);
client.clientfrom = totalmessageres.Tables[0].Rows[i]["clientfrom"].ToString();
client.contact = totalmessageres.Tables[0].Rows[i]["contact"].ToString();
client.contactphone = totalmessageres.Tables[0].Rows[i]["contactphone"].ToString();
client.presigntime = totalmessageres.Tables[0].Rows[i]["presigntime"].ToString();
client.signtime = totalmessageres.Tables[0].Rows[i]["signtime"].ToString();
client.preamt = totalmessageres.Tables[0].Rows[i]["preamt"].ToString();
client.amt = totalmessageres.Tables[0].Rows[i]["amt"].ToString();
client.salename = totalmessageres.Tables[0].Rows[i]["salename"].ToString();
totalclient.Add(client);
}
var result = new { code = "0", rows = totalclient };
return Json(result, JsonRequestBehavior.AllowGet);
}
else
{
var result = new { code = "1" };
return Json(result, JsonRequestBehavior.AllowGet);
}
}
//销售管理员客户条件查询
public ActionResult salemanagersearchclient()
{
if (Convert.ToInt32(Session["status"]) == 0)
{
string clientname = Request["clientname"].ToString();
SqlParameter[] searchparam = { new SqlParameter("@clientname", "%" + clientname + "%") };
var clientds = SQLHelper.ExecuteDataset(connStr, System.Data.CommandType.StoredProcedure, "allclientsearch", searchparam);
if (clientds.Tables[0].Rows.Count > 0)
{
List<Client> clients = new List<Client>();
for (int i = 0; i < clientds.Tables[0].Rows.Count; i++)
{
Client client = new Client();
client.id = Convert.ToInt32(clientds.Tables[0].Rows[i]["id"]);
client.clientname = clientds.Tables[0].Rows[i]["clientname"].ToString();
client.industry = clientds.Tables[0].Rows[i]["industry"].ToString();
client.address = clientds.Tables[0].Rows[i]["address"].ToString();
client.area = clientds.Tables[0].Rows[i]["area"].ToString();
client.contact = clientds.Tables[0].Rows[i]["contact"].ToString();
client.contactphone = clientds.Tables[0].Rows[i]["contactphone"].ToString();
client.salename = clientds.Tables[0].Rows[i]["salename"].ToString();
clients.Add(client);
}
var result = new { code = "0", rows = clients };
return Json(result, JsonRequestBehavior.AllowGet);
}
else
{
var result = new { code = "1" };
return Json(result, JsonRequestBehavior.AllowGet);
}
}
else
{
int id = Convert.ToInt32(Request["id"]);
string clientname = Request["clientname"].ToString();
SqlParameter[] searchparam = { new SqlParameter("@id", id), new SqlParameter("@clientname", "%" + clientname + "%") };
var clientds = SQLHelper.ExecuteDataset(connStr, System.Data.CommandType.StoredProcedure, "managerclientsearch", searchparam);
if (clientds.Tables[0].Rows.Count > 0)
{
List<Client> clients = new List<Client>();
for (int i = 0; i < clientds.Tables[0].Rows.Count; i++)
{
Client client = new Client();
client.id = Convert.ToInt32(clientds.Tables[0].Rows[i]["id"]);
client.clientname = clientds.Tables[0].Rows[i]["clientname"].ToString();
client.industry = clientds.Tables[0].Rows[i]["industry"].ToString();
client.address = clientds.Tables[0].Rows[i]["address"].ToString();
client.area = clientds.Tables[0].Rows[i]["area"].ToString();
client.contact = clientds.Tables[0].Rows[i]["contact"].ToString();
client.contactphone = clientds.Tables[0].Rows[i]["contactphone"].ToString();
client.salename = clientds.Tables[0].Rows[i]["salename"].ToString();
clients.Add(client);
}
var result = new { code = "0", rows = clients };
return Json(result, JsonRequestBehavior.AllowGet);
}
else
{
var result = new { code = "1" };
return Json(result, JsonRequestBehavior.AllowGet);
}
}
return View();
}