//绑定 private void BindgrvRKJL() { try { string sql = GetSqlStr(); DataSet ds = PICIQuery.GetRKJL(sql, "", PageControl1.GetPageSize(), PageControl1.GetCurrPage()); this.grvRKJL.DataSource = ds; this.grvRKJL.DataBind(); } catch (Exception ex) { String strEx = ex.Message; this.PrintfError("数据访问错误,请重试!"); } }
//绑定上面的gridview private void BindXTZHWL() { try { string sql = GetSqlStr(); DataSet ds = XTZHQuery.GetXTZH(sql, "", PageControl1.GetPageSize(), PageControl1.GetCurrPage()); this.grvXTZHWL.DataSource = ds; this.grvXTZHWL.DataBind(); this.hidURL.Value = ""; } catch { this.PrintfError("数据错误!"); return; } }
//绑定 private void BindGridView() { //try //{ string sql = Getsqlstr(); DataSet ds = QTRKReport.GetQueryYTRK(sql, "", PageControl1.GetPageSize(), PageControl1.GetCurrPage()); this.grvQTRK.DataSource = ds; this.grvQTRK.DataBind(); //} //catch (Exception ex) //{ // String strEx = ex.Message; // this.PrintfError("数据访问错误,请重试!"); //} }
private void BindGridView() { try { string sql = GetSqlWhere(); string sortEx = this.grvFYDList.Attributes["SortExpression"]; string sortDirect = this.grvFYDList.Attributes["SortDirection"]; string strSort = (!string.IsNullOrEmpty(sortEx)) ? sortEx + " " + sortDirect : ""; DataSet ds = QueryCLHZ(sql, strSort, PageControl1.GetPageSize(), PageControl1.GetCurrPage()); this.grvFYDList.DataSource = ds; this.grvFYDList.DataBind(); SubTotal(); } catch (Exception ex) { String strEx = ex.Message; this.PrintfError("数据访问错误,请重试!"); } }
private void BindPCH() { try { DataSet ds = DataOperQuery.GetAllPCH(this.txtPCH.Text, "", PageControl1.GetPageSize(), PageControl1.GetCurrPage()); this.grdPCH.DataSource = ds; this.grdPCH.DataBind(); } catch { this.PrintfError("数据访问错误,请重试!"); } }
private void BindGridView() { try { string sql = GetSqlWhere(); string sortEx = this.grvFYD.Attributes["SortExpression"]; string sortDirect = this.grvFYD.Attributes["SortDirection"]; string strSort = (!string.IsNullOrEmpty(sortEx)) ? sortEx + " " + sortDirect : ""; DataSet ds = FYDQuery.GetQueryFYDQR(sql, strSort, PageControl1.GetPageSize(), PageControl1.GetCurrPage()); this.grvFYD.DataSource = ds; this.grvFYD.DataBind(); //this.SetDisplayList1.InitSetListControl(this.grvFYD, SysBaseConfig.FYD_Q_PAGE); //this.SetDisplayList1.SetGridViewDisplay(grvFYD); } catch (Exception ex) { String strEx = ex.Message; this.PrintfError("数据访问错误,请重试!"); } }
//绑定 private void BindGridView() { try { string sql = GetSqlStr(); string sortEx = this.grvCKZB.Attributes["SortExpression"]; string sortDirect = this.grvCKZB.Attributes["SortDirection"]; string strSort = (!string.IsNullOrEmpty(sortEx)) ? sortEx + " " + sortDirect : ""; DataSet ds = CKZBQuery.GetQueryCKZB(sql, strSort, PageControl1.GetPageSize(), PageControl1.GetCurrPage()); this.grvCKZB.DataSource = ds; this.grvCKZB.DataBind(); this.SetDisplayList1.InitSetListControl(this.grvCKZB, SysBaseConfig.CKZB_Q_PAGE); this.SetDisplayList1.SetGridViewDisplay(grvCKZB); DataSet dsCount = CKZBQuery.GetCount(sql); if (dsCount != null && dsCount.Tables[0].Rows.Count > 0 && !string.IsNullOrEmpty((dsCount.Tables[0].Rows[0]["HJZL"]).ToString())) { this.lblSUM.Text = dsCount.Tables[0].Rows[0]["Count"].ToString(); this.lblSL.Text = dsCount.Tables[0].Rows[0]["HJSL"].ToString(); this.lblZL.Text = Convert.ToDecimal(dsCount.Tables[0].Rows[0]["HJZL"]).ToString("#0.0000"); } else { this.lblSUM.Text = "0"; this.lblZL.Text = "0"; this.lblSL.Text = "0"; } } catch (Exception ex) { String strEx = ex.Message; this.PrintfError("数据访问错误,请重试!"); } }
//绑定GridView private void BindGridView() { try { string sql = GetsqlDPP(); string sortEx = this.grvDPP.Attributes["SortExpression"]; string sortDirect = this.grvDPP.Attributes["SortDirection"]; string strSort = (!string.IsNullOrEmpty(sortEx)) ? sortEx + " " + sortDirect : ""; DataSet ds = DPPQuery.GetQueryDPP(sql, strSort, PageControl1.GetPageSize(), PageControl1.GetCurrPage()); this.grvDPP.DataSource = ds; this.grvDPP.DataBind(); DataSet dsCount = DPPQuery.GetCount(sql); if (dsCount != null && dsCount.Tables[0].Rows.Count > 0 && !string.IsNullOrEmpty((dsCount.Tables[0].Rows[0]["HJZL"]).ToString())) { this.lblSum.Text = dsCount.Tables[0].Rows[0]["countAll"].ToString(); this.lblSL.Text = this.GetckdSL().ToString(); this.lblZL.Text = Convert.ToDecimal(dsCount.Tables[0].Rows[0]["HJZL"]).ToString("#0.0000"); } else { this.lblSum.Text = "0"; this.lblZL.Text = "0"; this.lblSL.Text = "0"; } } catch (Exception ex) { String strEx = ex.Message; this.PrintfError("数据访问错误,请重试!"); } }
private void BindGridView() { if (CheckUI()) { String strEndTime = this.txtETime.Text + " 23:59:59"; try { DataSet ds = DataOperQuery.GetDataMoveLog(this.txtSTime.Text, strEndTime, "", PageControl1.GetPageSize(), PageControl1.GetCurrPage()); this.grvDataMoveLog.DataSource = ds; this.grvDataMoveLog.DataBind(); } catch { PrintfError("数据访问错误!"); } } else { this.PrintfError("时间格式不正确!"); } }