public DataTable QueryJzxxXmbb(string itemCode, JdgzReportType type) { StringBuilder sbSql = new StringBuilder(); sbSql.AppendLine("select a.* from xm_ss_jdgz_xmbb a"); sbSql.AppendLine("where a.itemcode = '{0}' and a.bblx = '{1}'"); string strSql = string.Format(sbSql.ToString(), itemCode, type.ToString()); return(OracleHelper.ExecuteDataTable(strSql)); }
public DataTable QueryJzxxXmbb(string itemCode, JdgzReportType type) { StringBuilder sbSql = new StringBuilder(); sbSql.AppendLine("select a.* from xm_ss_jdgz_xmbb a"); sbSql.AppendLine("where a.itemcode = '{0}' and a.bblx = '{1}'"); string strSql = string.Format(sbSql.ToString(), itemCode, type.ToString()); return OracleHelper.ExecuteDataTable(strSql); }