/// <summary> /// 用于刷新数据 /// </summary> public void RefreshForm() { BLL.query_detail bll = new BLL.query_detail(); DataSet ds = bll.GetList("where list_id=" + list_id.ToString() + " and appellation='301'"); DXD.BLL.code_detail cibll = new DXD.BLL.code_detail(); dgvPersonList.DataSource = ds.Tables[0]; dgvPersonList.ClearSelection(); }
public void RefreshForm() { BLL.query_list bll = new BLL.query_list(); DataSet ds = bll.GetList("order by add_time desc"); DXD.BLL.code_detail cibll = new DXD.BLL.code_detail(); DataTable dt = cibll.CodeConvert(ds.Tables[0], "query_type"); dgvQueryList.DataSource = dt; dgvQueryList.ClearSelection(); }
private void UPassportCompare_Load(object sender, EventArgs e) { DTV.Passport passport = new DTV.Passport(); BLL.code_detail cibll = new DXD.BLL.code_detail(); cibll.Exists(1); //载入证件反馈数据 //DataSet ds = passport.LoadFeedback(query_id); //ds = cibll.CodeConvert(ds, "passport_type"); //dgvPassportFeedback.DataSource = ds.Tables[0]; DataSet ds; //ds = cibll.GetAllList(); //载入证件个人报告数据 //ds = passport.LoadReport(query_id); //ds = cibll.CodeConvert(ds, "passport_type"); //dgvPassportReport.DataSource = ds.Tables[0]; //载入比对匹配数据 //ds = passport.LoadCompare(query_id); //ds = cibll.CodeConvert(ds, "rep_passport_type"); //ds = cibll.CodeConvert(ds, "fee_passport_type"); //dgvPassportCompare.DataSource = ds.Tables[0]; //this.dgvPassportCompare.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; //this.dgvPassportCompare.ColumnHeadersHeight = this.dgvPassportCompare.ColumnHeadersHeight * 2; //this.dgvPassportCompare.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter; //this.dgvPassportCompare.CellPainting += new DataGridViewCellPaintingEventHandler(dgvPassportCompare_CellPainting); //this.dgvPassportCompare.Paint += new PaintEventHandler(dgvPassportCompare_Paint); //dgvPassportReport.Columns[4].DefaultCellStyle.Format = "yyyy-MM-dd"; //dgvPassportReport.Columns[5].DefaultCellStyle.Format = "yyyy-MM-dd"; //dgvPassportFeedback.ClearSelection(); //dgvPassportReport.ClearSelection(); //dgvPassportCompare.ClearSelection(); ////载入比对结果数据 //DataTable dt = passport.LoadCompareResult(query_id).Tables[0]; //if (dt.Rows.Count == 0) //{ // CalcCompareResult(); //} }