/// <summary> /// 根据项目的ID和人员的岗位,得到对应的姓名和ID /// </summary> /// <param name="ProjectGuidID"></param> /// <param name="PrjRole"></param> public static String GetProjectPersonID(String ProjectGuidID, String PrjRole) { String result = String.Empty; List <SearchField> condition = new List <SearchField>(); Tb_Project_PersonDA da1 = new Tb_Project_PersonDA(); condition.Add(new SearchField("parentGuid", ProjectGuidID)); if (String.IsNullOrEmpty(PrjRole) == false) { condition.Add(new SearchField("PrjRole", PrjRole)); } DataTable dt1 = da1.GetListData(condition, -1, -1, "num", "UserID"); bool first = true; foreach (DataRow dr1 in dt1.Rows) { if (first) { result = dr1[0].ToString(); first = false; } else { result = result + "," + dr1[0].ToString(); } } return(result); }
/// <summary> /// 设置项目的经手人下拉框 /// </summary> /// <param name="control"></param> /// <param name="parentGuid"></param> public String SetProjectManDropDownList(ListControl control, String prjNum, String blankValue) { String result = String.Empty; List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("prjNum", prjNum)); Tb_ProjectDA da0 = new Tb_ProjectDA(); Dictionary <String, object> dic1 = da0.GetFirstDictionary(condition, "GuidID"); if (dic1 != null && dic1.Count > 0) { result = dic1["GuidID"].ToString(); condition.Clear(); condition.Add(new SearchField("parentGuid", dic1["GuidID"].ToString())); Tb_Project_PersonDA da1 = new Tb_Project_PersonDA(); DataTable dt1 = da1.GetListData(condition, -1, -1, "num", "*"); foreach (DataRow dr1 in dt1.Rows) { ListItem item1 = new ListItem(dr1["UserName"].ToString(), dr1["UserID"].ToString()); control.Items.Add(item1); } } if (String.IsNullOrEmpty(blankValue) == false) { control.Items.Insert(0, new ListItem(blankValue, "")); } return(result); }
/// <summary> /// 根据条件得到列表数据 /// </summary> /// <param name="condition">查询条件</param> /// <param name="PageSize">页大小</param> /// <param name="CurPage">当前页</param> /// <param name="Fields">数据字段</param> /// <param name="orderBy">排序表达式</param> /// <param name="TotalRow">数据总行数</param> /// <param name="Fields">要显示的字段</param> /// <returns>列表数据</returns> public DataTable GetListData(List <SearchField> condition, int PageSize, int CurPage, String orderBy, out int TotalRow, params String[] Fields) { TotalRow = 0; DataTable dt1 = null; try { Tb_Project_PersonDA da1 = new Tb_Project_PersonDA(); dt1 = da1.GetListData(condition, PageSize, CurPage, orderBy, out TotalRow, Fields); this.executeResultCount = da1.ExecuteResultCount; return(dt1); } catch (Exception err) { this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", ""); } return(dt1); }