private String GetLikeUserName(string key)
{
PointFiles pf = new PointFiles();
DataSet ds = pf.GetList(10, "[name] like '%" + key + "%'", " [name] ");
if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count < 1)
{
return(string.Empty);
}
DataTable dt = ds.Tables[0];
System.Text.StringBuilder sbstr = new System.Text.StringBuilder("[");
for (int i = 0; i < dt.Rows.Count; i++)
{
sbstr.Append("\"" + dt.Rows[i]["Name"].ToString().Replace(@"\", @"\\") + "\"");
if (i == dt.Rows.Count - 1)
{
sbstr.Append("]");
}
else
{
sbstr.Append(",");
}
}
return(sbstr.ToString());
}
private String GetLikeUserName1(string key)
{
PointFiles pf = new PointFiles();
DataSet ds = pf.GetList(10, "[name] like '%" + key + "%'", " [name] ");
if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count < 1)
{
return(string.Empty);
}
DataTable dt = ds.Tables[0];
System.Text.StringBuilder sbstr = new System.Text.StringBuilder("[");
for (int i = 0; i < dt.Rows.Count; i++)
{
//{ name: "Peter Pan", to: "*****@*****.**" },
// json: [{"label":"Name1","value":"2"},{"label":"Name2","value":"2"},{"label":"Name3","value":"3"}]
sbstr.Append("{\"label\":\"");
sbstr.Append(dt.Rows[i]["Name"].ToString().Replace(@"\", @"\\") + " " + GetBorrower(int.Parse(dt.Rows[i]["FileID"].ToString())));
sbstr.Append("\", \"value\":\"");
sbstr.Append(dt.Rows[i]["Name"].ToString().Replace(@"\", @"\\"));
sbstr.Append("\"}");
if (i == dt.Rows.Count - 1)
{
sbstr.Append("]");
}
else
{
sbstr.Append(",");
}
}
return(sbstr.ToString());
}
private int GetFileID(string FileName)
{
int FileID = 0;
try
{
PointFiles files = new PointFiles();
DataSet ds = files.GetList(" [Name] = '" + FileName + "' ");
if (ds == null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count < 1)
{
FileID = 0;
}
else
{
FileID = int.Parse(ds.Tables[0].Rows[0]["FileID"].ToString());
}
}
catch
{ }
return(FileID);
}
