public static TempKscjInfo QueryKscj(String glbm, String sfzmhm) { TempKscjInfo info = null; String sql = "(select kskm \"kskm\",zt \"zt\",to_char(ykrq,'yyyy-MM-dd') \"yyrq\" from (select kskm,nvl(zt,0) zt,nvl(ykrq,sysdate) ykrq from fzkyy.st_drv_preasign a where kskm=1 and glbm like '{0}%' and sfzmhm='{1}' order by ykrq desc) where rownum=1)"; sql += " union "; sql += "(select kskm \"kskm\",zt \"zt\",to_char(ykrq,'yyyy-MM-dd') \"yyrq\" from (select kskm,nvl(zt,0) zt,nvl(ykrq,sysdate) ykrq from fzkyy.st_drv_preasign a where kskm=2 and glbm like '{0}%' and sfzmhm='{1}' order by ykrq desc) where rownum=1)"; sql += " union "; sql += "(select kskm \"kskm\",zt \"zt\",to_char(ykrq,'yyyy-MM-dd') \"yyrq\" from (select kskm,nvl(zt,0) zt,nvl(ykrq,sysdate) ykrq from fzkyy.st_drv_preasign a where kskm=3 and glbm like '{0}%' and sfzmhm='{1}' order by ykrq desc) where rownum=1)"; String queryStr = string.Format(sql, new string[] { glbm, sfzmhm }); //IDataAccess access = new OracleDataHelper(System.Configuration.ConfigurationManager.AppSettings["DefaultConnString2"]); DataTable dt = GetInnerDbAccess().SelectDataTable(queryStr, "tmp"); if (dt != null && dt.Rows.Count > 0) { info = new TempKscjInfo(); info.km1 = Convert.ToInt32(dt.Rows[0][1]); info.km1yyrq = dt.Rows[0][2].ToString(); if (dt.Rows.Count > 1) { info.km2 = Convert.ToInt32(dt.Rows[1][1]); info.km2yyrq = dt.Rows[1][2].ToString(); } if (dt.Rows.Count > 2) { info.km3 = Convert.ToInt32(dt.Rows[2][1]); info.km3yyrq = dt.Rows[2][2].ToString(); } } return(info); }
public static TempKscjInfo QueryKscj(String glbm, String sfzmhm) { TempKscjInfo info = null; String sql = "(select kskm \"kskm\",zt \"zt\",to_char(ykrq,'yyyy-MM-dd') \"yyrq\" from (select kskm,nvl(zt,0) zt,nvl(ykrq,sysdate) ykrq from fzkyy.st_drv_preasign a where kskm=1 and glbm like '{0}%' and sfzmhm='{1}' order by ykrq desc) where rownum=1)"; sql += " union "; sql += "(select kskm \"kskm\",zt \"zt\",to_char(ykrq,'yyyy-MM-dd') \"yyrq\" from (select kskm,nvl(zt,0) zt,nvl(ykrq,sysdate) ykrq from fzkyy.st_drv_preasign a where kskm=2 and glbm like '{0}%' and sfzmhm='{1}' order by ykrq desc) where rownum=1)"; sql += " union "; sql += "(select kskm \"kskm\",zt \"zt\",to_char(ykrq,'yyyy-MM-dd') \"yyrq\" from (select kskm,nvl(zt,0) zt,nvl(ykrq,sysdate) ykrq from fzkyy.st_drv_preasign a where kskm=3 and glbm like '{0}%' and sfzmhm='{1}' order by ykrq desc) where rownum=1)"; String queryStr = string.Format(sql, new string[] { glbm, sfzmhm }); //IDataAccess access = new OracleDataHelper(System.Configuration.ConfigurationManager.AppSettings["DefaultConnString2"]); DataTable dt = GetInnerDbAccess().SelectDataTable(queryStr, "tmp"); if (dt != null && dt.Rows.Count > 0) { info = new TempKscjInfo(); info.km1 = Convert.ToInt32(dt.Rows[0][1]); info.km1yyrq = dt.Rows[0][2].ToString(); if (dt.Rows.Count > 1) { info.km2 = Convert.ToInt32(dt.Rows[1][1]); info.km2yyrq = dt.Rows[1][2].ToString(); } if (dt.Rows.Count > 2) { info.km3 = Convert.ToInt32(dt.Rows[2][1]); info.km3yyrq = dt.Rows[2][2].ToString(); } } return info; }