private void BinData()
{
// DateTime dateEnd=(DateTime)dateedtSCRQ2.Value;
DataTable dtbRCL = new DataTable();
string where=string.Empty;
string m_scrq1 = Convert.ToDateTime(dateedtSCRQ1.Text.Trim()).ToString("yyyy-MM-dd");
string m_scrq2 = Convert.ToDateTime(dateedtSCRQ2.Text.Trim()).ToString("yyyy-MM-dd");//dateEnd.AddDays(+1).ToString("yyy-MM-dd");
string m_gxid = cbGX.Value.ToString().Trim();
string m_xxlx = cbXXLX.Text.ToString().Trim();
// string m_yg = txtYG.Text.ToString().Trim();
if (!string.IsNullOrEmpty(m_scrq1) && !string.IsNullOrEmpty(m_scrq2))
{
where = string.Format(" {0} and czrq >= '{1}' AND czrq <= '{2}'", where, m_scrq1, m_scrq2);
}
if (!string.IsNullOrEmpty(m_xxlx) && m_xxlx != "全部")
{
if (m_xxlx == "其它")
{
where = string.Format(" {0} and ( XXLX = '{1}' OR XXLX = NULL)", where, "");
}
else if (m_xxlx == "三相")
{
where = string.Format(" {0} and substring(XXLX,1,2) = '{1}'", where, m_xxlx);
}
else
{
where = string.Format(" {0} and XXLX = '{1}'", where, m_xxlx);
}
}
if (!string.IsNullOrEmpty(m_gxid))
{
if (m_gxid == "102611")
{
where = string.Format(" SELECT * FROM V_GZ_BZDYTJ WHERE 1=1 {0}", where);
V_GZ_BZDYTJ valBz = new V_GZ_BZDYTJ();
V_GZ_BZDYTJ condBz = new V_GZ_BZDYTJ();
conn = "connMES";
dtbRCL = BLLTable<V_GZ_BZDYTJ>.Factory(conn).qDataTable(where);
}
if (m_gxid == "102511")
{
where = string.Format(" SELECT * FROM V_GZ_CPJTJ WHERE 1=1 {0}", where);
V_GZ_CPJTJ valBz = new V_GZ_CPJTJ();
V_GZ_CPJTJ condBz = new V_GZ_CPJTJ();
conn = "connMES";
dtbRCL = BLLTable<V_GZ_CPJTJ>.Factory(conn).qDataTable(where);
}
if (m_gxid == "102311")
{
where = string.Format(" SELECT * FROM V_GZ_JBTJ WHERE 1=1 {0}", where);
V_GZ_JBTJ valBz = new V_GZ_JBTJ();
V_GZ_JBTJ condBz = new V_GZ_JBTJ();
conn = "connMES";
dtbRCL = BLLTable<V_GZ_JBTJ>.Factory(conn).qDataTable(where);
}
}
this.gridRGZ.DataSource = dtbRCL;
gridRGZ.DataBind(); //执行绑定
ViewState["detailtable"] = dtbRCL;//dtbRGZMX;
}
private void BinData()
{
// DateTime dateEnd=(DateTime)dateedtSCRQ2.Value;
DataTable dtbRCL = new DataTable();
string where = string.Empty;
string m_scrq1 = Convert.ToDateTime(dateedtSCRQ1.Text.Trim()).ToString("yyyy-MM-dd");
string m_scrq2 = Convert.ToDateTime(dateedtSCRQ2.Text.Trim()).ToString("yyyy-MM-dd");//dateEnd.AddDays(+1).ToString("yyy-MM-dd");
string m_gxid = cbGX.Value.ToString().Trim();
string m_xxlx = cbXXLX.Text.ToString().Trim();
// string m_yg = txtYG.Text.ToString().Trim();
if (!string.IsNullOrEmpty(m_scrq1) && !string.IsNullOrEmpty(m_scrq2))
{
where = string.Format(" {0} and czrq >= '{1}' AND czrq <= '{2}'", where, m_scrq1, m_scrq2);
}
if (!string.IsNullOrEmpty(m_xxlx) && m_xxlx != "全部")
{
if (m_xxlx == "其它")
{
where = string.Format(" {0} and ( XXLX = '{1}' OR XXLX = NULL)", where, "");
}
else if (m_xxlx == "三相")
{
where = string.Format(" {0} and substring(XXLX,1,2) = '{1}'", where, m_xxlx);
}
else
{
where = string.Format(" {0} and XXLX = '{1}'", where, m_xxlx);
}
}
if (!string.IsNullOrEmpty(m_gxid))
{
if (m_gxid == "102611")
{
where = string.Format(" SELECT * FROM V_GZ_BZDYTJ WHERE 1=1 {0}", where);
V_GZ_BZDYTJ valBz = new V_GZ_BZDYTJ();
V_GZ_BZDYTJ condBz = new V_GZ_BZDYTJ();
conn = "connMES";
dtbRCL = BLLTable <V_GZ_BZDYTJ> .Factory(conn).qDataTable(where);
}
if (m_gxid == "102511")
{
where = string.Format(" SELECT * FROM V_GZ_CPJTJ WHERE 1=1 {0}", where);
V_GZ_CPJTJ valBz = new V_GZ_CPJTJ();
V_GZ_CPJTJ condBz = new V_GZ_CPJTJ();
conn = "connMES";
dtbRCL = BLLTable <V_GZ_CPJTJ> .Factory(conn).qDataTable(where);
}
if (m_gxid == "102311")
{
where = string.Format(" SELECT * FROM V_GZ_JBTJ WHERE 1=1 {0}", where);
V_GZ_JBTJ valBz = new V_GZ_JBTJ();
V_GZ_JBTJ condBz = new V_GZ_JBTJ();
conn = "connMES";
dtbRCL = BLLTable <V_GZ_JBTJ> .Factory(conn).qDataTable(where);
}
}
this.gridRGZ.DataSource = dtbRCL;
gridRGZ.DataBind(); //执行绑定
ViewState["detailtable"] = dtbRCL; //dtbRGZMX;
}
