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