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