public int YFPassAudit(int Code, string number)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
DesignChangeBLL ebll = new DesignChangeBLL();
DesignChangeModel objModel = ebll.GetModel(Code, transaction);
objModel.State = "2";
objModel.Number = number;
num = ebll.Update(objModel, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
public int UpdateAuditMoney(int Code, string ChangeMoneyDescription, decimal TotalMoney)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
try
{
DesignChangeBLL ebll = new DesignChangeBLL();
DesignChangeModel objModel = ebll.GetModel(Code, transaction);
if (!string.IsNullOrEmpty(ChangeMoneyDescription))
{
objModel.ChangeMoney = ChangeMoneyDescription;
objModel.TotalMoney = TotalMoney;
}
num = ebll.Update(objModel, transaction);
transaction.Commit();
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
return(num);
}
finally
{
connection.Close();
}
}
return(num);
}
