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 static string GetDesignChangeName(int Code) { string solutionName = ""; using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { try { DesignChangeBLL ebll = new DesignChangeBLL(); solutionName = ebll.GetModel(Code, connection).SolutionName; connection.Close(); } catch (SqlException exception) { throw exception; } } return(solutionName); }
public List <DesignChangeModel> GetDesignChangeListOne(int Code) { List <DesignChangeModel> list = new List <DesignChangeModel>(); using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { try { DesignChangeBLL ebll = new DesignChangeBLL(); list.Add(ebll.GetModel(Code, connection)); connection.Close(); } catch (SqlException exception) { throw exception; } } return(list); }
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); }