示例#1
0
        //Making AllItems true for all items is logical.
        //However, in the SP, we need to pass in a 0 for all items.
        public DataTable ReadStoreDataClean(DateTime sd, DateTime ed, int clientId = 0, int itemId = 0, StoreDataCleanOption option = StoreDataCleanOption.AllItems)
        {
            using (var cmd = Connection.CreateCommand("dbo.StoreDataClean_Select"))
                using (var adap = new SqlDataAdapter(cmd))
                {
                    cmd.Parameters.AddWithValue("Action", "ByClient");
                    cmd.Parameters.AddWithValue("sDate", sd);
                    cmd.Parameters.AddWithValue("eDate", ed);
                    cmd.Parameters.AddWithValue("AllItems", (int)option);
                    AddParameterIf(cmd, "ClientID", clientId > 0, clientId);
                    AddParameterIf(cmd, "ItemID", itemId > 0, itemId);

                    var dt = new DataTable();
                    adap.Fill(dt);

                    return(dt);
                }
        }
示例#2
0
 public DataTable ReadStoreDataClean(DateTime sd, DateTime ed, int clientId = 0, int itemId = 0, StoreDataCleanOption option = StoreDataCleanOption.AllItems)
 {
     using (var conn = NewConnection())
     {
         conn.Open();
         var result = GetReader(conn).ReadStoreDataClean(sd, ed, clientId, itemId, option);
         conn.Close();
         return(result);
     }
 }
示例#3
0
 public DataTable ReadStoreDataClean(DateTime sd, DateTime ed, int clientId = 0, int itemId = 0, StoreDataCleanOption option = StoreDataCleanOption.AllItems)
 {
     throw new NotImplementedException();
 }