//绑定
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("数据访问错误，请重试！");
}
}
//重置
protected void imgBtnCancle_Click(object sender, ImageClickEventArgs e)
{
this.txtBarcode.Text = "";
this.txtHW.Text = "";
this.txtPCH.Text = "";
this.txtWLH.Text = "";
this.txtFree1.Text = "";
this.txtFree2.Text = "";
this.txtFree3.Text = "";
this.hidCK.Value = "";
this.hidCopyGG.Value = "";
this.hidGG.Value = "";
this.hidQuery.Value = "";
this.hidRKPH.Value = "";
this.hidRKRQ.Value = "";
this.hidRKSX.Value = "";
this.hidTSXX.Value = "";
this.drpCK.Items.Clear();
this.drpCopyGG.Items.Clear();
this.drpCopyGG.Text = "";
this.drpGG.Items.Clear();
this.drpGG.Text = "";
this.drpRKPH.Items.Clear();
this.drpRKPH.Text = "";
this.drpRKSX.Items.Clear();
this.drpTSXX.Items.Clear();
this.drpTSXX.Text = "";
this.chkCK.Checked = false;
this.chkGG.Checked = false;
this.chkHW.Checked = false;
this.chkRKPCH.Checked = false;
this.chkRKPH.Checked = false;
this.chkRKRQ.Checked = false;
this.chkRKSX.Checked = false;
this.chkTM.Checked = false;
this.chkTSXX.Checked = false;
this.chkWLH.Checked = false;
this.chkFree1.Checked = false;
this.chkFree2.Checked = false;
this.chkFree3.Checked = false;
this.grvKC_HW.DataSource = null;
this.grvKC_PCH.DataSource = null;
this.grvKC_TM.DataSource = null;
this.grvKC_WLH.DataSource = null;
this.grvKC_PCH.DataBind();
this.grvKC_TM.DataBind();
this.grvKC_HW.DataBind();
this.grvKC_WLH.DataBind();
PageControl1.SetInitView(0, 0);
PageControl2.SetInitView(0, 0);
PageControl3.SetInitView(0, 0);
PageControl4.SetInitView(0, 0);
}
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 SetSumInfo()
{
if (this.grvWGD.Rows.Count > 0)
{
this.labCount.Text = PageControl1.GetRecordCount().ToString();
try
{
this.lblPaoGou.Text = WGDQuery.GetPaoGouCount(GetSqlWhere()).ToString();
}
catch
{
this.lblPaoGou.Text = "0";
}
}
}
//绑定上面的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 SetPageCountView()
{
//try
//{
string sqlWhere = Getsqlstr();
int outCount;
int pageCount = QTRKReport.GetPageCount(sqlWhere, PageControl1.GetPageSize(), out outCount);
PageControl1.SetInitView(pageCount, outCount);
//}
//catch
//{
// this.PrintfError("数据访问错误，请重试！");
// return;
//}
}
//设置分页控件显示
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 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("数据访问错误，请重试！");
}
}
//设置分页控件显示
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;
}
}
}
//导出EXCEL
protected void imgBtnExcel_Click(object sender, ImageClickEventArgs e)
{
if (this.grvWGD.Rows.Count < 1)
{
this.PrintfError("没有要导出的数据！");
}
try
{
string sqlWhere = GetSqlWhere();
DataSet ds = WGDQuery.QueryWGDExcel(sqlWhere);
if (ds != null)
{
this.CreateExcel(ds.Tables[0], "WGD.xls", PageControl1.GetRecordCount());
}
}
catch
{
this.PrintfError("数据访问错误，请重试！");
return;
}
}
//绑定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("数据访问错误，请重试！");
}
}
//查询
protected void imgBtnQuery_Click(object sender, ImageClickEventArgs e)
{
try
{
if (checksj())
{
SetPageCountView();
BindGridView();
lblSUM.Text = PageControl1.GetRecordCount().ToString();
lblZL.Text = GetckdJHZL().ToString();
}
else
{
PrintfError("输入日期有误！");
return;
}
}
catch
{
this.PrintfError("数据访问失败！");
return;
}
}
//查询
protected void imgBtnQuery_Click(object sender, ImageClickEventArgs e)
{
try
{
if (checksj())
{
string sql = GetSqlZKD();
if (!string.IsNullOrEmpty(sql))
{
//Response.Write(sql);
SetPageCountView();
BindGridView();
lblSUM.Text = PageControl1.GetRecordCount().ToString();
lblSL.Text = GetckdSL().ToString();
lblZL.Text = GetckdZL().ToString();
lblJHSL.Text = GetckdJHSL().ToString();
lblJHZL.Text = GetckdJHZL().ToString();
//lblCount.Text = PageControl1.GetRecordCount().ToString();
}
else
{
this.PrintfError("请输入查询条件!");
return;
}
}
else
{
this.PrintfError("时间有误，请重新输入");
return;
}
}
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("时间格式不正确！");
}
}
