private void GetInvolvedEmployeesData()
{
txtMemo.Text = "";
lblReplayFrom.Text = Training_Source.TrainingClass.Employee_Name(ViewState["Employee_Number"].ToString());
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("basdba.PKG_Training.Get_Possible_CommEEs", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
conn.Open();
try
{
int intFileLen = txtMemo.Text.Length;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "Communication_record_id_", "number", "in", ViewState["comm_record_id"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "user_employee_number_", "number", "in", ViewState["Employee_Number"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "sprvsr_employee_number_", "varchar2", "out", "", 100);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "sprvsr_name_", "varchar2", "out", "", 100);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "payor_employee_number_", "varchar2", "out", "", 100);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "payor_name_", "varchar2", "out", "", 100);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "applicant_employee_number_", "varchar2", "out", "", 100);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "applicant_name_", "varchar2", "out", "", 100);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "from_employee_number_", "varchar2", "out", "", 100);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "from_name_", "varchar2", "out", "", 100);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "from_position_", "varchar2", "out", "", 100);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "to_employee_number_", "varchar2", "out", "", 100);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "to_name_", "varchar2", "out", "", 100);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "to_position_", "varchar2", "out", "", 100);
cmd.ExecuteNonQuery();
lblFromPosition.Text = cmd.Parameters["from_position_"].Value.ToString();
lblFromName.Text = cmd.Parameters["from_name_"].Value.ToString();
lblToPosition.Text = cmd.Parameters["to_position_"].Value.ToString();
lblToName.Text = cmd.Parameters["to_name_"].Value.ToString();
chklstEmailTo.Items.Clear();
if (cmd.Parameters["sprvsr_employee_number_"].Value != null)
{
AddItemToSelection("Supervisor", cmd.Parameters["sprvsr_employee_number_"].Value.ToString(), cmd.Parameters["sprvsr_name_"].Value.ToString());
}
if (cmd.Parameters["payor_employee_number_"].Value != null)
{
AddItemToSelection("Administrator", cmd.Parameters["payor_employee_number_"].Value.ToString(), cmd.Parameters["payor_name_"].Value.ToString());
}
if (cmd.Parameters["applicant_employee_number_"].Value != null)
{
AddItemToSelection("Applicant", cmd.Parameters["applicant_employee_number_"].Value.ToString(), cmd.Parameters["applicant_name_"].Value.ToString());
}
}
finally
{
cmd.Dispose();
conn.Close();
conn.Dispose();
}
}
private bool DoSave()
{
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
conn.Open();
Oracle.DataAccess.Client.OracleTransaction txn = conn.BeginTransaction();
bool blnOk = true;
try
{
for (int i = 0; i < chklstEmailTo.Items.Count; i++)
{
if (chklstEmailTo.Items[i].Selected)
{
SaveOne(conn, chklstEmailTo.Items[i].Value);
}
}
txn.Commit();
}
catch
{
txn.Rollback();
blnOk = false;
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
return(blnOk);
}
protected void btnFullPaymentApproval_Click(object sender, EventArgs e)
{
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
conn.Open();
bool blnOk = true;
Oracle.DataAccess.Client.OracleTransaction txn = conn.BeginTransaction();
try
{
SaveApproval(conn);
SaveCSA(conn);
txn.Commit();
}
catch
{
txn.Rollback();
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
lblScript.Text = "<script>alert('Your decision has been saved.');document.location.replace('PayorPendingApprovals.aspx?SkipCheck=YES')</script>";
}
protected void btnSave_Click(object sender, EventArgs e)
{
reasonMessage();
if (txtMemo.Text == "")
{
ShowError("You must fill the reason for partial payment of the approved amount.");
return;
}
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
conn.Open();
Oracle.DataAccess.Client.OracleTransaction txn = conn.BeginTransaction();
try
{
SaveCSA(conn);
if (DoSave(conn))
{
lblScript.Text = "<script>alert('Your decision has been saved.');document.location.replace('PayorPendingApprovals.aspx?SkipCheck=YES')</script>";
txn.Commit();
}
else
{
txn.Rollback();
}
}
catch
{
txn.Rollback();
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
}
private void FillReasonCheckBoxList()
{
System.Data.DataTable dTable;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
Oracle.DataAccess.Client.OracleCommand cmd =
new Oracle.DataAccess.Client.OracleCommand("pkg_training.reason_for_admin_partial_list", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "reason_list_", "cursor", "out", "");
Oracle.DataAccess.Client.OracleDataAdapter da =
new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
DataSet mds = new DataSet();
conn.Open();
try
{
da.Fill(mds, "Purpose");
dTable = mds.Tables["Purpose"];
chklstReasons.Items.Clear();
foreach (DataRow dr in dTable.Rows)
{
ListItem li = new ListItem(dr["description"].ToString(), dr["record_id"].ToString());
chklstReasons.Items.Add(li);
}
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
da.Dispose();
mds.Dispose();
dTable = null;
}
}
private DataTable GetGridTable()
{
DataTable tbl = null;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("pkg_trn_budget.budget_detail_list", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "employee_number_", Request.Params["ee"]);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "processing_year_", ddlBudgetYear.SelectedItem.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "budget_list_", "cursor", "out", "");
DataSet mds = new DataSet();
Oracle.DataAccess.Client.OracleDataAdapter da = new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
try
{
conn.Open();
da.Fill(mds);
tbl = mds.Tables[0];
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
mds.Dispose();
}
return(tbl);
}
private void DoDelete()
{
if (!Training_Source.TrainingClass.IsReadOnly(Request.Cookies["Session_ID"].Value.ToString()))
{
string strProcedure = "basdba.PKG_Training.deleteExpense";
if (Request.Params["Admin"] == "YES")
{
strProcedure = "basdba.PKG_Training.deleteExpense_Admin";
}
string strIndex = SQLStatic.Sessions.GetSessionValue(Request.Cookies["Session_ID"].Value.ToString(), "deleteIndex", Training_Source.TrainingClass.ConnectioString);
SQLStatic.Sessions.SetSessionValue(Request.Cookies["Session_ID"].Value.ToString(), "deleteIndex", "", Training_Source.TrainingClass.ConnectioString);
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(strProcedure, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
try
{
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "record_id_", "number", "in", strIndex);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "user_id_", "varchar2", "in", ViewState["User_Name"].ToString());
conn.Open();
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
}
}
}
private void GetNote()
{
string strSQL = "select t.note,t.expense_type from trn_ee_rqst_expns t where t.record_id=" + Request.Params["rid"];
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(strSQL, conn);
conn.Open();
Oracle.DataAccess.Client.OracleDataReader reader = null;
try
{
reader = cmd.ExecuteReader();
reader.Read();
txtDescribtion.Text = reader.GetValue(0).ToString();
lblExpenseType.Text = reader.GetValue(1).ToString();
}
finally
{
if (reader != null)
{
reader.Dispose();
}
cmd.Dispose();
conn.Dispose();
}
txtDescribtion.Text = SQLStatic.SQL.ExecScaler(strSQL, Training_Source.TrainingClass.ConnectioString).ToString();
txtRemaining.Text = (4000 - txtDescribtion.Text.Length).ToString();
}
public string First_step_in_wizard()
{
string FirststepinWiz = null;
string sessID = Request.Cookies["Session_ID"].Value.ToString();
// create the command for the function
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand();
Oracle.DataAccess.Client.OracleConnection conn =
new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
cmd.Connection = conn;
cmd.CommandText = "pkg_wizard.First_step_in_wizard";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
cmd.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("session_id_", Oracle.DataAccess.Client.OracleDbType.Varchar2, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, sessID));
cmd.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("first_step_id_", Oracle.DataAccess.Client.OracleDbType.Double, 20, System.Data.ParameterDirection.Output, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
cmd.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("first_step_url_", Oracle.DataAccess.Client.OracleDbType.Varchar2, 255, System.Data.ParameterDirection.Output, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
// execute the function
conn.Open();
cmd.ExecuteNonQuery();
FirststepinWiz = Convert.ToString(cmd.Parameters[2].Value);
cmd.Dispose();
conn.Close();
conn.Dispose();
return(FirststepinWiz);
}
private bool DoSave()
{
string strProcedureName = "basdba.PKG_Training.SupervisorCancelRequest";
if (Request.Params["who"] == "payor")
{
strProcedureName = "basdba.PKG_Training.AdministratorCancelRequest";
}
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(strProcedureName, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
conn.Open();
bool blnOk = true;
try
{
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "record_id_", "number", "in", ViewState["Request_Record_ID"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "reason_", "varchar2", "in", txtOther.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "user_id_", "varchar2", "in", ViewState["User_Name"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "error_msg_", "varchar2", "out", "");
cmd.ExecuteNonQuery();
if ((cmd.Parameters["error_msg_"].Value != null) && (cmd.Parameters["error_msg_"].Value.ToString() != ""))
{
blnOk = false;
ShowError(cmd.Parameters["error_msg_"].Value.ToString());
}
}
finally
{
cmd.Dispose();
conn.Close();
conn.Dispose();
}
return(blnOk);
}
public clsOracle()
{
string p_conn_db = "Data Source=localhost:1521/XE;User ID=C##BSN_SISPK;PASSWORD=BsnPassword1;";
connOracle = new Oracle.DataAccess.Client.OracleConnection(p_conn_db);
connOracle.Open();
}
private DataTable GetTable()
{
DataTable tbl = null;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(ConnectionString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("pkg_training_2.employeeslist_sup", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "admin_ee_number", "number", "in", ViewState["Employee_Number"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "retresult_", "cursor", "out", "");
DataSet mds = new DataSet();
Oracle.DataAccess.Client.OracleDataAdapter da = new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
try
{
conn.Open();
da.Fill(mds);
tbl = mds.Tables[0];
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
mds.Dispose();
}
return(tbl);
}
private void DoSave()
{
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("basdba.PKG_Training.CancelPaidRequest", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
try
{
string strUserID = "";
if (ViewState["User_Name"] != null)
{
strUserID = ViewState["User_Name"].ToString();
}
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "record_id_", "number", "in", ViewState["Request_Record_ID"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "reason_", "varchar2", "in", txtReason.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "user_id_", "varchar2", "in", strUserID);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "error_msg_", "varchar2", "out", null);
conn.Open();
cmd.ExecuteNonQuery();
}
finally
{
cmd.Dispose();
conn.Close();
conn.Dispose();
}
}
private void FillExpenseType()
{
ddlExpenseType.Items.Clear();
DataTable tbl = null;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("BASDBA.pkg_training.GetExpenseTypes", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "header_record_id_", ViewState["Request_Record_ID"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "Expenses_List_", "cursor", "out", "");
DataSet mds = new DataSet();
Oracle.DataAccess.Client.OracleDataAdapter da = new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
try
{
conn.Open();
da.Fill(mds);
tbl = mds.Tables[0];
foreach (DataRow dr in tbl.Rows)
{
ListItem li = new ListItem(dr["description"].ToString(), dr["record_id"].ToString());
ddlExpenseType.Items.Add(li);
}
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
mds.Dispose();
tbl.Dispose();
}
}
private DataTable GetExpenseTable()
{
DataTable tbl = null;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("BASDBA.pkg_training.GetEmployeeExpenses", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "header_record_id_", ViewState["Request_Record_ID"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "Expenses_List_", "cursor", "out", "");
DataSet mds = new DataSet();
Oracle.DataAccess.Client.OracleDataAdapter da = new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
try
{
conn.Open();
da.Fill(mds);
tbl = mds.Tables[0];
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
mds.Dispose();
}
return(tbl);
}
private DataTable GetGridTable()
{
DataTable tbl = null;
string strProcedureName = "BASDBA.pkg_training.History_List";
if (ViewState["Product_Code"].ToString() == "11001")
{
strProcedureName = "BASDBA.pkg_training_cdp.History_List";
}
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(ConnectionString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(strProcedureName, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "header_record_id_", ViewState["Request_Record_ID"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "hstList_", "cursor", "out", "");
DataSet mds = new DataSet();
Oracle.DataAccess.Client.OracleDataAdapter da = new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
try
{
conn.Open();
da.Fill(mds);
tbl = mds.Tables[0];
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
mds.Dispose();
}
return(tbl);
}
private DataTable GetDataTable()
{
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("BASDBA.pkg_trn_fdic.get_evaluation_questions", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "questions_list_", "cursor", "out", "");
DataSet mds = new DataSet();
Oracle.DataAccess.Client.OracleDataAdapter da = new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
DataTable tbl;
try
{
conn.Open();
da.Fill(mds);
tbl = mds.Tables[0];
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
mds.Dispose();
}
return(tbl);
}
public static DataTable GetHistoryTable(string strRecord_id)
{
DataTable tbl = null;
string strProcedureName = "BASDBA.pkg_training.History_List";
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Report.Data.ConnectioString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(strProcedureName, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "header_record_id_", strRecord_id);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "hstList_", "cursor", "out", "");
DataSet mds = new DataSet();
Oracle.DataAccess.Client.OracleDataAdapter da = new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
try
{
conn.Open();
da.Fill(mds);
tbl = mds.Tables[0];
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
mds.Dispose();
}
return(tbl);
}
public OracleTransformationProvider(Dialect dialect, string connectionString)
: base(dialect, connectionString)
{
connection = new OracleConnection();
connection.ConnectionString = base.connectionString;
connection.Open();
}
private void GetCDAnswerList()
{
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("BASDBA.pkg_trn_fdic.get_evaluation_cd_answr", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "questions_list_", "cursor", "out", "");
DataSet mds = new DataSet();
Oracle.DataAccess.Client.OracleDataAdapter da = new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
DataTable tbl = null;
try
{
conn.Open();
da.Fill(mds);
tbl = mds.Tables[0];
foreach (DataRow dr in tbl.Rows)
{
ListItem li = new ListItem(dr["answer"].ToString(), dr["record_id"].ToString());
lbAnweres.Items.Add(li);
}
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
mds.Dispose();
if (tbl != null)
{
tbl.Dispose();
}
}
}
public static void CheckBudgetForApproval(string strheader_record_id, string strCurseExpense,
ref string returned_condintion, ref string returned_test)
{
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Data.ConnectioString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("BASDBA.pkg_trn_budget.checbudgetbeforeapproval_ee", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "pla_header_record_id_", strheader_record_id);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "course_expense_", strCurseExpense);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "return_condition_", "varchar2", "out", null, 10);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "return_condition_text_", "varchar2", "out", null, 4000);
conn.Open();
try
{
cmd.ExecuteNonQuery();
returned_condintion = cmd.Parameters["return_condition_"].Value.ToString();
if (returned_condintion != "1")
{
returned_test = cmd.Parameters["return_condition_text_"].Value.ToString();
}
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
}
}
private DataTable GetTable3()
{
DataTable tbl = null;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("BASDBA.PKG_Training.employee_Number_List3", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "record_id_", ViewState["Employee_Number"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "search_name_", txtSearch.Text.Replace("'", "''"));
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "emails_list_", "cursor", "out", "");
DataSet mds = new DataSet();
Oracle.DataAccess.Client.OracleDataAdapter da = new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
try
{
conn.Open();
da.Fill(mds);
tbl = mds.Tables[0];
RemoveSupervisor(tbl);
CleanUpTable(tbl);
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
mds.Dispose();
}
return(tbl);
}
private bool SetEmployeeNumber()
{
bool eeFound = true;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("pkg_training.set_employee_number", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "User_id_", ViewState["User_ID"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "Session_id_", Request.Cookies["Session_ID"].Value.ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "employee_number_", "varchar2", "out", null, 20);
try
{
conn.Open();
cmd.ExecuteNonQuery();
if (cmd.Parameters["employee_number_"].Value == null)
{
eeFound = false;
}
else
{
ViewState["Employee_Number"] = cmd.Parameters["employee_number_"].Value.ToString();
}
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
}
return(eeFound);
}
private bool DoSave()
{
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
conn.Open();
bool blnOk = true;
Oracle.DataAccess.Client.OracleTransaction txn = conn.BeginTransaction();
try
{
SaveApproval(conn);
SaveCSA(conn);
txn.Commit();
}
catch
{
txn.Rollback();
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
return(blnOk);
}
public void BulkCopyAndSave <T>(IEnumerable <T> source, bool isDispose = false, int?batchSize = null)
{
var mapping = TFundSolution.Utils.EntityFramworks.EfMappingFactory.GetMappingsForContext(this.ContextCis);
var currentType = typeof(T);
var typeMapping = mapping.TypeMappings[typeof(T)];
var tableMapping = typeMapping.TableMappings.First();
IList <ColumnMapping> properties = tableMapping.PropertyMappings
.Where(p => currentType.IsSubclassOf(p.ForEntityType) || p.ForEntityType == currentType)
.Select(p => new ColumnMapping {
NameInDatabase = p.ColumnName, NameOnObject = p.PropertyName
}).ToList();
if (tableMapping.TPHConfiguration != null)
{
properties.Add(new ColumnMapping
{
NameInDatabase = tableMapping.TPHConfiguration.ColumnName,
StaticValue = tableMapping.TPHConfiguration.Mappings[typeof(T)]
});
}
using (var reader = new EFDataReader <T>(source, properties))
{
var connection = new Oracle.DataAccess.Client.OracleConnection(ContextCis.Database.Connection.ConnectionString);
if (connection.State != System.Data.ConnectionState.Open)
{
connection.Open();
}
using (Oracle.DataAccess.Client.OracleBulkCopy copy = new Oracle.DataAccess.Client.OracleBulkCopy(connection, Oracle.DataAccess.Client.OracleBulkCopyOptions.UseInternalTransaction))
{
copy.BatchSize = Math.Min(reader.RecordsAffected, batchSize ?? 10000); //default batch size
copy.BulkCopyTimeout = 3600;
if (!string.IsNullOrWhiteSpace(tableMapping.Schema))
{
copy.DestinationTableName = string.Format("{0}.{1}", tableMapping.Schema, tableMapping.TableName);
}
else
{
copy.DestinationTableName = tableMapping.TableName;
}
copy.NotifyAfter = 0;
foreach (var i in Enumerable.Range(0, reader.FieldCount))
{
copy.ColumnMappings.Add(i, properties[i].NameInDatabase);
}
var sourceTable = source.AsDataTableWithContext(this.ContextCis);
copy.WriteToServer(sourceTable);
copy.Close();
}
if (isDispose)
{
this.ReNewContext();
}
}
}
private void FillOneDropDown(DropDownList ddl, string strTableName)
{
ddl.Items.Clear();
ddl.Items.Add(new ListItem("---- Select ----", "xx"));
string strSQL = "select record_id,description from " + strTableName;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(strSQL, conn);
conn.Open();
Oracle.DataAccess.Client.OracleDataReader reader = null;
try
{
reader = cmd.ExecuteReader();
while (reader.Read())
{
ListItem li = new ListItem(reader.GetValue(1).ToString(), reader.GetValue(0).ToString());
ddl.Items.Add(li);
}
}
finally
{
reader.Dispose();
cmd.Dispose();
conn.Dispose();
}
}
public static DataTable employee_info(string strHeader_id)
{
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Report.Data.ConnectioString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("pkg_employee_3.ee_info_for_pla_report", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "header_record_id_", strHeader_id);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "header_record", "cursor", "out", "");
DataSet mds = new DataSet();
Oracle.DataAccess.Client.OracleDataAdapter da = new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
DataTable tbl = null;
string strPY = "";
try
{
conn.Open();
da.Fill(mds);
tbl = mds.Tables[0];
}
finally
{
cmd.Dispose();
mds.Dispose();
conn.Close();
conn.Dispose();
}
return(tbl);
}
public static DataTable FillDataDateTimes(string strRecord_id)
{
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Report.Data.ConnectioString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("BASDBA.PKG_Training.gettrainingcoursedatetimerec", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "header_record_id_", strRecord_id);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "Step_3_record", "cursor", "out", "");
DataSet mds = new DataSet();
Oracle.DataAccess.Client.OracleDataAdapter da = new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
DataTable tbl = null;
try
{
conn.Open();
da.Fill(mds);
tbl = mds.Tables[0];
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
mds.Dispose();
}
return(tbl);
}
private bool DoSave()
{
bool blnSaved = true;
DataTable tbl = (DataTable)dgQA.DataSource;
RadioButtonList opnlst;
string strID;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
conn.Open();
Oracle.DataAccess.Client.OracleTransaction txn = conn.BeginTransaction();
try
{
foreach (DataRow dr in tbl.Rows)
{
strID = "opn_" + dr["record_id"].ToString();
opnlst = Getopnlst(this, strID);
SaveOne(conn, dr["record_id"].ToString(), opnlst.SelectedValue);
opnlst = null;
}
SaveFinalizeEvaluation(conn);
txn.Commit();
}
catch
{
txn.Rollback();
throw;
}
finally
{
conn.Close();
conn.Dispose();
}
return(blnSaved);
}
// private void FillProgramCode()
// {
// System.Data.DataTable dTable;
// Oracle.DataAccess.Client.OracleConnection conn= new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
// Oracle.DataAccess.Client.OracleCommand cmd =
// new Oracle.DataAccess.Client.OracleCommand("pkg_training.program_code_list",conn);
// cmd.CommandType = System.Data.CommandType.StoredProcedure;
//
// SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd,"list_","cursor","out","");
// Oracle.DataAccess.Client.OracleDataAdapter da =
// new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
// DataSet mds=new DataSet();
// conn.Open();
// try
// {
//
// da.Fill(mds,"Purpose");
// dTable = mds.Tables["Purpose"];
// ddlProgramCode.Items.Clear();
// ddlProgramCode.Items.Add(new ListItem("---- Select ----","-1"));
// foreach (DataRow dr in dTable.Rows)
// {
// ListItem li = new ListItem(dr["description"].ToString(),dr["program_code"].ToString());
// ddlProgramCode.Items.Add(li);
// }
// }
// finally
// {
// conn.Close();
// conn.Dispose();
// cmd.Dispose();
// da.Dispose();
// mds.Dispose();
// dTable=null;
// }
// if (ddlProgramCode.Items.Count==1)
// {
// ddlProgramCode.Enabled =false;
// lblStarProgramCode.Visible = false;
// rvProgramCode.Visible = false;
// lblProgramCodeCommingSoon.Visible = true;
// }
// }
private void FillAccountNo()
{
System.Data.DataTable dTable;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(Training_Source.TrainingClass.ConnectioString);
Oracle.DataAccess.Client.OracleCommand cmd =
new Oracle.DataAccess.Client.OracleCommand("pkg_training.account_no_list", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "list_", "cursor", "out", "");
Oracle.DataAccess.Client.OracleDataAdapter da =
new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
DataSet mds = new DataSet();
conn.Open();
try
{
da.Fill(mds, "Purpose");
dTable = mds.Tables["Purpose"];
opnlstAccountNumber.Items.Clear();
foreach (DataRow dr in dTable.Rows)
{
ListItem li = new ListItem(dr["description"].ToString(), dr["account_no"].ToString());
opnlstAccountNumber.Items.Add(li);
}
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
da.Dispose();
mds.Dispose();
dTable = null;
}
}
private DataTable GetGridTable()
{
string strProcedureName = "BASDBA.pkg_training.term_pending_payment_list";
if (Request.Params["what"] == "2nd")
{
strProcedureName = "BASDBA.pkg_training.term_pending_2nd_sup_list";
}
DataTable tbl = null;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(PLA_Approval.TrainingClass.ConnectionString);
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(strProcedureName, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "super_user_employee_number_", ViewState["Employee_Number"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "list_", "cursor", "out", "");
DataSet mds = new DataSet();
Oracle.DataAccess.Client.OracleDataAdapter da = new Oracle.DataAccess.Client.OracleDataAdapter(cmd);
try
{
conn.Open();
da.Fill(mds);
tbl = mds.Tables[0];
}
finally
{
conn.Close();
conn.Dispose();
cmd.Dispose();
mds.Dispose();
}
return(tbl);
}
public JsonResult Create(int noticeId)
{
BusinessCheckNotice businessCheckNotice = RepositoryFactory.GetRepository<IBusinessCheckNoticeRepository, BusinessCheckNotice>().FindBy(noticeId);
if (businessCheckNotice == null)
{
return Json(new { success = false, message = "商检单不存在" });
}
PipeIncomeRecord incomeRecord = repository.FindBy(businessCheckNotice);
if (incomeRecord != null)
{
return Json(new { success = false, message = "已制作了该商检任务的入库单，不能重量制作" });
}
string code = Request.Form["Code"];
string unit = Request.Form["Unit"];
string strPipes = Request.Form["Pipes"];
if (string.IsNullOrEmpty(code))
{
return Json(new { success = false, message = "编码不能为空" });
}
incomeRecord = repository.FindBy(code);
if (incomeRecord != null)
{
return Json(new { success = false, message = "编号已被占用，请尝试使用其他编号" });
}
businessCheckNotice.Waggons = RepositoryFactory.GetRepository<IDeliverWaggonRepository, DeliverWaggon>().FindBy(businessCheckNotice);
#region scarface
// IList<PDCPMS.Model.Common.Pipe> pipes = RepositoryFactory.GetRepository<IPipeRepository, PDCPMS.Model.Common.Pipe>().FindBy(businessCheckNotice.Waggons);
#endregion
JavaScriptSerializer serializer = new JavaScriptSerializer();
IList<PDCPMS.DataContracts.Common.Pipe> pipeContracts = serializer.Deserialize<IList<PDCPMS.DataContracts.Common.Pipe>>(strPipes);
IPipeRepository pipeRepository = RepositoryFactory.GetRepository<IPipeRepository, PDCPMS.Model.Common.Pipe>(unitOfWork);
IPipePositionRepository posRepository = RepositoryFactory.GetRepository<IPipePositionRepository, PipePosition>();
incomeRecord = new PipeIncomeRecord(0, code, businessCheckNotice, UserSession.OnlineAccount, DateTime.Now);
incomeRecord.State = PipeIncomeRecordState.Created;
repository.Add(incomeRecord);
unitOfWork.Commit();
#region scarface
//for (int i = pipes.Count - 1; i > -1; i--)
//{
// PDCPMS.Model.Common.Pipe pipe = pipes[i];
// PDCPMS.DataContracts.Common.Pipe pc = pipeContracts.FirstOrDefault(p => p.Key == (long)pipe.Key);
// if (pc != null)
// {
// if (pc.BusinessLength != 0)
// {
// pipe.BusinessLength = pc.BusinessLength;
// }
// else
// {
// pipe.BusinessLength = new float?();
// }
// if (pc.Weight != 0)
// {
// pipe.Weight = pc.Weight;
// }
// else
// {
// pipe.Weight = new float?();
// }
// //if ((pipe.State & PipeState.NormalChecking) == PipeState.NormalChecking) // 已发起了常检则不允许更改垛位
// //{
// //}
// //else
// //{
// if (pc.PositionId != 0)
// {
// pipe.Position = posRepository.FindBy(pc.PositionId);
// }
// //}
// }
// pipe.State |= PipeState.IncomeRecordDoing;
// pipe.PipeIncomeRecord = incomeRecord;
// pipeRepository[pipe.Key] = pipe;
//};
//incomeRecord.TotalCount = businessCheckNotice.ReceiveCount;
//incomeRecord.TotalLength = pipes.Sum(p => p.BusinessLength.HasValue ? p.BusinessLength.Value : 0);
//incomeRecord.TotalWeight = pipes.Sum(p => p.Weight.HasValue ? p.Weight.Value : 0) / 1000;
#endregion
#region 2010-11-12 scarface 新增代码
//获取前台Json的值遍历生产SQL
StringBuilder sb = new StringBuilder();
DateTime now = DateTime.Now;
Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PDCPDMConnection"].ConnectionString);
CY.Utility.DBUtility.OracleUtility db = new CY.Utility.DBUtility.OracleUtility(conn);
conn.Open();
Oracle.DataAccess.Client.OracleTransaction tran = conn.BeginTransaction();
try
{
sb.Append(" update Pipe set PipeIncomeRecordId = " + incomeRecord.Key + ",");
sb.Append(string.Format(" state = (state + {0} - bitand(state,{0})),", (int)PipeState.IncomeRecordDoing));
sb.Append(" PosLastChangeTime = to_date('" + now + "', 'yyyy-mm-dd HH24:mi:ss') ");
IList<DeliverWaggon> waggons = businessCheckNotice.Waggons;
if (waggons == null)
{
throw new ArgumentNullException("waggons");
}
string waggonIds = string.Empty;
for (int i = waggons.Count - 1; i > -1; i--)
{
waggonIds += OracleDataHelper.GetSqlValue(waggons[i].Key);
if (i != 0)
{
waggonIds += ",";
}
}
sb.Append(string.Format(" Where DeliverWaggonId in ({0})", waggonIds));
db.ExecuteSql(sb.ToString());
for (int i = pipeContracts.Count - 1; i > -1; i--)
{
sb = new StringBuilder();
sb.Append(" UPDATE Pipe SET ");
sb.Append(" BusinessLength = " + pipeContracts[i].BusinessLength + ",");
sb.Append(" Weight = " + pipeContracts[i].Weight + ",");
sb.Append(" PosLastChangeTime = to_date('" + now + "', 'yyyy-mm-dd HH24:mi:ss'),");
sb.Append(" PositionId = " + pipeContracts[i].PositionId);
sb.Append(" WHERE PipeId = " + pipeContracts[i].Key + "");
db.ExecuteSql(sb.ToString());
}
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
return Json(new { success = false, message = "管子信息保存出错！"+ex });
}
finally
{
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
//查询并统计数据
sb = new StringBuilder();
sb.Append(" SELECT SUM(BUSINESSLENGTH) AS lh ,SUM(WEIGHT)/1000 AS wt,count(*) as c FROM Pipe WHERE PIPEINCOMERECORDID = " + incomeRecord.Key + "");
DataTable dt = pipeRepository.ExcuteDs(sb.ToString());
float tl = dt.Rows[0]["lh"].ToString() == "" ? 0 : float.Parse(dt.Rows[0]["lh"].ToString());
float tw = dt.Rows[0]["wt"].ToString() == "" ? 0 : float.Parse(dt.Rows[0]["wt"].ToString());
int tc = dt.Rows[0]["c"].ToString() == "" ? 0 : int.Parse(dt.Rows[0]["c"].ToString());
sb = new StringBuilder();
sb.Append(" UPDATE Pipeincomerecord SET totalcount=" + tc + ",TOTALLENGTH = " + tl + ",TOTALWEIGHT = " + tw + " WHERE PIPEINCOMERECORDID = " + incomeRecord.Key + "");
//只执行一次查询 就更新数据库表
pipeRepository.Execute(sb.ToString());
#endregion
TempData["HintMessage"] = new PDCPMS.Application.HintMessage { Content = "保存成功" };
return Json(new { success = true, message = "保存成功", recordId = incomeRecord.Key });
}
public override int Execute(DbCommand[] cmdArray)
{
var connection = new Oracle.DataAccess.Client.OracleConnection(connectionString);
Oracle.DataAccess.Client.OracleTransaction transaction = null;
int r = 0;
try
{
connection.Open();
transaction = connection.BeginTransaction();
for (int i = 0; i < cmdArray.Length; i++)
{
if (!(cmdArray[i] is Oracle.DataAccess.Client.OracleCommand))
throw new Exception("Not a Valid SQL Command");
var command = (Oracle.DataAccess.Client.OracleCommand)cmdArray[i];
SetTimeOut(command);
command.Connection = connection;
command.Transaction = transaction;
foreach (Oracle.DataAccess.Client.OracleParameter parameter in command.Parameters)
{
if (parameter.Value == null)
{
parameter.Value = DBNull.Value;
}
}
r += command.ExecuteNonQuery();
}
transaction.Commit();
return r;
}
catch (Exception ex)
{
if (transaction != null) transaction.Rollback();
string exceptionMessage = GetOracleExceptionMessage(ex);
throw new Exception(exceptionMessage);
}
finally
{
connection.Close();
}
}
/// <summary>手持登录</summary>
public AscmUserInfo MobileLogin(string userId, string userPwd, string connString, ref string errorMsg)
{
AscmUserInfo ascmUserInfo = null;
errorMsg = string.Empty;
using (Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection(connString))
{
if (conn.State != System.Data.ConnectionState.Open)
conn.Open();
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "SELECT userId,userName,password,employeeId,extExpandType,extExpandId FROM ynUser WHERE extExpandId = :extExpandId";
cmd.CommandType = System.Data.CommandType.Text;
Oracle.DataAccess.Client.OracleParameter parm = new Oracle.DataAccess.Client.OracleParameter();
parm.ParameterName = ":extExpandId";
parm.OracleDbType = Oracle.DataAccess.Client.OracleDbType.NVarchar2;
parm.Size = 20;
parm.Value = userId;
parm.Direction = System.Data.ParameterDirection.Input;
cmd.Parameters.Add(parm);
using (Oracle.DataAccess.Client.OracleDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection))
{
cmd.Parameters.Clear();
if (reader.Read())
{
ascmUserInfo = new AscmUserInfo();
ascmUserInfo.userId = reader["userId"].ToString();
ascmUserInfo.userName = reader["userName"].ToString();
ascmUserInfo.password = reader["password"].ToString();
int employeeId = 0;
int.TryParse(reader["employeeId"].ToString(), out employeeId);
ascmUserInfo.employeeId = employeeId;
ascmUserInfo.extExpandType = reader["extExpandType"].ToString();
ascmUserInfo.extExpandId = reader["extExpandId"].ToString();
if (ascmUserInfo.extExpandType == "erp")
{
byte[] result = Encoding.Default.GetBytes(userPwd);
System.Security.Cryptography.MD5 md5 = new System.Security.Cryptography.MD5CryptoServiceProvider();
userPwd = BitConverter.ToString(md5.ComputeHash(result)).Replace("-", "");
if (ascmUserInfo.password != userPwd)
{
errorMsg = "密码不正确";
}
else if (!string.IsNullOrEmpty(ascmUserInfo.userName))
{
Oracle.DataAccess.Client.OracleCommand cmd2 = new Oracle.DataAccess.Client.OracleCommand();
cmd2.Connection = conn;
cmd2.CommandText = "SELECT id,name FROM ascm_supplier WHERE docNumber = :docNumber";
cmd2.CommandType = System.Data.CommandType.Text;
cmd2.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter {
ParameterName = ":docNumber",
OracleDbType = Oracle.DataAccess.Client.OracleDbType.NVarchar2,
Size = 20,
Value = ascmUserInfo.userName,
Direction = System.Data.ParameterDirection.Input
});
using (Oracle.DataAccess.Client.OracleDataReader reader2 = cmd2.ExecuteReader(System.Data.CommandBehavior.CloseConnection))
{
cmd2.Parameters.Clear();
if (reader2.Read())
{
int id = 0;
if (int.TryParse(reader2["id"].ToString(), out id))
{
AscmSupplier ascmSupplier = new AscmSupplier();
ascmSupplier.id = id;
ascmSupplier.name = reader2["name"].ToString();
ascmUserInfo.ascmSupplier = ascmSupplier;
}
}
}
}
}
}
}
}
return ascmUserInfo;
}
public Northwind CreateDB(System.Data.ConnectionState state)
{
CheckRecreateSqlite();
XSqlConnection conn = new XSqlConnection(connStr);
if (state == System.Data.ConnectionState.Open)
conn.Open();
Northwind db = new Northwind(conn);
return db;
}
