示例#1
0
        public void Update()
        {
            QueryLite query = new QueryLite(ConfigurationManager.ConnectionStrings["EbabobaConnectionString"].ConnectionString);

            Dictionary <string, string> updates = new Dictionary <string, string>();

            updates.Add("CardId", this.CardId);
            updates.Add("Date", this.Date);
            updates.Add("IsIncome", this.IsIncome);
            updates.Add("Sum", this.Sum);
            updates.Add("TypeId", this.TypeId);
            updates.Add("CurrencyId", this.CurrencyId);

            query.Add("update hs");
            query.AddUpdates(updates);
            query.Add("from History hs where HistoryId = @HistoryId");
            query.AddParameter("@HistoryId", this.HistoryId);
            query.Execute();
            query.Clear();
        }
示例#2
0
        public void Update()
        {
            QueryLite query = new QueryLite(ConfigurationManager.ConnectionStrings["EbabobaConnectionString"].ConnectionString);

            Dictionary <string, string> updates = new Dictionary <string, string>();

            updates.Add("CardId", this.CardId);
            updates.Add("Date", this.Date);
            updates.Add("Frequency", this.Frequency);
            updates.Add("IsIncome", this.IsIncome);
            updates.Add("Sum", this.Sum);
            updates.Add("TypeId", this.TypeId);


            query.Add("update cr");
            query.AddUpdates(updates);
            query.Add("from Schedule cr where ScheduleId = @ScheduleId");
            query.AddParameter("@ScheduleId", this.ScheduleId);
            query.Execute();
            query.Clear();
        }