public int DeleteSpecialOilDept(SpecialOilDept specialOilDept, BusiLog busiLog)
{
//SqlConnection conn = ConnectionPool.BorrowConnection();
int iRet = 0;
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
iRet = SpecialOilDeptAccess.DeleteSpecialOilDept(trans, specialOilDept);
BusiLogAccess.AddBusiLog(trans, busiLog);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
return(iRet);
}
public void UpdateCompany(MebCompanyPrepay company, BusiLog busiLog)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
MebCompanyPrepayAccess.UpdateCompany(trans, company);
//FillFeeAccess.AddFee(trans,fee);
MemberAccess.UpdateMemberCompany(trans, company);
BusiLogAccess.AddBusiLog(trans, busiLog);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public void AddFee(FillFee fee, BusiLog busiLog)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, "update tbMebCompanyPrepay set cnnPrepayFee = cnnPrepayFee+" + fee.cnnFillFee.ToString() + " where cnvcCompanyID='" + fee.cnvcCompanyID.ToString() + "'");
FillFeeAccess.AddFee(trans, fee);
BusiLogAccess.AddBusiLog(trans, busiLog);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public int AddOilPrice(OilPrice price, BusiLog busiLog)
{
//SqlConnection conn = ConnectionPool.BorrowConnection();
int iRet = 0;
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
BusiLogAccess.AddBusiLog(trans, busiLog);
iRet = (int)OilPriceAccess.AddOilPrice(trans, price);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
return(iRet);
}
public void AddDept(Dept dept, BusiLog busiLog)
{
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
DeptAccess.AddDept(trans, dept);
BusiLogAccess.AddBusiLog(trans, busiLog);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
}
public int UpdatePwd(Oper oper, BusiLog busiLog)
{
//SqlConnection conn = ConnectionPool.BorrowConnection();
int iRet = 0;
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
iRet = OperAccess.UpdatePwd(trans, oper);
BusiLogAccess.AddBusiLog(trans, busiLog);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
return(iRet);
}
public int UpdateDept(Dept dept, BusiLog busiLog)
{
//SqlConnection conn = ConnectionPool.BorrowConnection();
int iRet = 0;
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
BusiLogAccess.AddBusiLog(trans, busiLog);
Dept olddept = new Dept();
olddept.cnvcDeptID = dept.cnvcDeptID;
olddept = EntityMapping.Get(olddept, trans) as Dept;
olddept.cnbValidate = dept.cnbValidate;
olddept.cnvcDeptName = dept.cnvcDeptName;
olddept.cnvcParentDeptID = dept.cnvcParentDeptID;
iRet = DeptAccess.UpdateDept(trans, olddept);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
return(iRet);
}
public int AddOper(Oper oper, BusiLog busiLog)
{
int iRet = 0;
using (SqlConnection conn = ConnectionPool.BorrowConnection())
{
//conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
iRet = OperIDAccess.GetOperID(trans);
oper.cnnOperID = iRet;
oper.cnvcPwd = DataSecurity.Encrypt(oper.cnvcPwd);
OperAccess.AddOper(trans, oper);
BusiLogAccess.AddBusiLog(trans, busiLog);
trans.Commit();
}
catch (SqlException sex)
{
trans.Rollback();
throw sex;
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
ConnectionPool.ReturnConnection(conn);
}
}
return(iRet);
}
