public void Save_Click(object sender, AjaxEventArgs e) { LoanInfoDAO loanInfoDAO = new LoanInfoDAO(); LoanInfo loanInfo=new LoanInfo() { ApplicantName=applicantName.Text, ApplicantId=applicantId.Text, Address=address.Text, Salary=int.Parse(salary.Text), LoanValue=int.Parse(loanValue.Text), ReturnDate = returnDate.SelectedDate.ToString("yyyy-MM-dd"), Loanteller=loanteller.Text, AppInfoInputDate=DateTime.Parse(appInfoInputDate.Text) }; // 一、执行业务业务操作,保存业务数据 loanInfoDAO.attachDirty(loanInfo); // 二、开始执行流程操作 IWorkflowSession workflowSession = RuntimeContextExamples.GetRuntimeContext().getWorkflowSession(); try { // 1、创建流程实例 IProcessInstance procInst = workflowSession.createProcessInstance("LoanProcess", this.User.Identity.Name); // 2、设置流程变量/业务属性字段 procInst.setProcessInstanceVariable("sn", loanInfo.Sn);// 设置流水号 procInst.setProcessInstanceVariable("applicantName", loanInfo.ApplicantName);//贷款人姓名 procInst.setProcessInstanceVariable("loanValue", loanInfo.LoanValue);// 贷款数额 // 3、启动流程实例,run()方法启动实例并创建第一个环节实例、分派任务 procInst.run(); } catch { throw; } }
public bool attachDirty(LoanInfo instance) { if (string.IsNullOrEmpty(instance.Id)) { instance.Id = Guid.NewGuid().ToString().Replace("-", ""); string insert = "INSERT INTO T_BIZ_LOANINFO (" + "ID, SN, APPLICANT_NAME, APPLICANT_ID, ADDRESS, " + "SALARY, LOAN_VALUE, RETURN_DATE, LOANTELLER, APP_INFO_INPUT_DATE, " + "SALARY_IS_REAL, CREDIT_STATUS, RISK_FLAG, RISK_EVALUATOR, RISK_INFO_INPUT_DATE, " + "DECISION, EXAMINERLIST, APPROVERLIST, OPPONENTLIST, LEND_MONEY_INFO, " + "LEND_MONEY_OFFICER, LEND_MONEY_INFO_INPUT_TIME, REJECT_INFO, REJECT_INFO_INPUT_TIME )VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24)"; OracleParameter[] insertParms = { OracleHelper.NewOracleParameter(":1", OracleType.VarChar, 50, instance.Id), OracleHelper.NewOracleParameter(":2", OracleType.VarChar, 50, instance.Sn), OracleHelper.NewOracleParameter(":3", OracleType.VarChar, 50, instance.ApplicantName), OracleHelper.NewOracleParameter(":4", OracleType.VarChar, 50, instance.ApplicantId), OracleHelper.NewOracleParameter(":5", OracleType.VarChar, 256, instance.Address), OracleHelper.NewOracleParameter(":6", OracleType.Int32, instance.Salary), OracleHelper.NewOracleParameter(":7", OracleType.Int32, instance.LoanValue), OracleHelper.NewOracleParameter(":8", OracleType.VarChar, 10, instance.ReturnDate), OracleHelper.NewOracleParameter(":9", OracleType.VarChar, 50, instance.Loanteller), OracleHelper.NewOracleParameter(":10", OracleType.Timestamp, 11, instance.AppInfoInputDate), OracleHelper.NewOracleParameter(":11", OracleType.Int16, OracleHelper.OraBit(instance.SalaryIsReal)), OracleHelper.NewOracleParameter(":12", OracleType.Int16, OracleHelper.OraBit(instance.CreditStatus)), OracleHelper.NewOracleParameter(":13", OracleType.Int16, OracleHelper.OraBit(instance.RiskFlag)), OracleHelper.NewOracleParameter(":14", OracleType.VarChar, 50, instance.RiskEvaluator), OracleHelper.NewOracleParameter(":15", OracleType.Timestamp, 11, instance.RiskInfoInputDate), OracleHelper.NewOracleParameter(":16", OracleType.Int16, OracleHelper.OraBit(instance.Decision)), OracleHelper.NewOracleParameter(":17", OracleType.VarChar, 128, instance.ExaminerList), OracleHelper.NewOracleParameter(":18", OracleType.VarChar, 128, instance.ApproverList), OracleHelper.NewOracleParameter(":19", OracleType.VarChar, 128, instance.OpponentList), OracleHelper.NewOracleParameter(":20", OracleType.VarChar, 256, instance.LendMoneyInfo), OracleHelper.NewOracleParameter(":21", OracleType.VarChar, 50, instance.LendMoneyOfficer), OracleHelper.NewOracleParameter(":22", OracleType.Timestamp, 11, instance.LendMoneyInfoInputTime), OracleHelper.NewOracleParameter(":23", OracleType.VarChar, 256, instance.RejectInfo), OracleHelper.NewOracleParameter(":24", OracleType.Timestamp, 11, instance.RejectInfoInputTime) }; if (OracleHelper.ExecuteNonQuery(connectionString, CommandType.Text, insert, insertParms) != 1) return false; else return true; } else { string update = "UPDATE T_BIZ_LOANINFO SET " + "APPLICANT_NAME=:3, APPLICANT_ID=:4, ADDRESS=:5, SALARY=:6, " + "LOAN_VALUE=:7, RETURN_DATE=:8, LOANTELLER=:9, APP_INFO_INPUT_DATE=:10, SALARY_IS_REAL=:11, " + "CREDIT_STATUS=:12, RISK_FLAG=:13, RISK_EVALUATOR=:14, RISK_INFO_INPUT_DATE=:15, DECISION=:16, " + "EXAMINERLIST=:17, APPROVERLIST=:18, OPPONENTLIST=:19, LEND_MONEY_INFO=:20, LEND_MONEY_OFFICER=:21, " + "LEND_MONEY_INFO_INPUT_TIME=:22, REJECT_INFO=:23, REJECT_INFO_INPUT_TIME=:24" + " WHERE ID=:1"; OracleParameter[] updateParms = { //OracleHelper.NewOracleParameter(":2", OracleType.VarChar, 50, instance.Sn), OracleHelper.NewOracleParameter(":3", OracleType.VarChar, 50, instance.ApplicantName), OracleHelper.NewOracleParameter(":4", OracleType.VarChar, 50, instance.ApplicantId), OracleHelper.NewOracleParameter(":5", OracleType.VarChar, 256, instance.Address), OracleHelper.NewOracleParameter(":6", OracleType.Int32, instance.Salary), OracleHelper.NewOracleParameter(":7", OracleType.Int32, instance.LoanValue), OracleHelper.NewOracleParameter(":8", OracleType.VarChar, 10, instance.ReturnDate), OracleHelper.NewOracleParameter(":9", OracleType.VarChar, 50, instance.Loanteller), OracleHelper.NewOracleParameter(":10", OracleType.Timestamp, 11, instance.AppInfoInputDate), OracleHelper.NewOracleParameter(":11", OracleType.Int16, OracleHelper.OraBit(instance.SalaryIsReal)), OracleHelper.NewOracleParameter(":12", OracleType.Int16, OracleHelper.OraBit(instance.CreditStatus)), OracleHelper.NewOracleParameter(":13", OracleType.Int16, OracleHelper.OraBit(instance.RiskFlag)), OracleHelper.NewOracleParameter(":14", OracleType.VarChar, 50, instance.RiskEvaluator), OracleHelper.NewOracleParameter(":15", OracleType.Timestamp, 11, instance.RiskInfoInputDate), OracleHelper.NewOracleParameter(":16", OracleType.Int16, OracleHelper.OraBit(instance.Decision)), OracleHelper.NewOracleParameter(":17", OracleType.VarChar, 128, instance.ExaminerList), OracleHelper.NewOracleParameter(":18", OracleType.VarChar, 128, instance.ApproverList), OracleHelper.NewOracleParameter(":19", OracleType.VarChar, 128, instance.OpponentList), OracleHelper.NewOracleParameter(":20", OracleType.VarChar, 256, instance.LendMoneyInfo), OracleHelper.NewOracleParameter(":21", OracleType.VarChar, 50, instance.LendMoneyOfficer), OracleHelper.NewOracleParameter(":22", OracleType.Timestamp, 11, instance.LendMoneyInfoInputTime), OracleHelper.NewOracleParameter(":23", OracleType.VarChar, 256, instance.RejectInfo), OracleHelper.NewOracleParameter(":24", OracleType.Timestamp, 11, instance.RejectInfoInputTime), OracleHelper.NewOracleParameter(":1", OracleType.VarChar, 50, instance.Id) }; if (OracleHelper.ExecuteNonQuery(connectionString, CommandType.Text, update, updateParms) != 1) return false; else return true; } }
public bool attachDirty(LoanInfo instance) { if (string.IsNullOrEmpty(instance.Id)) { instance.Id = Guid.NewGuid().ToString().Replace("-", ""); string insert = "INSERT INTO T_BIZ_LOANINFO (" + "ID, SN, APPLICANT_NAME, APPLICANT_ID, ADDRESS, " + "SALARY, LOAN_VALUE, RETURN_DATE, LOANTELLER, APP_INFO_INPUT_DATE, " + "SALARY_IS_REAL, CREDIT_STATUS, RISK_FLAG, RISK_EVALUATOR, RISK_INFO_INPUT_DATE, " + "DECISION, EXAMINERLIST, APPROVERLIST, OPPONENTLIST, LEND_MONEY_INFO, " + "LEND_MONEY_OFFICER, LEND_MONEY_INFO_INPUT_TIME, REJECT_INFO, REJECT_INFO_INPUT_TIME )VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24)"; OracleParameter[] insertParms = { OracleHelper.NewOracleParameter(":1", OracleType.VarChar, 50, instance.Id), OracleHelper.NewOracleParameter(":2", OracleType.VarChar, 50, instance.Sn), OracleHelper.NewOracleParameter(":3", OracleType.VarChar, 50, instance.ApplicantName), OracleHelper.NewOracleParameter(":4", OracleType.VarChar, 50, instance.ApplicantId), OracleHelper.NewOracleParameter(":5", OracleType.VarChar, 256, instance.Address), OracleHelper.NewOracleParameter(":6", OracleType.Int32, instance.Salary), OracleHelper.NewOracleParameter(":7", OracleType.Int32, instance.LoanValue), OracleHelper.NewOracleParameter(":8", OracleType.VarChar, 10, instance.ReturnDate), OracleHelper.NewOracleParameter(":9", OracleType.VarChar, 50, instance.Loanteller), OracleHelper.NewOracleParameter(":10", OracleType.Timestamp, 11, instance.AppInfoInputDate), OracleHelper.NewOracleParameter(":11", OracleType.Int16, OracleHelper.OraBit(instance.SalaryIsReal)), OracleHelper.NewOracleParameter(":12", OracleType.Int16, OracleHelper.OraBit(instance.CreditStatus)), OracleHelper.NewOracleParameter(":13", OracleType.Int16, OracleHelper.OraBit(instance.RiskFlag)), OracleHelper.NewOracleParameter(":14", OracleType.VarChar, 50, instance.RiskEvaluator), OracleHelper.NewOracleParameter(":15", OracleType.Timestamp, 11, instance.RiskInfoInputDate), OracleHelper.NewOracleParameter(":16", OracleType.Int16, OracleHelper.OraBit(instance.Decision)), OracleHelper.NewOracleParameter(":17", OracleType.VarChar, 128, instance.ExaminerList), OracleHelper.NewOracleParameter(":18", OracleType.VarChar, 128, instance.ApproverList), OracleHelper.NewOracleParameter(":19", OracleType.VarChar, 128, instance.OpponentList), OracleHelper.NewOracleParameter(":20", OracleType.VarChar, 256, instance.LendMoneyInfo), OracleHelper.NewOracleParameter(":21", OracleType.VarChar, 50, instance.LendMoneyOfficer), OracleHelper.NewOracleParameter(":22", OracleType.Timestamp, 11, instance.LendMoneyInfoInputTime), OracleHelper.NewOracleParameter(":23", OracleType.VarChar, 256, instance.RejectInfo), OracleHelper.NewOracleParameter(":24", OracleType.Timestamp, 11, instance.RejectInfoInputTime) }; if (OracleHelper.ExecuteNonQuery(connectionString, CommandType.Text, insert, insertParms) != 1) { return(false); } else { return(true); } } else { string update = "UPDATE T_BIZ_LOANINFO SET " + "APPLICANT_NAME=:3, APPLICANT_ID=:4, ADDRESS=:5, SALARY=:6, " + "LOAN_VALUE=:7, RETURN_DATE=:8, LOANTELLER=:9, APP_INFO_INPUT_DATE=:10, SALARY_IS_REAL=:11, " + "CREDIT_STATUS=:12, RISK_FLAG=:13, RISK_EVALUATOR=:14, RISK_INFO_INPUT_DATE=:15, DECISION=:16, " + "EXAMINERLIST=:17, APPROVERLIST=:18, OPPONENTLIST=:19, LEND_MONEY_INFO=:20, LEND_MONEY_OFFICER=:21, " + "LEND_MONEY_INFO_INPUT_TIME=:22, REJECT_INFO=:23, REJECT_INFO_INPUT_TIME=:24" + " WHERE ID=:1"; OracleParameter[] updateParms = { //OracleHelper.NewOracleParameter(":2", OracleType.VarChar, 50, instance.Sn), OracleHelper.NewOracleParameter(":3", OracleType.VarChar, 50, instance.ApplicantName), OracleHelper.NewOracleParameter(":4", OracleType.VarChar, 50, instance.ApplicantId), OracleHelper.NewOracleParameter(":5", OracleType.VarChar, 256, instance.Address), OracleHelper.NewOracleParameter(":6", OracleType.Int32, instance.Salary), OracleHelper.NewOracleParameter(":7", OracleType.Int32, instance.LoanValue), OracleHelper.NewOracleParameter(":8", OracleType.VarChar, 10, instance.ReturnDate), OracleHelper.NewOracleParameter(":9", OracleType.VarChar, 50, instance.Loanteller), OracleHelper.NewOracleParameter(":10", OracleType.Timestamp, 11, instance.AppInfoInputDate), OracleHelper.NewOracleParameter(":11", OracleType.Int16, OracleHelper.OraBit(instance.SalaryIsReal)), OracleHelper.NewOracleParameter(":12", OracleType.Int16, OracleHelper.OraBit(instance.CreditStatus)), OracleHelper.NewOracleParameter(":13", OracleType.Int16, OracleHelper.OraBit(instance.RiskFlag)), OracleHelper.NewOracleParameter(":14", OracleType.VarChar, 50, instance.RiskEvaluator), OracleHelper.NewOracleParameter(":15", OracleType.Timestamp, 11, instance.RiskInfoInputDate), OracleHelper.NewOracleParameter(":16", OracleType.Int16, OracleHelper.OraBit(instance.Decision)), OracleHelper.NewOracleParameter(":17", OracleType.VarChar, 128, instance.ExaminerList), OracleHelper.NewOracleParameter(":18", OracleType.VarChar, 128, instance.ApproverList), OracleHelper.NewOracleParameter(":19", OracleType.VarChar, 128, instance.OpponentList), OracleHelper.NewOracleParameter(":20", OracleType.VarChar, 256, instance.LendMoneyInfo), OracleHelper.NewOracleParameter(":21", OracleType.VarChar, 50, instance.LendMoneyOfficer), OracleHelper.NewOracleParameter(":22", OracleType.Timestamp, 11, instance.LendMoneyInfoInputTime), OracleHelper.NewOracleParameter(":23", OracleType.VarChar, 256, instance.RejectInfo), OracleHelper.NewOracleParameter(":24", OracleType.Timestamp, 11, instance.RejectInfoInputTime), OracleHelper.NewOracleParameter(":1", OracleType.VarChar, 50, instance.Id) }; if (OracleHelper.ExecuteNonQuery(connectionString, CommandType.Text, update, updateParms) != 1) { return(false); } else { return(true); } } }
public LoanInfo findBySn(Object sn) { string select = "SELECT * FROM t_biz_loaninfo WHERE SN=:1"; OracleConnection conn = new OracleConnection(connectionString); OracleDataReader reader = null; try { OracleParameter[] selectParms = { OracleHelper.NewOracleParameter(":1", OracleType.VarChar, 50, sn) }; reader = OracleHelper.ExecuteReader(conn, CommandType.Text, select, selectParms); if (reader.Read()) { LoanInfo _LoanInfo = new LoanInfo() { Id = Convert.ToString(reader["id"]), Sn = Convert.ToString(reader["sn"]), ApplicantName = Convert.ToString(reader["applicant_name"]), ApplicantId = Convert.ToString(reader["applicant_id"]), Address = Convert.ToString(reader["address"]), Salary = Convert.ToInt32(reader["salary"]), LoanValue = Convert.ToInt32(reader["loan_value"]), ReturnDate = Convert.ToString(reader["return_date"]), Loanteller = Convert.ToString(reader["loanteller"]), AppInfoInputDate = Convert.ToDateTime(reader["app_info_input_date"]), SalaryIsReal = Convert.ToInt32(reader["salary_is_real"]) == 1 ? true : false,// Convert.ToBoolean(reader["SALARY_IS_REAL"]), CreditStatus = Convert.ToInt32(reader["credit_status"]) == 1 ? true : false,//Convert.ToBoolean(reader["credit_status"]), RiskFlag = Convert.ToInt32(reader["risk_flag"]) == 1 ? true : false,//Convert.ToBoolean(reader["risk_flag"]), RiskEvaluator = Convert.ToString(reader["risk_evaluator"]), RiskInfoInputDate = Convert.ToDateTime(reader["risk_info_input_date"]), Decision = Convert.ToInt32(reader["decision"]) == 1 ? true : false,//Convert.ToBoolean(reader["decision"]), ExaminerList = Convert.ToString(reader["examinerList"]), ApproverList = Convert.ToString(reader["approverList"]), OpponentList = Convert.ToString(reader["opponentList"]), LendMoneyInfo = Convert.ToString(reader["lend_money_info"]), LendMoneyOfficer = Convert.ToString(reader["lend_money_officer"]), LendMoneyInfoInputTime = Convert.ToDateTime(reader["lend_money_info_input_time"]), RejectInfo = Convert.ToString(reader["reject_info"]), RejectInfoInputTime = Convert.ToDateTime(reader["reject_info_input_time"]), }; return _LoanInfo; } } catch { throw; } finally { if (reader != null) reader.Close(); if (conn.State != ConnectionState.Closed) { conn.Close(); conn.Dispose(); } } return null; }
public LoanInfo findBySn(Object sn) { string select = "SELECT * FROM t_biz_loaninfo WHERE SN=:1"; OracleConnection conn = new OracleConnection(connectionString); OracleDataReader reader = null; try { OracleParameter[] selectParms = { OracleHelper.NewOracleParameter(":1", OracleType.VarChar, 50, sn) }; reader = OracleHelper.ExecuteReader(conn, CommandType.Text, select, selectParms); if (reader.Read()) { LoanInfo _LoanInfo = new LoanInfo() { Id = Convert.ToString(reader["id"]), Sn = Convert.ToString(reader["sn"]), ApplicantName = Convert.ToString(reader["applicant_name"]), ApplicantId = Convert.ToString(reader["applicant_id"]), Address = Convert.ToString(reader["address"]), Salary = Convert.ToInt32(reader["salary"]), LoanValue = Convert.ToInt32(reader["loan_value"]), ReturnDate = Convert.ToString(reader["return_date"]), Loanteller = Convert.ToString(reader["loanteller"]), AppInfoInputDate = Convert.ToDateTime(reader["app_info_input_date"]), SalaryIsReal = Convert.ToInt32(reader["salary_is_real"]) == 1 ? true : false, // Convert.ToBoolean(reader["SALARY_IS_REAL"]), CreditStatus = Convert.ToInt32(reader["credit_status"]) == 1 ? true : false, //Convert.ToBoolean(reader["credit_status"]), RiskFlag = Convert.ToInt32(reader["risk_flag"]) == 1 ? true : false, //Convert.ToBoolean(reader["risk_flag"]), RiskEvaluator = Convert.ToString(reader["risk_evaluator"]), RiskInfoInputDate = Convert.ToDateTime(reader["risk_info_input_date"]), Decision = Convert.ToInt32(reader["decision"]) == 1 ? true : false,//Convert.ToBoolean(reader["decision"]), ExaminerList = Convert.ToString(reader["examinerList"]), ApproverList = Convert.ToString(reader["approverList"]), OpponentList = Convert.ToString(reader["opponentList"]), LendMoneyInfo = Convert.ToString(reader["lend_money_info"]), LendMoneyOfficer = Convert.ToString(reader["lend_money_officer"]), LendMoneyInfoInputTime = Convert.ToDateTime(reader["lend_money_info_input_time"]), RejectInfo = Convert.ToString(reader["reject_info"]), RejectInfoInputTime = Convert.ToDateTime(reader["reject_info_input_time"]), }; return(_LoanInfo); } } catch { throw; } finally { if (reader != null) { reader.Close(); } if (conn.State != ConnectionState.Closed) { conn.Close(); conn.Dispose(); } } return(null); }