Exemple #1
0
        public DataTable getShopCollectTime()
        {
            string    strSql = "SELECT * FROM ShopCollectTime";
            DataTable dt     = SqlDbmanager.queryBySql(SqlExtension.GetSelectSqlCmdByParams(strSql));

            return(dt);
        }
Exemple #2
0
 public bool insertShopCollectTime(ShopCollectTime obj)
 {
     if (SqlDbmanager.ExecuteNonQry(SqlExtension.GetInsertSqlCmd("ShopCollectTime", obj)))
     {
         return(true);
     }
     return(false);
 }
Exemple #3
0
 public bool deleteShopCollectTime(ShopCollectTime obj)
 {
     if (SqlDbmanager.ExecuteNonQry(SqlExtension.GetDeleteSqlCmd("ShopCollectTime", obj, new List <string> {
         "SCT02=@SCT02", "SCT03=@SCT03", "SCT04=@SCT04"
     })))
     {
         return(true);
     }
     return(false);
 }
Exemple #4
0
        public int insertShopCollectTime(List <ShopCollectTime> times)
        {
            var cmdList = new List <SqlCommand>();

            foreach (var time in times)
            {
                cmdList.Add(SqlExtension.GetInsertSqlCmd("ShopCollectTime", time));
            }
            return(SqlDbmanager.ExecuteNonQryMutiSqlCmd(cmdList));
        }
Exemple #5
0
 public bool deleteShopCollectDaily(ShopCollectDaily obj)
 {
     if (SqlDbmanager.ExecuteNonQry(SqlExtension.GetDeleteSqlCmd("ShopCollectDaily", obj, new List <string> {
         "SCD02=@SCD02"
     })))
     {
         return(true);
     }
     return(false);
 }
Exemple #6
0
        public int insertShopCollectDaily(List <ShopCollectDaily> shopCollects)
        {
            var cmdList = new List <SqlCommand>();

            foreach (var shopcollect in shopCollects)
            {
                cmdList.Add(SqlExtension.GetInsertSqlCmd("ShopCollectDaily", shopcollect));
            }
            return(SqlDbmanager.ExecuteNonQryMutiSqlCmd(cmdList));
        }
Exemple #7
0
        public List <ShopCollectTime> getShopCollectTime(DataTable dt)
        {
            List <ShopCollectTime> rval = SqlExtension.ToList <ShopCollectTime>(dt) as List <ShopCollectTime>;

            return(rval);
        }
Exemple #8
0
        public List <ShopCollectDaily> getShopCollectDaily(DataTable dt)
        {
            List <ShopCollectDaily> rval = SqlExtension.ToList <ShopCollectDaily>(dt) as List <ShopCollectDaily>;

            return(rval);
        }