//得到用户姓名的下拉框
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);
}
