/// <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); }
//插入数据 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); } }