//绑定
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("数据访问错误，请重试！");
}
}
//绑定GridView
private void BindGridView()
{
try
{
string sql = GetSqlWhere();
if (string.IsNullOrEmpty(sql))
{
this.PrintfError("请选择查询条件！");
return;
}
string sortEx = this.grvWGD.Attributes["SortExpression"];
string sortDirect = this.grvWGD.Attributes["SortDirection"];
string strSort = (!string.IsNullOrEmpty(sortEx)) ? sortEx + " " + sortDirect : "";
DataSet ds = WGDQuery.QueryWGD(sql, strSort, PageControl1.GetPageSize(), PageControl1.GetCurrPage());
this.grvWGD.DataSource = ds;
this.grvWGD.DataBind();
SetSumInfo();
this.SetDisplayList1.InitSetListControl(this.grvWGD, SysBaseConfig.WGD_Q_PAGE);
this.SetDisplayList1.SetGridViewDisplay(grvWGD);
}
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 SetPageCountView()
{
try
{
int outCount;
int pageCount = DataOperQuery.GetAllPCHPageCount(this.txtPCH.Text, PageControl1.GetPageSize(), out outCount);
PageControl1.SetInitView(pageCount, outCount);
}
catch
{
this.PrintfError("数据访问错误，请重试！");
return;
}
}
private void SetPageCountView()
{
try
{
string sqlWhere = GetSqlWhere();
int outCount;
int pageCount = GetPageCount(sqlWhere, PageControl1.GetPageSize(), out outCount);
PageControl1.SetInitView(pageCount, outCount);
}
catch
{
this.PrintfError("数据访问错误，请重试！");
return;
}
}
//绑定
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("数据访问错误，请重试！");
}
}
//设置分页控件显示
private void SetPageCountView()
{
//try
//{
string sql = GetsqlDPP();
int outCount;
int pageCount = DPPQuery.GetPageCount(sql, PageControl1.GetPageSize(), out outCount);
PageControl1.SetInitView(pageCount, outCount);
//}
//catch
//{
// this.PrintfError("数据访问错误，请重试！");
// return;
//}
}
//设置分页控件显示
private void SetPageCountView()
{
//try
//{
string sqlWhere = Getsqlstr();
int outCount;
int pageCount = QTRKReport.GetPageCount(sqlWhere, PageControl1.GetPageSize(), out outCount);
PageControl1.SetInitView(pageCount, outCount);
//}
//catch
//{
// this.PrintfError("数据访问错误，请重试！");
// return;
//}
}
//绑定上面的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 = Getsqlstr();
string sortEx = this.grvQTRK.Attributes["SortExpression"];
string sortDirect = this.grvQTRK.Attributes["SortDirection"];
string strSort = (!string.IsNullOrEmpty(sortEx)) ? sortEx + " " + sortDirect : "";
DataSet ds = QTRKReport.GetQueryYTRK(sql, strSort, PageControl1.GetPageSize(), PageControl1.GetCurrPage());
this.grvQTRK.DataSource = ds;
this.grvQTRK.DataBind();
}
catch (Exception ex)
{
String strEx = ex.Message;
this.PrintfError("数据访问错误，请重试！");
}
}
//绑定gridview
private void BindGridView()
{
try
{
string sql = GetSqlZKD();
string sortEx = this.grvZKD.Attributes["SortExpression"];
string sortDirect = this.grvZKD.Attributes["SortDirection"];
string strSort = (!string.IsNullOrEmpty(sortEx)) ? sortEx + " " + sortDirect : "";
DataSet ds = ZKDQuery.GetQueryZKD(sql, strSort, PageControl1.GetPageSize(), PageControl1.GetCurrPage());
this.grvZKD.DataSource = ds;
this.grvZKD.DataBind();
this.SetDisplayList1.InitSetListControl(this.grvZKD, SysBaseConfig.ZKD_Q_PAGE);
this.SetDisplayList1.SetGridViewDisplay(grvZKD);
}
catch (Exception ex)
{
String strEx = ex.Message;
this.PrintfError("数据访问错误，请重试！");
}
}
//设置分页控件显示
private void SetPageCountView()
{
if (CheckUI())
{
try
{
String strEndTime = this.txtETime.Text + " 23:59:59";
int outCount;
int pageCount = DataOperQuery.GetPageCount(this.txtSTime.Text, strEndTime, PageControl1.GetPageSize(), out outCount);
PageControl1.SetInitView(pageCount, outCount);
}
catch
{
this.PrintfError("数据访问错误，请重试！");
return;
}
}
}
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("时间格式不正确！");
}
}