/// <summary>
/// 绑定所有工程方法
/// </summary>
/// <param name="SetStyle">是否设定表格样式</param>
private void BindGridViewData()
{
ERM.BLL.T_Projects_BLL ProjectsDB = new ERM.BLL.T_Projects_BLL();
IList <MDL.T_Projects> projList = ProjectsDB.GetAll();//绑定数据
DataTable tbl_proj = new DataTable();
tbl_proj.Columns.Add(new DataColumn("projectname", typeof(string)));
tbl_proj.Columns.Add(new DataColumn("ProjectNO", typeof(string)));
DataTable tbl_proj2 = new DataTable();
tbl_proj2.Columns.Add(new DataColumn("projectname", typeof(string)));
tbl_proj2.Columns.Add(new DataColumn("ProjectNO", typeof(string)));
DataRow row_1 = tbl_proj.NewRow();
row_1["projectname"] = "--请选择";
row_1["ProjectNO"] = "--请选择";
tbl_proj.Rows.Add(row_1);
DataRow row_2 = tbl_proj2.NewRow();
row_2["projectname"] = "--请选择";
row_2["ProjectNO"] = "--请选择";
tbl_proj2.Rows.Add(row_2);
foreach (MDL.T_Projects obj in projList)
{
DataRow row_temp = tbl_proj.NewRow();
row_temp["projectname"] = obj.projectname;
row_temp["ProjectNO"] = obj.ProjectNO;
tbl_proj.Rows.Add(row_temp);
DataRow row_temp2 = tbl_proj2.NewRow();
row_temp2["projectname"] = obj.projectname;
row_temp2["ProjectNO"] = obj.ProjectNO;
tbl_proj2.Rows.Add(row_temp2);
}
cbx_Source.DataSource = tbl_proj;
cbx_Source.DisplayMember = "projectname";
cbx_Source.ValueMember = "ProjectNO";
cbx_Trage.DataSource = tbl_proj2;
cbx_Trage.DisplayMember = "projectname";
cbx_Trage.ValueMember = "ProjectNO";
}
/// <summary>
/// 绑定所有工程方法
/// </summary>
/// <param name="SetStyle">是否设定表格样式</param>
private void BindGridViewData(bool SetStyle)
{
dgProject.AutoGenerateColumns = false;
if (SetStyle)
{
SetGridStyle(); //设置样式
}
dgProject.Rows.Clear();
ERM.BLL.T_Projects_BLL ProjectsDB = new ERM.BLL.T_Projects_BLL();
IList <MDL.T_Projects> projList = ProjectsDB.GetAll();//.GetList("").Tables[0].DefaultView;//绑定数据
IList <T_Dict> dict = dictBll.FindByKeyWord("ProjectCategory");
foreach (MDL.T_Projects obj in projList)
{
dgProject.Rows.Add();
dgProject.Rows[dgProject.Rows.Count - 1].Cells["ProjectNO"].Value = obj.ProjectNO;
dgProject.Rows[dgProject.Rows.Count - 1].Cells["district"].Value = obj.district;
dgProject.Rows[dgProject.Rows.Count - 1].Cells["projectname"].Value = obj.projectname;
dgProject.Rows[dgProject.Rows.Count - 1].Cells["address"].Value = obj.address;
dgProject.Rows[dgProject.Rows.Count - 1].Cells["begindate"].Value = obj.begindate;
foreach (var item in dict)
{
if (item.ValueName == obj.ProjectCategory)
{
dgProject.Rows[dgProject.Rows.Count - 1].Cells["ProjectCategory"].Value = item.DisplayName;
break;
}
}
dgProject.Rows[dgProject.Rows.Count - 1].Cells["begindate"].Value =
string.IsNullOrWhiteSpace(obj.begindate) ? "" : MyCommon.ToDate(obj.begindate).ToString("yyyy-MM-dd");
//dgProject.Rows[dgProject.Rows.Count - 1].Cells["bjdate"].Value = MyCommon.ToDate(obj.bjdate).ToString("yyyy-MM-dd");
dgProject.Rows[dgProject.Rows.Count - 1].Cells["enddate"].Value =
string.IsNullOrWhiteSpace(obj.enddate) ? "" : MyCommon.ToDate(obj.enddate).ToString("yyyy-MM-dd");
if (Globals.ProjectNO != null && Globals.ProjectNO != string.Empty && Globals.ProjectNO == obj.ProjectNO)
{
dgProject.Rows[dgProject.Rows.Count - 1].Selected = true;
}
}
}