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); }