コード例 #1
0
        /// <summary>
        /// Get data collection
        /// </summary>
        /// <param name="sql">SQL Statement</param>
        /// <returns>PrevSupplyPlanInfo Collection </returns>
        public List <VmiPrevSupplyPlanInfo> GetListBySql(string dateColumn)
        {
            string sql = "select [FID],[PART_NO],[SUPPLIER_NUM],[PLANT],convert(datetime,'" + dateColumn + "') as [DELIVERY_DATE],isnull([" + dateColumn + "],0) as [REQUIRE_QTY] "
                         + "from [LES].[TT_ATP_SUPPLY_PLAN] with(nolock) "
                         + "where [VALID_FLAG] = 1 "
                         + "and isnull([" + dateColumn + "],0) <> 0;";///将为零的数据过滤掉,否则数量巨大
            Database  db        = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand(sql);
            List <VmiPrevSupplyPlanInfo> list = new List <VmiPrevSupplyPlanInfo>();

            using (IDataReader rdr = db.ExecuteReader(dbCommand))
            {
                while (rdr.Read())
                {
                    VmiPrevSupplyPlanInfo info = new VmiPrevSupplyPlanInfo();
                    info.Fid          = DBConvert.GetGuidNullable(rdr, rdr.GetOrdinal("FID"));
                    info.PartNo       = DBConvert.GetString(rdr, rdr.GetOrdinal("PART_NO"));
                    info.SupplierNum  = DBConvert.GetString(rdr, rdr.GetOrdinal("SUPPLIER_NUM"));
                    info.Plant        = DBConvert.GetString(rdr, rdr.GetOrdinal("PLANT"));
                    info.DeliveryDate = DBConvert.GetDateTimeNullable(rdr, rdr.GetOrdinal("DELIVERY_DATE"));
                    info.RequireQty   = DBConvert.GetDecimalNullable(rdr, rdr.GetOrdinal("REQUIRE_QTY"));
                    list.Add(info);
                }
            }
            return(list);
        }
コード例 #2
0
 /// <summary>
 /// InsertInfo
 /// </summary>
 /// <param name="info"></param>
 /// <returns></returns>
 public long InsertInfo(VmiPrevSupplyPlanInfo info)
 {
     return(dal.Add(info));
 }