public static int EditBudgetInfo(BudgetSummary budgetSummary, XBase.Common.UserInfoUtil userinfo)
{
return ProjectBudgetDBHelper.EditBudgetInfo(budgetSummary, userinfo);
}
public static int EditBudgetInfo(BudgetSummary budgetSummary, XBase.Common.UserInfoUtil userinfo)
{
StringBuilder sqlstr = new StringBuilder();
sqlstr.Append(@"update officedba.budgetSummary set
BudgetName=@BudgetName,budgetUnit=@budgetUnit,budgetArea=@budgetArea,
projectID=@projectID,seq=@seq,subBudgetID=@subBudgetID where budgetID=@budgetID");
SqlParameter[] param = {
new SqlParameter("@budgetID",SqlDbType.VarChar,50),
new SqlParameter("@BudgetName",SqlDbType.VarChar,500),
new SqlParameter("@budgetUnit",SqlDbType.Int,4),
new SqlParameter("@budgetArea",SqlDbType.Decimal),
new SqlParameter("@projectID",SqlDbType.Int),
new SqlParameter("@seq",SqlDbType.Int),
new SqlParameter("@subBudgetID",SqlDbType.Int)
};
param[0].Value = budgetSummary.budgetID;
param[1].Value = budgetSummary.BudgetName;
param[2].Value = budgetSummary.budgetUnit;
param[3].Value = budgetSummary.budgetArea;
param[4].Value = budgetSummary.projectid;
param[5].Value = budgetSummary.seq;
param[6].Value = budgetSummary.SubBudgetID;
TransactionManager tran = new TransactionManager();
int num = 0;
tran.BeginTransaction();
try
{
num = SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, sqlstr.ToString(), param);
tran.Commit();
}
catch
{
tran.Rollback();
}
return num;
}