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