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 static void UpdateCompany(SqlTransaction trans, MebCompanyPrepay company)
{
string strvalidate = company.cnbValidate?"1":"0";
string strsql = "update tbmebcompanyprepay set cnvcCompanyName='" + company.cnvcCompanyName + "',cnbValidate=" + strvalidate + " where cnvcCompanyID='" + company.cnvcCompanyID.ToString() + "'";
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strsql);
}
private void LoadComponent(string strcompanyid)
{
string strsql = "select * from tbMebCompanyPrepay where cnvccompanyid='" + strcompanyid + "'";
DataTable dt = ReportQueryFacade.CommonQuery(strsql);
if (dt.Rows.Count != 1)
{
throw new Exception("不能获取到单位");
}
MebCompanyPrepay mcp = new MebCompanyPrepay(dt);
this.txtCompanyID.Text = mcp.cnvcCompanyID.ToString();
this.txtCompanyName.Text = mcp.cnvcCompanyName;
this.chkValidate.Checked = mcp.cnbValidate;
}
public static void UpdateCompany(MebCompanyPrepay company, BusiLog busiLog)
{
try
{
BusinessRules.Prepay.PrepayFee prepay = new BusinessRules.Prepay.PrepayFee();
prepay.UpdateCompany(company, busiLog);
}
catch (SqlException sex)
{
LogAdapter.WriteDatabaseException(sex);
throw new Exception("数据库访问异常。");
}
catch (Exception ex)
{
LogAdapter.WriteFeaturesException(ex);
throw new Exception("业务规则层异常。");
}
}
private void AddCompany()
{
MebCompanyPrepay company = new MebCompanyPrepay();
company.cnnPrepayFee = Decimal.Parse(txtPrepayFee.Text);
company.cnvcAcctID = Guid.NewGuid();
company.cnvcCompanyID = Guid.NewGuid();
company.cnvcCompanyName = txtCompanyName.Text;
company.cnvcDeptID = ddlDept.SelectedValue;
company.cnvcDeptName = ddlDept.SelectedItem.Text;
company.cnbValidate = chkValidate.Checked;
Dept curDept = Session[ConstValue.LOGIN_DEPT_SESSION] as Dept;
Oper curOper = Session[ConstValue.LOGIN_USER_SESSION] as Oper;
BusiLog busiLog = new BusiLog();
busiLog.cndOperDate = DateTime.Now;
busiLog.cnnSerial = Guid.NewGuid();
busiLog.cnvcOperName = curOper.cnvcOperName;
busiLog.cnvcComments = "添加单位：" + txtCompanyName.Text;
busiLog.cnvcDeptID = curDept.cnvcDeptID;
busiLog.cnvcDeptName = curDept.cnvcDeptName;
busiLog.cnvcOperType = "BS011";
busiLog.cnvcSource = "网站";
FillFee fee = new FillFee();
fee.cndOperDate = busiLog.cndOperDate;
fee.cnnFillFee = company.cnnPrepayFee;
fee.cnvcAcctID = company.cnvcAcctID;
fee.cnvcCompanyID = company.cnvcCompanyID;
fee.cnvcCompanyName = company.cnvcCompanyName;
fee.cnvcDeptID = company.cnvcDeptID;
fee.cnvcDeptName = company.cnvcDeptName;
fee.cnnSerial = busiLog.cnnSerial;
fee.cnvcOperName = busiLog.cnvcOperName;
PrepayFeeFacade.AddCompany(company, fee, busiLog);
}
private void UpdateCompany()
{
MebCompanyPrepay company = new MebCompanyPrepay();
Guid cid = new Guid(this.txtCompanyID.Text);
company.cnvcCompanyID = cid;
company.cnvcCompanyName = txtCompanyName.Text;
company.cnbValidate = chkValidate.Checked;
Dept curDept = Session[ConstValue.LOGIN_DEPT_SESSION] as Dept;
Oper curOper = Session[ConstValue.LOGIN_USER_SESSION] as Oper;
BusiLog busiLog = new BusiLog();
busiLog.cndOperDate = DateTime.Now;
busiLog.cnnSerial = Guid.NewGuid();
busiLog.cnvcOperName = curOper.cnvcOperName;
busiLog.cnvcComments = "修改单位：" + txtCompanyName.Text;
busiLog.cnvcDeptID = curDept.cnvcDeptID;
busiLog.cnvcDeptName = curDept.cnvcDeptName;
busiLog.cnvcOperType = "BS012";
busiLog.cnvcSource = "网站";
// FillFee fee = new FillFee();
// fee.cndOperDate = busiLog.cndOperDate;
// fee.cnnFillFee = company.cnnPrepayFee;
// fee.cnvcAcctID = company.cnvcAcctID;
// fee.cnvcCompanyID = company.cnvcCompanyID;
// fee.cnvcCompanyName = company.cnvcCompanyName;
// fee.cnvcDeptID = company.cnvcDeptID;
// fee.cnvcDeptName = company.cnvcDeptName;
// fee.cnnSerial = busiLog.cnnSerial;
// fee.cnvcOperName = busiLog.cnvcOperName;
PrepayFeeFacade.UpdateCompany(company, busiLog);
}
public static void UpdateMemberCompany(SqlTransaction trans, MebCompanyPrepay company)
{
string strsql = "update tbMember set cnvcCompanyName='" + company.cnvcCompanyName + "' where cnvcCompanyID='" + company.cnvcCompanyID + "'";
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strsql);
}
// 这里写你的代码
//添加单位
public static void AddCompany(SqlTransaction trans, MebCompanyPrepay company)
{
EntityMapping.Create(company, trans);
}
