//绑定
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("时间格式不正确！");
}
}
