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); }