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; }