コード例 #1
0
        public List <ProductOrderReportWarningModel> GetProductOrderReportWaring(string orderDetailId)
        {
            string sql = query.PRODUCT_ORDER_REPORT_WARNING_LIST_BY_DETAIL_ID;

            if (orderDetailId != null)
            {
                sql += !orderDetailId.Equals("") ?
                       string.Format(" AND PORW.Order_Detail_ID = {0} ", orderDetailId) : "";
            }

            log.Debug("SQL[PRODUCT ORDERREPORT WARNING LIST] : " + sql);

            List <ProductOrderReportWarningModel> orderReportWarningList = new List <ProductOrderReportWarningModel>();

            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();
                    log.Debug("Connect to Sqlserver success.");

                    using (SqlCommand sqlcmd = new SqlCommand(sql, conn))
                    {
                        using (SqlDataReader dataReader = sqlcmd.ExecuteReader())
                        {
                            while (dataReader.Read())
                            {
                                ProductOrderReportWarningModel model = new ProductOrderReportWarningModel();
                                model.Warning_No         = Convert.ToInt32(dataReader["Warning_No"]);
                                model.Warning_Date       = dataReader["Warning_Date"].ToString().Trim();
                                model.Warning_Noted_Date = dataReader["Warning_Noted_Date"].ToString().Trim();
                                model.Reason             = dataReader["Reason"].ToString().Trim();

                                orderReportWarningList.Add(model);
                            }
                        }
                    }
                }

                log.Debug("Disconnect to Sqlserver.");
            }
            catch (Exception ex)
            {
                log.Error("Error", ex);
                throw ex;
            }

            return(orderReportWarningList);
        }
コード例 #2
0
        public List <ProductOrderReportWarningModel> GetProductOrderReportWaring()
        {
            string sql = query.PRODUCT_ORDER_REPORT_WARNING_ALERT;

            log.Debug("SQL[PRODUCT ORDERREPORT WARNING LIST] : " + sql);

            List <ProductOrderReportWarningModel> orderReportWarningList = new List <ProductOrderReportWarningModel>();

            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();
                    log.Debug("Connect to Sqlserver success.");

                    using (SqlCommand sqlcmd = new SqlCommand(sql, conn))
                    {
                        using (SqlDataReader dataReader = sqlcmd.ExecuteReader())
                        {
                            while (dataReader.Read())
                            {
                                ProductOrderReportWarningModel model = new ProductOrderReportWarningModel();
                                model.RowNo            = Convert.ToInt32(dataReader["RowNo"]);
                                model.Order_Detail_ID  = Convert.ToInt32(dataReader["Order_Detail_ID"]);
                                model.Warning_No       = Convert.ToInt32(dataReader["Warning_No"]);
                                model.Warning_Date     = dataReader["Warning_Date"].ToString().Trim();
                                model.Order_ID         = dataReader["Order_ID"].ToString().Trim();
                                model.Order_Day_Count  = Convert.ToInt32(dataReader["Order_Day_Count"]);
                                model.Order_to         = dataReader["Order_to"].ToString().Trim();
                                model.Product_Code     = dataReader["Product_Code"].ToString().Trim();
                                model.Operation_Detail = dataReader["Operation_Detail"].ToString().Trim();

                                orderReportWarningList.Add(model);
                            }
                        }
                    }
                }

                log.Debug("Disconnect to Sqlserver.");
            }
            catch (Exception ex)
            {
                log.Error("Error", ex);
                throw ex;
            }

            return(orderReportWarningList);
        }