//得到用户姓名的下拉框 public string GetUserNameForAutoComplete(HttpContext context) { String keyWord = context.Request.Params["query"];//获取的属性必须是“query”,这是jquery插件规定的 StringBuilder sb = new StringBuilder(); sb.Append("{"); sb.AppendFormat("query:'{0}'", keyWord); sb.Append(","); /*下面一行中的4个数据一般是通过查询关键子keyWord从数据库中获取,本次则模拟静态数据 * 本次模拟的是输入关键字‘Li’产生的数据,但本次只是为了做范例,所以无论输入什么关键字,都将在浏览器中显示下面的4个数据 * */ String data = String.Empty; if (!String.IsNullOrEmpty(keyWord)) { KORWeb.BUL.JUserBU bu1 = new KORWeb.BUL.JUserBU(); DataTable dt1 = bu1.GetUserName(keyWord, 10); foreach (DataRow dr1 in dt1.Rows) { string v = dr1[0].ToString(); if (!String.IsNullOrEmpty(v)) { data += String.Format(",'{0}'", v); } } if (data.StartsWith(",")) { data = data.Substring(1); } } if (String.IsNullOrEmpty(data)) { sb.Append("suggestions:[]"); } else { sb.AppendFormat("suggestions:[{0}]", data); } sb.Append("}"); return(sb.ToString()); }
/// <summary> /// 增加项目组的成员 /// </summary> /// <param name="personid"></param> /// <param name="projectGuidid"></param> /// <param name="gw"></param> /// <returns></returns> public bool AddPerson(String personid, String projectGuidid, String gw) { bool succ = false; JConnect.GetConnect().BeginTrans(); try { String[] arr1 = personid.Split(','); Dictionary <String, object> dic1 = new Dictionary <string, object>(); List <SearchField> condition = new List <SearchField>(); Tb_Project_PersonDA da1 = new Tb_Project_PersonDA(); foreach (String m in arr1) { condition.Clear(); condition.Add(new SearchField("parentGuid", projectGuidid)); condition.Add(new SearchField("UserID", m)); if (da1.HasData(condition)) { dic1.Clear(); dic1["PrjRole"] = gw; da1.EditData(condition, dic1); } else { dic1.Clear(); dic1["parentGuid"] = projectGuidid; dic1["UserID"] = m; dic1["UserName"] = JUserBU.GetUserNamByIDS(m); dic1["PrjRole"] = gw; dic1["GuidID"] = JString.GetUnique32ID(); da1.NewData(dic1); } } JConnect.GetConnect().CommitTrans(); succ = true; } catch (Exception err) { JConnect.GetConnect().RollBackTrans(); } return(succ); }
/// <summary> /// CheckDebugData /// </summary> /// <returns></returns> public bool CheckDebugData(String debugGuid, String status, String content, String domanUserID, string domanName, String ExecuteMan) { bool succ = false; int fgrate = 0; List <SearchField> condition = new List <SearchField>(); Dictionary <String, object> dic1 = new Dictionary <string, object>(); condition.Add(new SearchField("GuidID", debugGuid)); Tb_DebugDA da1 = new Tb_DebugDA(); dic1 = da1.GetFirstDictionary(condition, "*"); if (dic1 != null && dic1.Count > 0) { //更新日志的内容 DataTable dt1 = null; String log1 = dic1["log"].ToString(); fgrate = int.Parse(dic1["fgrate"].ToString()); if (String.IsNullOrEmpty(log1)) { dt1 = new DataTable(); dt1.Columns.Add("dotime"); dt1.Columns.Add("domanUserID"); dt1.Columns.Add("domanUserName"); dt1.Columns.Add("status"); dt1.Columns.Add("content"); } else { dt1 = KORWeb.BUL.UTools.JsonToDataTable(log1); } DataRow dr1 = dt1.NewRow(); dr1["dotime"] = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); dr1["domanUserID"] = domanUserID; dr1["domanUserName"] = domanName; dr1["status"] = (status == "2" ? "已解决" : "未解决"); dr1["content"] = content; dt1.Rows.Add(dr1); log1 = KORWeb.BUL.UTools.DataTableToJson(dt1); //更新debug的内容 dic1.Clear(); dic1["Status"] = status; dic1["StatusTime"] = DateTime.Now.ToString(); if (status == "0") { dic1["fgrate"] = fgrate + 1; //增加返工次数 } dic1["lastlog"] = content + "(" + domanName + " " + DateTime.Now.ToString() + ")"; if (String.IsNullOrEmpty(ExecuteMan) == false) { JUserBU bu1 = new JUserBU(); List <SearchField> condition1 = new List <SearchField>(); condition1.Add(new SearchField("UserID", ExecuteMan)); if (bu1.HasData(condition1)) { dic1["ExecuteMan"] = ExecuteMan; } } StringBuilder str1 = new StringBuilder(); str1.Append(log1); dic1["log"] = str1; da1.EditData(condition, dic1); succ = true; } return(succ); }