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