private void BinData(int spzt)
{
string where = "SELECT MX.*,GX.MESGXMC GXMC,CP.SAPRemark,KH.KHMC ";
where = string.Format(" {0} FROM GZ_XWZYMX MX ", where);
where = string.Format(" {0} JOIN GZ_GXDZB GX ON MX.GXID=GX.MESGXID ", where);
where = string.Format(" {0} JOIN JC_CPXX CP ON MX.CPID=CP.CPID ", where);
where = string.Format(" {0} JOIN JC_KHXX KH ON MX.KHID=KH.KHID WHERE 1=1", where);
where = string.Format(" {0} and SPZT = {1} ", where, spzt);
GZ_XWZYMX valRgzmx = new GZ_XWZYMX();
GZ_XWZYMX condRgzmx = new GZ_XWZYMX();
conn = "connMES";
DataTable dtbRGZ = BLLTable<GZ_XWZYMX>.Factory(conn).qDataTable(where);
this.gridRGZ.DataSource = dtbRGZ;
gridRGZ.DataBind(); //执行绑定
ViewState["detailtable"] = dtbRGZ;//dtbRGZMX;
}
private void BinData(int spzt)
{
string where = "SELECT MX.*,GX.MESGXMC GXMC,CP.SAPRemark,KH.KHMC ";
where = string.Format(" {0} FROM GZ_XWZYMX MX ", where);
where = string.Format(" {0} JOIN GZ_GXDZB GX ON MX.GXID=GX.MESGXID ", where);
where = string.Format(" {0} JOIN JC_CPXX CP ON MX.CPID=CP.CPID ", where);
where = string.Format(" {0} JOIN JC_KHXX KH ON MX.KHID=KH.KHID WHERE 1=1", where);
where = string.Format(" {0} and SPZT = {1} ", where, spzt);
GZ_XWZYMX valRgzmx = new GZ_XWZYMX();
GZ_XWZYMX condRgzmx = new GZ_XWZYMX();
conn = "connMES";
DataTable dtbRGZ = BLLTable <GZ_XWZYMX> .Factory(conn).qDataTable(where);
this.gridRGZ.DataSource = dtbRGZ;
gridRGZ.DataBind(); //执行绑定
ViewState["detailtable"] = dtbRGZ; //dtbRGZMX;
}