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