/// <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);
}
}
