/// <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> /// 功能:执行普通的SQL语句 /// </summary> public void ExcuteSql(String sql) { try { Tb_Project_PersonDA da1 = new Tb_Project_PersonDA(); da1.ExcuteSql(sql); } catch (Exception err) { this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", ""); } }
/// <summary> /// 根据条件,修改一个数据 /// </summary> /// <param name="condition">修改数据的条件</param> /// <param name="data1">新的数据</param> public void EditData(List <SearchField> condition, Dictionary <String, object> data1) { try { Tb_Project_PersonDA da1 = new Tb_Project_PersonDA(); da1.EditData(condition, data1); this.executeResultCount = da1.ExecuteResultCount; } catch (Exception err) { this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", ""); } }
/// <summary> /// 根据条件删除数据 /// </summary> /// <param name="condition">删除数据条件</param> public void DeleteData(List <SearchField> condition) { try { Tb_Project_PersonDA da1 = new Tb_Project_PersonDA(); da1.DeleteData(condition); this.executeResultCount = da1.ExecuteResultCount; } catch (Exception err) { this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", ""); } }
/// <summary> /// 新增一条数据 /// </summary> /// <param name="data1">Dictionary数据</param> public void NewData(Dictionary <String, object> data1) { try { Tb_Project_PersonDA da1 = new Tb_Project_PersonDA(); da1.NewData(data1); this.executeResultCount = da1.ExecuteResultCount; } catch (Exception err) { this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", ""); } }
/// <summary> /// 判断是否有符合条件的数据 /// </summary> ///<param name="condition">查询条件</param> /// <returns></returns> public bool HasData(List <SearchField> condition) { bool result = false; try { Tb_Project_PersonDA da1 = new Tb_Project_PersonDA(); result = da1.HasData(condition); } catch (Exception err) { this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", ""); } return(result); }
/// <summary> /// 得到满足条件的第一行数据(返回值为Dictionary) /// </summary> /// <param name="condition">查询条件</param> /// <param name="Fields">数据字段</param> /// <returns>Dictionary字典</returns> public Dictionary <string, object> GetFirstDictionary(List <SearchField> condition, params String[] Fields) { Dictionary <string, object> data1 = null; try { Tb_Project_PersonDA da1 = new Tb_Project_PersonDA(); data1 = da1.GetFirstDictionary(condition, Fields); this.executeResultCount = da1.ExecuteResultCount; } catch (Exception err) { this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", ""); } return(data1); }
/// <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> /// 根据条件得到列表数据 /// </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); }
//插入数据 private void InsertData1( String prNum, String content1, String content2, String zeren1, String finish1, Tb_TaskDA da0) { //1--更加prjNum得到项目id String prjguid = String.Empty; Tb_ProjectDA da1 = new Tb_ProjectDA(); List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("prjNum", prNum)); Dictionary <String, object> dic1 = da1.GetFirstDictionary(condition, "GuidID"); if (dic1 != null && dic1.Count > 0 && String.IsNullOrEmpty(dic1["GuidID"].ToString()) == false) { prjguid = dic1["GuidID"].ToString(); } //2--得到项目经理的id String prjManager = String.Empty; Tb_Project_PersonDA da3 = new Tb_Project_PersonDA(); dic1.Clear(); condition.Clear(); condition.Add(new SearchField("ProjectGuidID", prjguid)); condition.Add(new SearchField("PrjRole", "0")); dic1 = da3.GetFirstDictionary(condition, "PersonID"); if (dic1 != null && dic1.Count > 0) { prjManager = dic1["PersonID"].ToString(); } //3--根据责任人的姓名得到责任id String zr1 = String.Empty; JUserDA da2 = new JUserDA(); dic1.Clear(); condition.Clear(); condition.Add(new SearchField("UserName", zeren1)); dic1 = da2.GetFirstDictionary(condition, "UserID"); if (dic1 != null && dic1.Count > 0) { zr1 = dic1["UserID"].ToString(); } //插入数据 String year1 = DateTime.Now.ToString("yyyy"); String month1 = DateTime.Now.ToString("MM"); if (String.IsNullOrEmpty(prjguid) == false && String.IsNullOrEmpty(content1) == false && String.IsNullOrEmpty(content2) == false && String.IsNullOrEmpty(prjManager) == false && String.IsNullOrEmpty(zr1) == false) { dic1.Clear(); dic1["ProjectGuidID"] = prjguid; DateTime t1 = DateTime.Parse(year1 + "-" + month1 + "-01"); dic1["begDate"] = t1; DateTime t2 = DateTime.Parse(year1 + "-" + finish1.Substring(0, 2) + "-" + finish1.Substring(2)); dic1["endDate"] = t2; dic1["Workload"] = ((t2 - t1).Days + 1) * 8; dic1["TaskTitle"] = "工作计划"; dic1["content"] = content1 + "--" + content2; dic1["Manager"] = prjManager; dic1["Status"] = "1"; dic1["GuidID"] = WebFrame.Util.JString.GetUnique32ID(); dic1["AddTime"] = DateTime.Now; dic1["AddUser"] = zr1; da0.NewData(dic1); } }