Esempi in C# (CSharp) per JdgzReportType

Esempio n. 1

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

Esempio n. 2

File: BusiItemManage_SS.cs Progetto: hijushen/WindowDemo

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