/// <summary>
/// 得到所有提案信息
/// </summary>
/// <param name="term"></param>
/// <returns></returns>
public JsonResult GetTextSelectUrlProposalInfo(string term)
{
string SystemID = Request["SystemID"] == null ?"-1": Request["SystemID"].ToString();
System.Data.DataTable dtContent = new System.Data.DataTable();
// DataTable dtUser = GPMS.Interface.DataLibrary.GetUserDataByFuzzy(term.Trim(), 10);
SqlDataBase dd = new SqlDataBase();
string str = "select top(10) a.ProposalID,a.ProposalName from[IPP].[dbo].[ipp_Proposal] a where a.BillType <> 10 and a.SystemInfo =" + SystemID + " and ( a.ProposalName like '%" + term + "%' or a.ProposalID like '%" + term + "%') ";
DataTable dtUser = dd.GetTable(str);
dtContent.Columns.Add("value"); //这几个就是传到视图的值
dtContent.Columns.Add("label"); //这里估计就是得到输入值后控件下方显示的文本格式,也是点击后显示在控件的值
dtContent.Columns.Add("desc"); //排序
dtContent.Columns.Add("icon");
foreach (DataRow drUser in dtUser.Rows)
{
//if (i.ToString().IndexOf(term) == -1)
//{//模拟查询
// continue;
//}
DataRow dr = dtContent.NewRow();
dr[0] = drUser["ProposalID"].ToString();
dr[1] = drUser["ProposalName"].ToString();
dr[2] = drUser["ProposalID"].ToString();
dr[3] = drUser["ProposalID"].ToString();
dtContent.Rows.Add(dr);
}
//select a as value,b as label,c as desc ,d as icon from table where title='term'
Donlim.Library.Entitys.EntityBase entityBase = new Donlim.Library.Entitys.EntityBase();//向上转型以使用父类的方法
entityBase.Dt = dtContent;
JsonResult jsonResult = entityBase.ToJsonOnlyData();
return(jsonResult);
}
/// <summary>
/// 查询开发工程师
/// </summary>
/// <param name="term"></param>
/// <returns></returns>
public JsonResult GetTextSelectUrlDevUser(string term)
{
System.Data.DataTable dtContent = new System.Data.DataTable();
// DataTable dtUser = GPMS.Interface.DataLibrary.GetUserDataByFuzzy(term.Trim(), 10);
SqlDataBase dd = new SqlDataBase();
string str = "select top(10) a.UserCode,a.UserName from [IPP].[dbo].[V_Developer] a where (a.UserCode like '%" + term + "%' or a.UserName like '%" + term + "%')";
DataTable dtUser = dd.GetTable(str);
dtContent.Columns.Add("value"); //这几个就是传到视图的值
dtContent.Columns.Add("label"); //这里估计就是得到输入值后控件下方显示的文本格式,也是点击后显示在控件的值
dtContent.Columns.Add("desc"); //排序
dtContent.Columns.Add("icon");
foreach (DataRow drUser in dtUser.Rows)
{
//if (i.ToString().IndexOf(term) == -1)
//{//模拟查询
// continue;
//}
DataRow dr = dtContent.NewRow();
dr[0] = drUser["UserCode"].ToString();
dr[1] = drUser["UserName"].ToString();
dr[2] = drUser["UserCode"].ToString();
dr[3] = drUser["UserCode"].ToString();
dtContent.Rows.Add(dr);
}
//select a as value,b as label,c as desc ,d as icon from table where title='term'
Donlim.Library.Entitys.EntityBase entityBase = new Donlim.Library.Entitys.EntityBase();//向上转型以使用父类的方法
entityBase.Dt = dtContent;
JsonResult jsonResult = entityBase.ToJsonOnlyData();
return(jsonResult);
}
/// <summary>
/// 查询用户
/// </summary>
/// <param name="term">关键词</param>
/// <returns></returns>
public JsonResult GetTextSelectUrlUser(string term)
{
System.Data.DataTable dtContent = new System.Data.DataTable();
DataTable dtUser = GPMS.Interface.DataLibrary.GetUserDataByFuzzy(term, 10, false);
dtContent.Columns.Add("value");
dtContent.Columns.Add("label");
dtContent.Columns.Add("desc");
dtContent.Columns.Add("icon");
foreach (DataRow drUser in dtUser.Rows)
{
//if (i.ToString().IndexOf(term) == -1)
//{//模拟查询
// continue;
//}
DataRow dr = dtContent.NewRow();
dr[0] = drUser["UserCode"].ToString();
dr[1] = drUser["UserName"].ToString();
dr[2] = drUser["OrganizeCode"].ToString();
dr[3] = drUser["OrganizeName"].ToString();
dtContent.Rows.Add(dr);
}
//select a as value,b as label,c as desc ,d as icon from table where title='term'
Donlim.Library.Entitys.EntityBase entityBase = new Donlim.Library.Entitys.EntityBase();
entityBase.Dt = dtContent;
JsonResult jsonResult = entityBase.ToJsonOnlyData();
return(jsonResult);
}
/// <summary>
/// 模拟从数据库检索数据
/// </summary>
/// <param name="term">关键词</param>
/// <returns></returns>
public JsonResult GetTextSelectUrlDemo(string term)
{
System.Data.DataTable dtContent = new System.Data.DataTable();
dtContent.Columns.Add("value");
dtContent.Columns.Add("label");
dtContent.Columns.Add("desc");
dtContent.Columns.Add("icon");
for (int i = 0; i < 100; i++)
{
if (i.ToString().IndexOf(term) == -1)
{//模拟查询
continue;
}
DataRow dr = dtContent.NewRow();
dr[0] = i.ToString();
dr[1] = "服务器值" + i.ToString();
dr[2] = "服务器值描述" + i.ToString();
dr[3] = i.ToString();
dtContent.Rows.Add(dr);
}
//select a as value,b as label,c as desc ,d as icon from table where title='term'
Donlim.Library.Entitys.EntityBase entityBase = new Donlim.Library.Entitys.EntityBase();
entityBase.Dt = dtContent;
JsonResult jsonResult = entityBase.ToJsonOnlyData();
return(jsonResult);
}
/// <summary>
/// 获取产品名称
/// </summary>
/// <param name="term">关键词</param>
/// <returns></returns>
//public ActionResult GetTextSelectUrlProduct(string term)
//{
// System.Data.DataTable dtContent = new System.Data.DataTable();
// ProductEntity obj = new ProductEntity();
// obj.ResetForSearch();
// obj.PageSize = 10;
// obj.ProductName = term;
// obj.IsUseLike = true;
// DataTable dt = obj.GetTable();
// dtContent.Columns.Add("value");
// dtContent.Columns.Add("label");
// dtContent.Columns.Add("desc");
// dtContent.Columns.Add("icon");
// foreach (DataRow drUser in dt.Rows)
// {
// //if (i.ToString().IndexOf(term) == -1)
// //{//模拟查询
// // continue;
// //}
// DataRow dr = dtContent.NewRow();
// dr[0] = drUser["ProductNoSimple"].ToString();
// dr[1] = drUser["ProductName"].ToString();
// dr[2] = "";
// dr[3] = "";
// dtContent.Rows.Add(dr);
// }
// //select a as value,b as label,c as desc ,d as icon from table where title='term'
// Donlim.Library.Entitys.EntityBase entityBase = new Donlim.Library.Entitys.EntityBase();
// entityBase.Dt = dtContent;
// JsonResult jsonResult = entityBase.ToJsonOnlyData();
// return jsonResult;
//}
/// <summary>
/// 查询组织
/// </summary>
/// <param name="term">关键词</param>
/// <returns></returns>
public JsonResult GetTextSelectUrlOrganize(string term)
{
System.Data.DataTable dtContent = new System.Data.DataTable();
Organize organize = new Organize();
organize.ResetForSearch();
organize.Parameters[0] = new SqlParameter("@term", term);
organize.SqlCustomer = " AND (organizeid LIKE '%'+@term+'%' OR organizename LIKE '%'+@term+'%')";
organize.PageSize = 10;
DataTable dt = organize.GetTable();
dtContent.Columns.Add("value");
dtContent.Columns.Add("label");
dtContent.Columns.Add("desc");
dtContent.Columns.Add("icon");
foreach (DataRow drUser in dt.Rows)
{
//if (i.ToString().IndexOf(term) == -1)
//{//模拟查询
// continue;
//}
DataRow dr = dtContent.NewRow();
dr[0] = drUser["organizeid"].ToString();
string longname = drUser["longname"].ToString();
if (longname != "广东东菱凯琴集团总部" && longname != "广东新宝电器股份有限公司")
{
longname = longname.Replace("广东东菱凯琴集团总部", "").Replace("广东新宝电器股份有限公司", "");
}
dr[1] = longname;
dr[2] = drUser["organizename"].ToString();
dr[3] = "";
dtContent.Rows.Add(dr);
}
//select a as value,b as label,c as desc ,d as icon from table where title='term'
Donlim.Library.Entitys.EntityBase entityBase = new Donlim.Library.Entitys.EntityBase();
entityBase.Dt = dtContent;
JsonResult jsonResult = entityBase.ToJsonOnlyData();
return(jsonResult);
}
/// <summary>
/// 查询客户
/// </summary>
/// <param name="term">关键词</param>
/// <returns></returns>
//public JsonResult GetTextSelectUrlCust(string term)
//{
// System.Data.DataTable dtContent = new System.Data.DataTable();
// CustomerEntity Customer = new CustomerEntity();
// Customer.ResetForSearch();
// Customer.PageSize = 10;
// Customer.SqlCustomer = " AND (CustomerName like '%'+@term+'%' OR CustomerNo like '%'+@term+'%') ";
// Customer.Parameters[0] = new SqlParameter("@term", term);
// Customer.IsUseLike = true;
// DataTable dtCust = Customer.GetTable(true);
// dtContent.Columns.Add("value");
// dtContent.Columns.Add("label");
// dtContent.Columns.Add("desc");
// dtContent.Columns.Add("icon");
// foreach (DataRow drCust in dtCust.Rows)
// {
// //if (i.ToString().IndexOf(term) == -1)
// //{//模拟查询
// // continue;
// //}
// DataRow dr = dtContent.NewRow();
// dr[0] = drCust["CustomerNo"].ToString();
// dr[1] = drCust["CustomerNo"].ToString();
// dr[2] = drCust["CustomerDesc"].ToString();
// dr[3] = "";
// dtContent.Rows.Add(dr);
// }
// //select a as value,b as label,c as desc ,d as icon from table where title='term'
// Donlim.Library.Entitys.EntityBase entityBase = new Donlim.Library.Entitys.EntityBase();
// entityBase.Dt = dtContent;
// JsonResult jsonResult = entityBase.ToJsonOnlyData();
// return jsonResult;
//}
#region 连续添加Personnel
/// <summary>
/// 连续添加Personnel
/// </summary>
/// <param name="term">查询条件</param>
/// <returns>JSON</returns>
public JsonResult GetTextSelectUrlUserInput(string term)
{
System.Data.DataTable dtContent = new System.Data.DataTable();
string strTerm = "";
if (term.Contains(";"))
{
strTerm = term.Substring(term.LastIndexOf(';') + 1, term.Trim().Length - (term.LastIndexOf(';') + 1)); //获取最后输入参数
}
DataTable dtUser = GPMS.Interface.DataLibrary.GetUserDataByFuzzy(strTerm, 10);
dtContent.Columns.Add("value");
dtContent.Columns.Add("label");
dtContent.Columns.Add("desc");
dtContent.Columns.Add("icon");
foreach (DataRow drUser in dtUser.Rows)
{
//if (i.ToString().IndexOf(term) == -1)
//{//模拟查询
// continue;
//}
DataRow dr = dtContent.NewRow();
dr[0] = drUser["UserCode"].ToString();
dr[1] = drUser["UserName"].ToString();
dr[2] = drUser["Description"].ToString();
dr[3] = "";
dtContent.Rows.Add(dr);
}
//select a as value,b as label,c as desc ,d as icon from table where title='term'
Donlim.Library.Entitys.EntityBase entityBase = new Donlim.Library.Entitys.EntityBase();
entityBase.Dt = dtContent;
JsonResult jsonResult = entityBase.ToJsonOnlyData();
return(jsonResult);
}