示例#1
0
        static public bool SaveToDB(string UserId, float num, string AccountType, string Memo)
        {
            var db  = new Models.MainDBDataContext();
            var rec = new Models.AccountBook();

            rec.UserId    = UserId;
            rec.Amount    = (decimal)num;
            rec.SpendType = AccountType;
            rec.SpendDT   = System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
            rec.Memo      = Memo;
            db.AccountBooks.InsertOnSubmit(rec);
            db.SubmitChanges();
            return(true);
        }
示例#2
0
        static public float GetThisMonthSpend(string UserId)
        {
            var db  = new Models.MainDBDataContext();
            var ret = from c in db.AccountBooks
                      where c.SpendDT.StartsWith(DateTime.Now.ToString("yyyy/MM")) && c.UserId == UserId
                      select c.Amount;

            if (ret.Count() <= 0)
            {
                return(0);
            }
            var amount = ret.Sum();

            return((float)amount);
        }
示例#3
0
        /// <summary>
        /// 取得最常用type
        /// </summary>
        /// <param name="UserId"></param>
        /// <returns></returns>
        static public List <string> GetTypes(string UserId)
        {
            List <string> items = new List <string>();

            var db  = new Models.MainDBDataContext();
            var ret = (from c in db.AccountBooks
                       where c.UserId == UserId
                       orderby c.SpendDT descending
                       select c.SpendType).Distinct().Take(9);

            if (ret.Count() <= 0)
            {
                //如果沒有資料
                items.Add("餐費");
                items.Add("交通費");
                items.Add("娛樂費");
                items.Add("服裝費");

                return(items);
            }

            items = ret.ToList();

            if ((!items.Contains("餐費")))
            {
                items.Add("餐費");
            }
            if ((!items.Contains("交通費")))
            {
                items.Add("交通費");
            }
            if ((!items.Contains("娛樂費")))
            {
                items.Add("娛樂費");
            }
            if ((!items.Contains("服裝費")))
            {
                items.Add("服裝費");
            }

            return(items);
        }