//增加预算 public static bool AddBudget(string budgetDate,double budgetNum) { string sql = String.Format(@"insert into budget(budgetDate,budgetNum) values('{0}',{1})", budgetDate, budgetNum); ManagerHelper mHelper = new ManagerHelper(); return mHelper.ExecuteSql(sql); }
//增加账目 public static bool AddAccount(double accNum,string accDate,int classAccID,int userID,string accCon) { string sql = String.Format(@"insert into account(accNum,accDate,classAccID,userID,accCon) values('{0}','{1}',{2},{3},'{4}')", accNum,accDate,classAccID,userID,accCon); ManagerHelper mHelper = new ManagerHelper(); return mHelper.ExecuteSql(sql); }
//增加分类 public static bool AddAccClass(string classAccName, string classAccInOut) { string sql = String.Format(@"insert into classAcc(classAccName,classAccInOut) values('{0}','{1}')", classAccName, classAccInOut); ManagerHelper mHelper = new ManagerHelper(); return mHelper.ExecuteSql(sql); }
/// <summary> /// 更改账户密码 /// </summary> public static bool UPUserPsd(string userName, string userPsd) { string sql = String.Format("update users set userPsd='{0}' where userName='******'", userPsd, userName); ManagerHelper mHelper = new ManagerHelper(); return mHelper.ExecuteSql(sql); }
//删除预算 public static bool DelBudget(int budgetID) { string sql = String.Format(@"delete budget where budgetID={0}", budgetID); ManagerHelper mHelper = new ManagerHelper(); return mHelper.ExecuteSql(sql); }
//删除账目 public static bool DelAccount(int accID) { string sql = String.Format(@"delete account where accID={0}", accID); ManagerHelper mHelper = new ManagerHelper(); return mHelper.ExecuteSql(sql); }
//删除分类 public static bool DelAccClass(int classAccID) { string sql = String.Format(@"delete classAcc where classAccID={0}", classAccID); ManagerHelper mHelper = new ManagerHelper(); return mHelper.ExecuteSql(sql); }
//修改预算 public static bool UPBudget(string budgetDate, double budgetNum) { string sql = String.Format(@"update budget set budgetNum={0} where budgetDate='{1}'", budgetNum, budgetDate); ManagerHelper mHelper = new ManagerHelper(); return mHelper.ExecuteSql(sql); }
//修改账目 public static bool UPAccount(int accID,double accNum, string accDate, int classAccID, int userID, string accCon) { string sql = String.Format(@"update account set accNum={0},accDate='{1}',classAccID={2},userID={3},accCon='{4}' where accID={5}", accNum, accDate, classAccID, userID, accCon,accID); ManagerHelper mHelper = new ManagerHelper(); return mHelper.ExecuteSql(sql); }
//修改余额下限制 public static bool UPAccLimit(double accLimitNum) { string sql = String.Format(@"update accLimit set accLimitNum={0}", accLimitNum); ManagerHelper mHelper = new ManagerHelper(); return mHelper.ExecuteSql(sql); }