private string GetLikeUserName(string valueString)
{
if (String.IsNullOrEmpty(valueString) || String.IsNullOrEmpty(_autoType.Trim()))
{
return "";
}
StringBuilder sb = new StringBuilder();
WebAutoCompleteBP webBP = new WebAutoCompleteBP();
//if (Session["cityName"] != null)
//{
// CityName = Session["cityName"].ToString();
//}
DataSet dsResult = webBP.GetWebCompleteList(_autoType, valueString, HiddenParms.Value.Trim());
if (dsResult.Tables[0].Rows.Count == 0)
{
return "";
}
foreach (DataRow dr in dsResult.Tables[0].Rows)
{
sb.Append(dr["REVALUE_ALL"].ToString()).Append("\n");
}
return sb.ToString();
}
private DataTable GetSalesManagerList()
{
WebAutoCompleteBP webBP = new WebAutoCompleteBP();
DataTable dtSales = webBP.GetWebCompleteList("sales", "", "").Tables[0];
return dtSales;
}
/// <summary>
/// 获取所有的销售人员--SQL
/// </summary>
private DataTable GetSalesManagerList()
{
WebAutoCompleteBP webBP = new WebAutoCompleteBP();
System.IO.File.AppendAllText("C:\\ConsultLog\\" + UserSession.Current.UserAccount + "-Log.txt",
"\r\n获取所有的销售人员--SQL(GetSalesManagerList)--开始--时间：" + DateTime.Now.ToString() + DateTime.Now.Millisecond.ToString() + "\r\n", System.Text.Encoding.GetEncoding("GB2312"));
DataTable dtSales = webBP.GetWebCompleteList("sales", "", "").Tables[0];
System.IO.File.AppendAllText("C:\\ConsultLog\\" + UserSession.Current.UserAccount + "-Log.txt",
"获取所有的销售人员--SQL(GetSalesManagerList)--结束--时间：" + DateTime.Now.ToString() + DateTime.Now.Millisecond.ToString() + "\r\n", System.Text.Encoding.GetEncoding("GB2312"));
return dtSales;
}