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