Пример #1
0
        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));
        }
Пример #2
0
 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);
 }