public DataTable GetYgzmx(string ygbh, string scyf) { GZ_YGZMX valYgzmx = new GZ_YGZMX(); GZ_YGZMX conYgzmx = new GZ_YGZMX(); string detailwhere = " SELECT * FROM GZ_YGZMX WHERE 1=1"; if (!string.IsNullOrEmpty(scyf)) { detailwhere = string.Format(" {0} and SCYF = '{1}'", detailwhere, scyf); } if (!string.IsNullOrEmpty(ygbh)) { detailwhere = string.Format(" {0} and (YGBH LIKE '%{1}%' OR YGXM LIKE'%{1}%')", detailwhere, ygbh); } conn = "connMES"; DataTable dtbYGZMX = BLLTable <GZ_YGZMX> .Factory(conn).qDataTable(detailwhere); return(dtbYGZMX); }
public DataTable GetYgzmx(string ygbh, string scyf) { GZ_YGZMX valYgzmx = new GZ_YGZMX(); GZ_YGZMX conYgzmx = new GZ_YGZMX(); string detailwhere = " SELECT * FROM GZ_YGZMX WHERE 1=1"; if (!string.IsNullOrEmpty(scyf)) { detailwhere = string.Format(" {0} and SCYF = '{1}'", detailwhere, scyf); } if (!string.IsNullOrEmpty(ygbh)) { detailwhere = string.Format(" {0} and (YGBH LIKE '%{1}%' OR YGXM LIKE'%{1}%')", detailwhere, ygbh); } conn = "connMES"; DataTable dtbYGZMX = BLLTable<GZ_YGZMX>.Factory(conn).qDataTable(detailwhere); return dtbYGZMX; }