//增加预算
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);
}
