public static void SavePDF(string account_number_, string employee_number_, string dependent_sequence_no_, string user_name_,
string doc_name_, byte[] bValue)
{
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("pkg_dependents_audit.save_Verify_Doc_upload", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "account_number_", account_number_);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "employee_number_", employee_number_);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "dependent_sequence_no_", dependent_sequence_no_);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "user_name_", user_name_);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "doc_name_", doc_name_);
Oracle.DataAccess.Client.OracleParameter parm;
parm = new Oracle.DataAccess.Client.OracleParameter(
"value_", Oracle.DataAccess.Client.OracleDbType.Blob, bValue.Length, System.Data.ParameterDirection.Input, true,
((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, bValue);
cmd.Parameters.Add(parm);
try
{
cmd.ExecuteNonQuery();
}
finally
{
cmd.Dispose();
conn.Clone();
conn.Dispose();
}
}
public static void Request_info_doc(string employee_number_, string account_number_, string log_user_name_, string r_log_id_,
string reason_, string doc_name_, byte[] bValue)
{
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("pkg_Dependent_Audit_Wizard.Request_info_doc", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "employee_number_", employee_number_);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "account_number_", account_number_);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "log_user_name_", log_user_name_);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "r_log_id_", r_log_id_);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "reason_", reason_);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "doc_name_", doc_name_);
Oracle.DataAccess.Client.OracleParameter parm;
parm = new Oracle.DataAccess.Client.OracleParameter(
"value_", Oracle.DataAccess.Client.OracleDbType.Blob, bValue.Length, System.Data.ParameterDirection.Input, true,
((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, bValue);
cmd.Parameters.Add(parm);
try
{
cmd.ExecuteNonQuery();
}
finally
{
SQLStatic.SQL.CloseConnection(conn);
cmd.Dispose();
}
}
private void SaveOne(Oracle.DataAccess.Client.OracleConnection conn, string strEmployeeNumber)
{
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("basdba.PKG_Training.add_Communication_memo", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
Oracle.DataAccess.Client.OracleParameter parm = null;
try
{
int intFileLen = txtMemo.Text.Length;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "rqst_header_record_id_", "number", "in", ViewState["Request_Record_ID"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "from_employee_number_", "number", "in", ViewState["Loged_Employee_Number"]);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "to_employee_number_", "number", "in", strEmployeeNumber);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "subject_", "varchar2", "in", txtSubject.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "memo_body_", "varchar2", "in", txtMemo.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "add_user_id_", "varchar2", "in", ViewState["User_Name"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "send_email", "number", "in", 1);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "user_id_", "varchar2", "in", ViewState["User_Name"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "new_record_id_", "number", "out", "");
cmd.ExecuteNonQuery();
ViewState["New_Comm_ID"] = cmd.Parameters["new_record_id_"].Value.ToString();
}
finally
{
if (parm != null)
{
parm = null;
}
cmd.Dispose();
}
}
private bool DoSave(Oracle.DataAccess.Client.OracleConnection conn)
{
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("basdba.PKG_Training.req_Partial_Payment", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
bool blnOk = true;
Oracle.DataAccess.Client.OracleParameter parm = null;
try
{
int intFileLen = txtMemo.Text.Length;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "record_id_", "number", "in", ViewState["Request_Record_ID"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "reason_", "varchar2", "in", txtMemo.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() != ""))
{
ShowError(cmd.Parameters["error_msg_"].Value.ToString());
blnOk = false;
}
}
catch
{
}
finally
{
if (parm != null)
{
parm = null;
}
cmd.Dispose();
}
return(blnOk);
}
/// <summary>
/// <para>Returns the value of the parameter for the given <paramref name="name"/>.</para>
/// </summary>
/// <param name="name"><para>The name of the parameter to get the value.</para></param>
/// <returns><para>The value of the parameter.</para></returns>
public override object GetParameterValue(string name)
{
string parameterName = name;
OracleDataAccess.Client.OracleParameter parameter = command.Parameters[parameterName];
//check for DBNull
if (parameter.Value is DBNull)
{
return(DBNull.Value);
}
// cast the parameter as Guid if it is a guid parameter
if (guidParameters.Contains(parameterName))
{
byte[] buffer = (byte[])parameter.Value;
if (buffer.Length == 0)
{
return(DBNull.Value);
}
else
{
return(new Guid(buffer));
}
}
// cast the parameter as Boolean if it is a boolean parameter
else if (parameter.DbType == DbType.Boolean)
{
return(Convert.ToBoolean(parameter.Value, CultureInfo.InvariantCulture));
}
return(parameter.Value);
}
private void Save2ndApproval(Oracle.DataAccess.Client.OracleConnection conn)
{
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("basdba.PKG_Training.req_apprvd_by_2nd_sprvsor", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
Oracle.DataAccess.Client.OracleParameter parm = null;
try
{
int intFileLen = txtMemo.Text.Length;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "header_record_id_", "number", "in", ViewState["Request_Record_ID"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "user_id_", "varchar2", "in", ViewState["User_Name"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "error_msg_", "varchar2", "out", "");
ViewState["Saved"] = "";
cmd.ExecuteNonQuery();
if ((cmd.Parameters["error_msg_"].Value != null) && (cmd.Parameters["error_msg_"].Value.ToString() != ""))
{
ShowError(cmd.Parameters["error_msg_"].Value.ToString());
ViewState["Saved"] = "F";
}
}
finally
{
if (parm != null)
{
parm = null;
}
cmd.Dispose();
}
}
public static void SavePDF(string session_id_, string strName, byte[] bValue)
{
Oracle.DataAccess.Client.OracleConnection conn = SQLStatic.SQL.OracleConnection();
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("pkg_Enrollment_Wizard_LE.save_LE_Doc_upload", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "session_id_", session_id_);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "doc_name_", strName);
Oracle.DataAccess.Client.OracleParameter parm;
parm = new Oracle.DataAccess.Client.OracleParameter(
"value_", Oracle.DataAccess.Client.OracleDbType.Blob, bValue.Length, System.Data.ParameterDirection.Input, true,
((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, bValue);
cmd.Parameters.Add(parm);
try
{
cmd.ExecuteNonQuery();
}
finally
{
cmd.Dispose();
conn.Clone();
conn.Dispose();
}
}
private void SADADDataUpload(ulong agreementID, decimal amount, string remarks, string billNumber, string paymentRef)
{
try
{
#region Call stored Procedure
using (var command = new Oracle.DataAccess.Client.OracleCommand())
{
command.Connection = OraConnection.GetConnection();
if (command.Connection.State != ConnectionState.Open)
{
command.Connection.Open();
}
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SADAD_manual_data_upload";
command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("p_Agreementid", Oracle.DataAccess.Client.OracleDbType.Int64)).Value = agreementID;
command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("p_Chqamount", Oracle.DataAccess.Client.OracleDbType.Double)).Value = amount;
command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("p_remarks", Oracle.DataAccess.Client.OracleDbType.Varchar2, 100)).Value = remarks;
Oracle.DataAccess.Client.OracleParameter errorcodeparam = new Oracle.DataAccess.Client.OracleParameter("Error_code", Oracle.DataAccess.Client.OracleDbType.Int32);
errorcodeparam.Direction = ParameterDirection.Output;
Oracle.DataAccess.Client.OracleParameter errormsgparam = new Oracle.DataAccess.Client.OracleParameter("Error_msg", Oracle.DataAccess.Client.OracleDbType.Varchar2, 100);
errorcodeparam.Direction = ParameterDirection.Output;
command.Parameters.Add(errorcodeparam);
command.Parameters.Add(errormsgparam);
command.ExecuteNonQuery();
string errorcode = command.Parameters["Error_code"].Value.ToString();
string errorMessage = command.Parameters["Error_msg"].Value.ToString();
if (!string.IsNullOrWhiteSpace(errorcode))
{
if (errorcode.ToLower() != "null")
{
UnprocessedRec(billNumber, paymentRef);
Logger.TrackLogs("Invalid Agreement ID: '" + agreementID + "' with amount : '" + amount + "' , Error Code Message : '" + errorcode + "' , Error Message : '" + errorMessage + "'", "after calling 'SADAD_manual_data_upload' Procedure");
}
}
else
{
Logger.TrackLogs("Agreement ID: '" + agreementID + "' with amount : '" + amount + "' Added Successfully", "after calling 'SADAD_manual_data_upload' Procedure");
}
command.Connection.Close();
}
#endregion
}
catch (Exception ex)
{
UnprocessedRec(billNumber, paymentRef);
Logger.TrackLogs("Invalid Agreement ID: '" + agreementID + "' with amount : '" + amount + "' , Error Code Message : '" + ex.Source + "' , Error Message : '" + ex.Message + "'", "after calling 'SADAD_manual_data_upload' Procedure");
}
}
private bool DoSave(string strMsgList)
{
string strProcedureName;
if (ViewState["From_2nd_supervisor"].ToString() == "T")
{
strProcedureName = "basdba.PKG_Training.req_dclnd_by_2nd_sprvsor";
}
else
{
strProcedureName = "basdba.PKG_Training.req_dclnd_by_sprvsor";
}
int intIs_payor = 0;
if (Request.Params["who"] == "payor")
{
intIs_payor = 1;
}
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;
Oracle.DataAccess.Client.OracleParameter parm = null;
try
{
int intFileLen = txtMemo.Text.Length;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "record_id_", "number", "in", ViewState["Request_Record_ID"].ToString());
if (ViewState["From_2nd_supervisor"].ToString() != "T")
{
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "is_payor", "number", "in", intIs_payor);
}
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "reason_", "varchar2", "in", txtMemo.Text);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "resonn_sel", "varchar2", "in", strMsgList);
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
{
if (parm != null)
{
parm = null;
}
cmd.Dispose();
conn.Close();
conn.Dispose();
}
return(blnOk);
}
public DBHandler AddCursorParameter(string parameterName)
{
var command = Command as Oracle.DataAccess.Client.OracleCommand;
Oracle.DataAccess.Client.OracleParameter oracleParameter = new Oracle.DataAccess.Client.OracleParameter(parameterName, Oracle.DataAccess.Client.OracleDbType.RefCursor);
oracleParameter.Direction = ParameterDirection.Output;
command.Parameters.Add(oracleParameter);
return this;
}
private void BankChargeEntry(string transactionType, string channel, decimal amount, string cardType, string customerNo, string customerName, string billNumber, string paymentRef)
{
try
{
#region Call stored Procedure
using (var command = new Oracle.DataAccess.Client.OracleCommand())
{
command.Connection = OraConnection.GetConnection();
if (command.Connection.State != ConnectionState.Open)
{
command.Connection.Open();
}
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "trx_bank_charge_entry";
command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("TRX_TYPE", Oracle.DataAccess.Client.OracleDbType.Varchar2)).Value = transactionType;
command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("TRX_CHANEL", Oracle.DataAccess.Client.OracleDbType.Varchar2)).Value = channel;
command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("TRX_AMT", Oracle.DataAccess.Client.OracleDbType.Decimal, 100)).Value = amount;
command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("CARD_TYPE", Oracle.DataAccess.Client.OracleDbType.Varchar2)).Value = cardType;
command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("customer_no", Oracle.DataAccess.Client.OracleDbType.Varchar2)).Value = customerNo;
command.Parameters.Add(new Oracle.DataAccess.Client.OracleParameter("CUSTOMER_NAME", Oracle.DataAccess.Client.OracleDbType.Varchar2)).Value = customerName;
Oracle.DataAccess.Client.OracleParameter errorcodeparam = new Oracle.DataAccess.Client.OracleParameter("VERROR", Oracle.DataAccess.Client.OracleDbType.Varchar2);
errorcodeparam.Direction = ParameterDirection.Output;
command.Parameters.Add(errorcodeparam);
command.ExecuteNonQuery();
string errorMessage = command.Parameters["VERROR"].Value.ToString();
if (!string.IsNullOrWhiteSpace(errorMessage))
{
if (errorMessage.ToLower() != "null")
{
UnprocessedRec(billNumber, paymentRef);
Logger.TrackLogs("Invalid Bank Charge Entry Process for Transaction Type : '" + transactionType + "' , Customer No : '" + customerNo + "' , Customer Name : '" + customerName + "' , Card Type :'" + cardType + "' , Error Message : '" + errorMessage + "'", "after calling 'trx_bank_charge_entry' Procedure");
}
}
else
{
Logger.TrackLogs("Transaction Type : '" + transactionType + "' , Customer No : '" + customerNo + "' , Customer Name : '" + customerName + "' , Card Type :'" + cardType + "' , Added Successfully", "after calling 'trx_bank_charge_entry' Procedure");
}
command.Connection.Close();
}
#endregion
}
catch (Exception ex)
{
UnprocessedRec(billNumber, paymentRef);
Logger.TrackLogs("Invalid Bank Charge Entry Process for Transaction Type : '" + transactionType + "' , Customer No : '" + customerNo + "' , Customer Name : '" + customerName + "' , Card Type :'" + cardType + "' , Error Message : '" + ex.Message + "'", "after calling 'trx_bank_charge_entry' Procedure");
}
}
/// <summary>
/// <para>Adds a new instance of an <see cref="OracleParameter"/> object to the command.</para>
/// </summary>
/// <param name="name"><para>The name of the parameter.</para></param>
/// <param name="oracleType"><para>One of the <see cref="OracleType"/> values.</para></param>
/// <param name="size"><para>The maximum size of the data within the column.</para></param>
/// <param name="direction"><para>One of the <see cref="ParameterDirection"/> values.</para></param>
/// <param name="nullable"><para>Avalue indicating whether the parameter accepts null values.</para></param>
/// <param name="precision"><para>The maximum number of digits used to represent the <paramref name="value"/>.</para></param>
/// <param name="scale"><para>The number of decimal places to which <paramref name="value"/> is resolved.</para></param>
/// <param name="sourceColumn"><para>The name of the source column mapped to the DataSet and used for loading or returning the <paramref name="value"/>.</para></param>
/// <param name="sourceVersion"><para>One of the <see cref="DataRowVersion"/> values.</para></param>
/// <param name="value"><para>The value of the parameter.</para></param>
public void AddParameter(string name, OracleDataAccess.Client.OracleDbType oracleType, int size, ParameterDirection direction, bool nullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value)
{
OracleDataAccess.Client.OracleParameter param = CreateParameter(name, DbType.AnsiString, size, direction, nullable, precision, scale, sourceColumn, sourceVersion, value);
if (oracleType == OracleDataAccess.Client.OracleDbType.RefCursor)
{
isRefCursorAdded = true;
}
param.OracleDbType = oracleType;
this.command.Parameters.Add(param);
}
private bool DoSave()
{
int intIs_payor = 0;
if (Request.Params["who"] == "payor")
{
intIs_payor = 1;
}
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.req_rqst_info_by_sprvsor", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
conn.Open();
bool blnOk = true;
Oracle.DataAccess.Client.OracleParameter parm = null;
try
{
int intFileLen = txtMemo.Text.Length;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "record_id_", "number", "in", ViewState["Request_Record_ID"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "is_payor", "number", "in", intIs_payor);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "reqsted_info_", "varchar2", "in", txtMemo.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() != ""))
{
ShowError(cmd.Parameters["error_msg_"].Value.ToString());
ViewState["Saved"] = "F";
}
}
catch
{
blnOk = false;
// throw;
}
finally
{
if (parm != null)
{
parm = null;
}
cmd.Dispose();
conn.Close();
conn.Dispose();
}
return(blnOk);
}
private void SaveOne(Oracle.DataAccess.Client.OracleConnection conn, string strEmployeeNumber)
{
string strProcedureName = "basdba.PKG_Training.add_Communication_memo";
if (ViewState["Product_Code"].ToString() == "11001")
{
strProcedureName = "basdba.PKG_Training_cdp.add_Communication_memo";
}
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand(strProcedureName, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
Oracle.DataAccess.Client.OracleParameter parm = null;
try
{
int intFileLen = txtMemo.Text.Length;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "rqst_header_record_id_", "number", "in", ViewState["Request_Record_ID"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "from_employee_number_", "number", "in", ViewState["Employee_Number"]);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "to_employee_number_", "number", "in", strEmployeeNumber);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "subject_", "varchar2", "in", txtSubject.Text);
if (ViewState["Product_Code"].ToString() == "11001")
{
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "memo_body_", "varchar2", "in", txtMemo.Text);
}
else
{
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "memo_body_", "varchar2", "in", txtMemo.Text);
}
{
// parm = new Oracle.DataAccess.Client.OracleParameter(
// "memo_body_",Oracle.DataAccess.Client.OracleDbType.Clob,intFileLen,System.Data.ParameterDirection.Input,true,
// ((System.Byte)(0)),((System.Byte)(0)),"",System.Data.DataRowVersion.Current,txtMemo.Text);
// cmd.Parameters.Add(parm);
}
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "add_user_id_", "varchar2", "in", ViewState["User_Name"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "send_email", "number", "in", 1);
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "user_id_", "varchar2", "in", ViewState["User_Name"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "new_record_id_", "number", "out", "");
cmd.ExecuteNonQuery();
}
finally
{
if (parm != null)
{
parm = null;
}
cmd.Dispose();
}
}
/// <summary>
/// <para>Sets the value of a parameter for the given <paramref name="name"/>.</para>
/// </summary>
/// <param name="name"><para>The name of the parameter to set the value.</para></param>
/// <param name="value"><para>The new value of the parameter.</para></param>
public override void SetParameterValue(string name, object value)
{
OracleDataAccess.Client.OracleParameter parameter = command.Parameters[name];
if (value is Guid)
{
parameter.Value = ((Guid)value).ToByteArray();
}
else
{
string tmpVal = value as string;
if ((tmpVal != null) && (tmpVal.Length == 0))
{
parameter.Value = Convert.DBNull;
}
parameter.Value = (value == null) ? DBNull.Value : value;
}
}
private void SaveApproval(Oracle.DataAccess.Client.OracleConnection conn)
{
Oracle.DataAccess.Client.OracleCommand cmd = new Oracle.DataAccess.Client.OracleCommand("basdba.PKG_Training.req_apprvd_by_sprvsor", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 30;
Oracle.DataAccess.Client.OracleParameter parm = null;
try
{
int intFileLen = txtMemo.Text.Length;
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "record_id_", "number", "in", ViewState["Request_Record_ID"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "training_type_", "number", "in", ViewState["Training_Type"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "account_no_", "varchar2", "in", ViewState["AccountNo"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "supervisor_2nd_inline_", "varchar2", "in", ViewState["Second_Supervisor"].ToString());
if (intFileLen != 0)
{
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "reason_", "varchar2", "in", txtMemo.Text);
}
else
{
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "reason_", "varchar2", "in", null);
}
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "user_id_", "varchar2", "in", ViewState["User_Name"].ToString());
SQLStatic.ProcedureParameters.SetStoredProcedureParameter(cmd, "error_msg_", "varchar2", "out", "");
ViewState["Saved"] = "";
cmd.ExecuteNonQuery();
if ((cmd.Parameters["error_msg_"].Value != null) && (cmd.Parameters["error_msg_"].Value.ToString() != ""))
{
ShowError(cmd.Parameters["error_msg_"].Value.ToString());
ViewState["Saved"] = "F";
}
SQLStatic.Sessions.SetSessionValue(Request.Cookies["Session_ID"].Value.ToString(), "APPLICANT_EMPLOYEE_NUMBER", "");
}
finally
{
if (parm != null)
{
parm = null;
}
cmd.Dispose();
}
}
internal DataTable GetCerQuery_Bank(string bank)
{
List <DbParameter> list = new List <DbParameter>();
Oracle.DataAccess.Client.OracleParameter inputparm = new Oracle.DataAccess.Client.OracleParameter("LZRZJH", Oracle.DataAccess.Client.OracleDbType.NVarchar2);
inputparm.Direction = ParameterDirection.Input;
inputparm.Value = bank;
Oracle.DataAccess.Client.OracleParameter outputparm = new Oracle.DataAccess.Client.OracleParameter("RETURNVAL", Oracle.DataAccess.Client.OracleDbType.RefCursor);
outputparm.Direction = ParameterDirection.Output;
list.Add(inputparm);
list.Add(outputparm);
DbHelper dbHelper = new DbHelper();
dbHelper.SetProvider(MyDBType.Oracle);
DataTable dt = dbHelper.ExecuteTable(MyDBType.Oracle, System.Data.CommandType.StoredProcedure, "LND_PROC_GETCERTQUERY_BANK", list.ToArray());
return(GetDistinctSelf(dt, "BDCQZH"));
}
public static IDbDataParameter CreateParameter(this DataType dataType)
{
var name = dataType.Name;
switch (dataType.DbType.DatabaseServer)
{
case DatabaseServer.SqlServer:
{
var p = new System.Data.SqlClient.SqlParameter(name, dataType.DbType.SqlServerDbType.Value);
p.Direction = ParameterDirection.Input;
p.Value = GetParameterValue(dataType, dataType.DbType.SqlServerDbType.Value);
return(p);
}
case DatabaseServer.Oracle:
{
var p = new Oracle.DataAccess.Client.OracleParameter(name, dataType.DbType.OracleServerDbType.Value);
p.Direction = ParameterDirection.Input;
//p.Value = GetParameterValue(this.OracleServerDbType.Value);
return(p);
}
case DatabaseServer.MySql:
{
var p = new MySql.Data.MySqlClient.MySqlParameter(name, dataType.DbType.MySqlServerDbType.Value);
p.Direction = ParameterDirection.Input;
p.Value = GetParameterValue(dataType, dataType.DbType.MySqlServerDbType.Value);
return(p);
}
case DatabaseServer.PostgreSql:
{
var p = new Npgsql.NpgsqlParameter(name, dataType.DbType.PostgreSqlServerDbType.Value);
p.Direction = ParameterDirection.Input;
//p.Value = GetParameterValue(this.MySqlDbType.Value);
return(p);
}
default: throw new InvalidOperationException();
}
}
private void SaveFile(string buffer)
{
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_temp_maher.SaveBlob", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
Oracle.DataAccess.Client.OracleParameter parm = new Oracle.DataAccess.Client.OracleParameter(
"readFile", Oracle.DataAccess.Client.OracleDbType.Blob, buffer.Length, System.Data.ParameterDirection.Input, true,
((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, buffer);
cmd.Parameters.Add(parm);
conn.Open();
try
{
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
internal static IDataParameter AddRefCursor(IDbCommand command)
{
#if ODP
Oracle.DataAccess.Client.OracleParameter parameter = new Oracle.DataAccess.Client.OracleParameter();
parameter.ParameterName = "p_cursor";
parameter.OracleDbType = Oracle.DataAccess.Client.OracleDbType.RefCursor;
parameter.Direction = ParameterDirection.Output;
((Oracle.DataAccess.Client.OracleCommand)command).Parameters.Add(parameter);
return(parameter);
#elif OracleClient
System.Data.OracleClient.OracleParameter parameter = new System.Data.OracleClient.OracleParameter();
parameter.ParameterName = "p_cursor";
parameter.DbType = (DbType)System.Data.OracleClient.OracleType.Cursor;
parameter.Direction = ParameterDirection.Output;
((System.Data.OracleClient.OracleCommand)command).Parameters.Add(parameter);
return(parameter);
#else
throw new NotImplementedException("AddRefCursor is only implemented for Oracle database access.");
#endif
}
private OracleDataAccess.Client.OracleParameter CreateParameter(string name, DbType dbType, int size, ParameterDirection direction, bool nullable, byte precision, byte scale, string sourceColumn, DataRowVersion sourceVersion, object value)
{
OracleDataAccess.Client.OracleParameter param = this.command.CreateParameter();
param.ParameterName = name;
param.DbType = dbType;
param.Size = size;
param.Value = (value == null) ? DBNull.Value : value;
// modify parameter type and value for special cases
switch (dbType)
{
// for Guid, change to value to byte array
case DbType.Guid:
guidParameters.Add(param.ParameterName, "System.Guid");
param.OracleDbType = OracleDataAccess.Client.OracleDbType.Raw;
param.Size = 16;
// convert Guid value to byte array only if not null
if ((value is DBNull) || (value == null))
{
param.Value = Convert.DBNull;
}
else
{
param.Value = ((Guid)value).ToByteArray();
}
break;
default:
break;
}
param.Direction = direction;
param.IsNullable = nullable;
param.Precision = precision;
param.Scale = scale;
param.SourceColumn = sourceColumn;
param.SourceVersion = sourceVersion;
return(param);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
Oracle.DataAccess.Client.OracleParameter oracleParameter5 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter6 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter7 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter8 = new Oracle.DataAccess.Client.OracleParameter();
this.label1 = new System.Windows.Forms.Label();
this.dataGridView1 = new System.Windows.Forms.DataGridView();
this.tabControl1 = new System.Windows.Forms.TabControl();
this.tabPage1 = new System.Windows.Forms.TabPage();
this.dataGridView3 = new System.Windows.Forms.DataGridView();
this.btn_approval = new System.Windows.Forms.Button();
this.dataGridView2 = new System.Windows.Forms.DataGridView();
this.R_DEPOSIT = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.tabPage2 = new System.Windows.Forms.TabPage();
this.btn_return = new System.Windows.Forms.Button();
this.dataGridView4 = new System.Windows.Forms.DataGridView();
this.oracleConnection1 = new Oracle.DataAccess.Client.OracleConnection();
this.oracleCommand1 = new Oracle.DataAccess.Client.OracleCommand();
this.oracleCommand2 = new Oracle.DataAccess.Client.OracleCommand();
this.rNODataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.cIDDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pIDDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.rESERVATIONBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.dataSet11 = new final_project.DataSet1();
this.pIDDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pTYPEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pLOCATIONDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pFEEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pCONDITIONDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pSIZEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pCOLORDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pRECEIVINGDATEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pAVAILABILITYDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pRODUCTBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.customerTableAdapter1 = new final_project.DataSet1TableAdapters.CUSTOMERTableAdapter();
this.productTableAdapter1 = new final_project.DataSet1TableAdapters.PRODUCTTableAdapter();
this.reservationTableAdapter1 = new final_project.DataSet1TableAdapters.RESERVATIONTableAdapter();
this.reviewTableAdapter1 = new final_project.DataSet1TableAdapters.REVIEWTableAdapter();
this.rENTALSTATUSBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.rENTAL_STATUSTableAdapter = new final_project.DataSet1TableAdapters.RENTAL_STATUSTableAdapter();
this.rTNODataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.cIDDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pIDDataGridViewTextBoxColumn2 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.rTRENTALDATEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.rTRETURNDUEDATEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.rTACTUALRETURNDATEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.rTFEEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.rTEMPLOYEEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.rTNODataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.cIDDataGridViewTextBoxColumn2 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pIDDataGridViewTextBoxColumn3 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.rTRENTALDATEDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.rTRETURNDUEDATEDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.rTACTUALRETURNDATEDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.rTFEEDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.rTEMPLOYEEDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
this.tabControl1.SuspendLayout();
this.tabPage1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView3)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).BeginInit();
this.tabPage2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView4)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.rESERVATIONBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.pRODUCTBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.rENTALSTATUSBindingSource)).BeginInit();
this.SuspendLayout();
//
// label1
//
this.label1.AutoSize = true;
this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 20.25F, System.Drawing.FontStyle.Bold);
this.label1.Location = new System.Drawing.Point(413, 20);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(134, 31);
this.label1.TabIndex = 12;
this.label1.Text = "직원 화면";
//
// dataGridView1
//
this.dataGridView1.AutoGenerateColumns = false;
this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.pIDDataGridViewTextBoxColumn,
this.pTYPEDataGridViewTextBoxColumn,
this.pLOCATIONDataGridViewTextBoxColumn,
this.pFEEDataGridViewTextBoxColumn,
this.pCONDITIONDataGridViewTextBoxColumn,
this.pSIZEDataGridViewTextBoxColumn,
this.pCOLORDataGridViewTextBoxColumn,
this.pRECEIVINGDATEDataGridViewTextBoxColumn,
this.pAVAILABILITYDataGridViewTextBoxColumn
});
this.dataGridView1.DataSource = this.pRODUCTBindingSource;
this.dataGridView1.Location = new System.Drawing.Point(12, 68);
this.dataGridView1.Name = "dataGridView1";
this.dataGridView1.RowTemplate.Height = 23;
this.dataGridView1.Size = new System.Drawing.Size(975, 181);
this.dataGridView1.TabIndex = 13;
//
// tabControl1
//
this.tabControl1.Controls.Add(this.tabPage1);
this.tabControl1.Controls.Add(this.tabPage2);
this.tabControl1.Location = new System.Drawing.Point(12, 261);
this.tabControl1.Name = "tabControl1";
this.tabControl1.SelectedIndex = 0;
this.tabControl1.Size = new System.Drawing.Size(975, 395);
this.tabControl1.TabIndex = 15;
//
// tabPage1
//
this.tabPage1.Controls.Add(this.dataGridView3);
this.tabPage1.Controls.Add(this.btn_approval);
this.tabPage1.Controls.Add(this.dataGridView2);
this.tabPage1.Location = new System.Drawing.Point(4, 22);
this.tabPage1.Name = "tabPage1";
this.tabPage1.Padding = new System.Windows.Forms.Padding(3);
this.tabPage1.Size = new System.Drawing.Size(967, 369);
this.tabPage1.TabIndex = 0;
this.tabPage1.Text = "예약 목록";
this.tabPage1.UseVisualStyleBackColor = true;
//
// dataGridView3
//
this.dataGridView3.AutoGenerateColumns = false;
this.dataGridView3.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView3.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.rTNODataGridViewTextBoxColumn,
this.cIDDataGridViewTextBoxColumn1,
this.pIDDataGridViewTextBoxColumn2,
this.rTRENTALDATEDataGridViewTextBoxColumn,
this.rTRETURNDUEDATEDataGridViewTextBoxColumn,
this.rTACTUALRETURNDATEDataGridViewTextBoxColumn,
this.rTFEEDataGridViewTextBoxColumn,
this.rTEMPLOYEEDataGridViewTextBoxColumn
});
this.dataGridView3.DataSource = this.rENTALSTATUSBindingSource;
this.dataGridView3.Location = new System.Drawing.Point(541, 6);
this.dataGridView3.Name = "dataGridView3";
this.dataGridView3.RowTemplate.Height = 23;
this.dataGridView3.Size = new System.Drawing.Size(423, 357);
this.dataGridView3.TabIndex = 3;
//
// btn_approval
//
this.btn_approval.Location = new System.Drawing.Point(457, 175);
this.btn_approval.Name = "btn_approval";
this.btn_approval.Size = new System.Drawing.Size(75, 23);
this.btn_approval.TabIndex = 1;
this.btn_approval.Text = "대여 승인";
this.btn_approval.UseVisualStyleBackColor = true;
this.btn_approval.Click += new System.EventHandler(this.btn_approval_Click);
//
// dataGridView2
//
this.dataGridView2.AutoGenerateColumns = false;
this.dataGridView2.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView2.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.rNODataGridViewTextBoxColumn,
this.cIDDataGridViewTextBoxColumn,
this.pIDDataGridViewTextBoxColumn1,
this.R_DEPOSIT
});
this.dataGridView2.DataSource = this.rESERVATIONBindingSource;
this.dataGridView2.Location = new System.Drawing.Point(6, 6);
this.dataGridView2.Name = "dataGridView2";
this.dataGridView2.RowTemplate.Height = 23;
this.dataGridView2.Size = new System.Drawing.Size(445, 357);
this.dataGridView2.TabIndex = 0;
this.dataGridView2.CellClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dataGridView2_CellClick);
//
// R_DEPOSIT
//
this.R_DEPOSIT.DataPropertyName = "R_DEPOSIT";
this.R_DEPOSIT.HeaderText = "입금액";
this.R_DEPOSIT.Name = "R_DEPOSIT";
//
// tabPage2
//
this.tabPage2.Controls.Add(this.btn_return);
this.tabPage2.Controls.Add(this.dataGridView4);
this.tabPage2.Location = new System.Drawing.Point(4, 22);
this.tabPage2.Name = "tabPage2";
this.tabPage2.Padding = new System.Windows.Forms.Padding(3);
this.tabPage2.Size = new System.Drawing.Size(967, 369);
this.tabPage2.TabIndex = 1;
this.tabPage2.Text = "반납 접수";
this.tabPage2.UseVisualStyleBackColor = true;
//
// btn_return
//
this.btn_return.Location = new System.Drawing.Point(856, 320);
this.btn_return.Name = "btn_return";
this.btn_return.Size = new System.Drawing.Size(106, 23);
this.btn_return.TabIndex = 2;
this.btn_return.Text = "반납 접수 승인";
this.btn_return.UseVisualStyleBackColor = true;
this.btn_return.Click += new System.EventHandler(this.btn_return_Click_1);
//
// dataGridView4
//
this.dataGridView4.AutoGenerateColumns = false;
this.dataGridView4.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView4.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.rTNODataGridViewTextBoxColumn1,
this.cIDDataGridViewTextBoxColumn2,
this.pIDDataGridViewTextBoxColumn3,
this.rTRENTALDATEDataGridViewTextBoxColumn1,
this.rTRETURNDUEDATEDataGridViewTextBoxColumn1,
this.rTACTUALRETURNDATEDataGridViewTextBoxColumn1,
this.rTFEEDataGridViewTextBoxColumn1,
this.rTEMPLOYEEDataGridViewTextBoxColumn1
});
this.dataGridView4.DataSource = this.rENTALSTATUSBindingSource;
this.dataGridView4.Location = new System.Drawing.Point(6, 6);
this.dataGridView4.Name = "dataGridView4";
this.dataGridView4.RowTemplate.Height = 23;
this.dataGridView4.Size = new System.Drawing.Size(846, 357);
this.dataGridView4.TabIndex = 1;
this.dataGridView4.CellClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dataGridView4_CellClick_1);
//
// oracleConnection1
//
this.oracleConnection1.ConnectionString = "DATA SOURCE=KIMSIYOUNG;USER ID=A5234150;password=A5234150;";
//
// oracleCommand1
//
oracleParameter5.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter5.ParameterName = "aa";
oracleParameter6.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter6.ParameterName = "bb";
oracleParameter7.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter7.ParameterName = "cc";
oracleParameter8.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter8.ParameterName = "dd";
this.oracleCommand1.Parameters.Add(oracleParameter5);
this.oracleCommand1.Parameters.Add(oracleParameter6);
this.oracleCommand1.Parameters.Add(oracleParameter7);
this.oracleCommand1.Parameters.Add(oracleParameter8);
this.oracleCommand1.Transaction = null;
//
// oracleCommand2
//
this.oracleCommand2.CommandText = "SELECT SYSDATE FROM DUAL";
this.oracleCommand2.Transaction = null;
//
// rNODataGridViewTextBoxColumn
//
this.rNODataGridViewTextBoxColumn.DataPropertyName = "R_NO";
this.rNODataGridViewTextBoxColumn.HeaderText = "예약 번호";
this.rNODataGridViewTextBoxColumn.Name = "rNODataGridViewTextBoxColumn";
//
// cIDDataGridViewTextBoxColumn
//
this.cIDDataGridViewTextBoxColumn.DataPropertyName = "C_ID";
this.cIDDataGridViewTextBoxColumn.HeaderText = "고객 ID";
this.cIDDataGridViewTextBoxColumn.Name = "cIDDataGridViewTextBoxColumn";
//
// pIDDataGridViewTextBoxColumn1
//
this.pIDDataGridViewTextBoxColumn1.DataPropertyName = "P_ID";
this.pIDDataGridViewTextBoxColumn1.HeaderText = "물품 번호";
this.pIDDataGridViewTextBoxColumn1.Name = "pIDDataGridViewTextBoxColumn1";
//
// rESERVATIONBindingSource
//
this.rESERVATIONBindingSource.DataMember = "RESERVATION";
this.rESERVATIONBindingSource.DataSource = this.dataSet11;
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// pIDDataGridViewTextBoxColumn
//
this.pIDDataGridViewTextBoxColumn.DataPropertyName = "P_ID";
this.pIDDataGridViewTextBoxColumn.HeaderText = "물품 번호";
this.pIDDataGridViewTextBoxColumn.Name = "pIDDataGridViewTextBoxColumn";
//
// pTYPEDataGridViewTextBoxColumn
//
this.pTYPEDataGridViewTextBoxColumn.DataPropertyName = "P_TYPE";
this.pTYPEDataGridViewTextBoxColumn.HeaderText = "물품 종류";
this.pTYPEDataGridViewTextBoxColumn.Name = "pTYPEDataGridViewTextBoxColumn";
//
// pLOCATIONDataGridViewTextBoxColumn
//
this.pLOCATIONDataGridViewTextBoxColumn.DataPropertyName = "P_LOCATION";
this.pLOCATIONDataGridViewTextBoxColumn.HeaderText = "위치";
this.pLOCATIONDataGridViewTextBoxColumn.Name = "pLOCATIONDataGridViewTextBoxColumn";
//
// pFEEDataGridViewTextBoxColumn
//
this.pFEEDataGridViewTextBoxColumn.DataPropertyName = "P_FEE";
this.pFEEDataGridViewTextBoxColumn.HeaderText = "대여료";
this.pFEEDataGridViewTextBoxColumn.Name = "pFEEDataGridViewTextBoxColumn";
//
// pCONDITIONDataGridViewTextBoxColumn
//
this.pCONDITIONDataGridViewTextBoxColumn.DataPropertyName = "P_CONDITION";
this.pCONDITIONDataGridViewTextBoxColumn.HeaderText = "물품 상태";
this.pCONDITIONDataGridViewTextBoxColumn.Name = "pCONDITIONDataGridViewTextBoxColumn";
//
// pSIZEDataGridViewTextBoxColumn
//
this.pSIZEDataGridViewTextBoxColumn.DataPropertyName = "P_SIZE";
this.pSIZEDataGridViewTextBoxColumn.HeaderText = "사이즈";
this.pSIZEDataGridViewTextBoxColumn.Name = "pSIZEDataGridViewTextBoxColumn";
//
// pCOLORDataGridViewTextBoxColumn
//
this.pCOLORDataGridViewTextBoxColumn.DataPropertyName = "P_COLOR";
this.pCOLORDataGridViewTextBoxColumn.HeaderText = "색상";
this.pCOLORDataGridViewTextBoxColumn.Name = "pCOLORDataGridViewTextBoxColumn";
//
// pRECEIVINGDATEDataGridViewTextBoxColumn
//
this.pRECEIVINGDATEDataGridViewTextBoxColumn.DataPropertyName = "P_RECEIVINGDATE";
this.pRECEIVINGDATEDataGridViewTextBoxColumn.HeaderText = "입고일";
this.pRECEIVINGDATEDataGridViewTextBoxColumn.Name = "pRECEIVINGDATEDataGridViewTextBoxColumn";
//
// pAVAILABILITYDataGridViewTextBoxColumn
//
this.pAVAILABILITYDataGridViewTextBoxColumn.DataPropertyName = "P_AVAILABILITY";
this.pAVAILABILITYDataGridViewTextBoxColumn.HeaderText = "대여 가능 여부";
this.pAVAILABILITYDataGridViewTextBoxColumn.Name = "pAVAILABILITYDataGridViewTextBoxColumn";
this.pAVAILABILITYDataGridViewTextBoxColumn.Width = 120;
//
// pRODUCTBindingSource
//
this.pRODUCTBindingSource.DataMember = "PRODUCT";
this.pRODUCTBindingSource.DataSource = this.dataSet11;
//
// customerTableAdapter1
//
this.customerTableAdapter1.ClearBeforeFill = true;
//
// productTableAdapter1
//
this.productTableAdapter1.ClearBeforeFill = true;
//
// reservationTableAdapter1
//
this.reservationTableAdapter1.ClearBeforeFill = true;
//
// reviewTableAdapter1
//
this.reviewTableAdapter1.ClearBeforeFill = true;
//
// rENTALSTATUSBindingSource
//
this.rENTALSTATUSBindingSource.DataMember = "RENTAL_STATUS";
this.rENTALSTATUSBindingSource.DataSource = this.dataSet11;
//
// rENTAL_STATUSTableAdapter
//
this.rENTAL_STATUSTableAdapter.ClearBeforeFill = true;
//
// rTNODataGridViewTextBoxColumn
//
this.rTNODataGridViewTextBoxColumn.DataPropertyName = "RT_NO";
this.rTNODataGridViewTextBoxColumn.HeaderText = "RT_NO";
this.rTNODataGridViewTextBoxColumn.Name = "rTNODataGridViewTextBoxColumn";
//
// cIDDataGridViewTextBoxColumn1
//
this.cIDDataGridViewTextBoxColumn1.DataPropertyName = "C_ID";
this.cIDDataGridViewTextBoxColumn1.HeaderText = "C_ID";
this.cIDDataGridViewTextBoxColumn1.Name = "cIDDataGridViewTextBoxColumn1";
//
// pIDDataGridViewTextBoxColumn2
//
this.pIDDataGridViewTextBoxColumn2.DataPropertyName = "P_ID";
this.pIDDataGridViewTextBoxColumn2.HeaderText = "P_ID";
this.pIDDataGridViewTextBoxColumn2.Name = "pIDDataGridViewTextBoxColumn2";
//
// rTRENTALDATEDataGridViewTextBoxColumn
//
this.rTRENTALDATEDataGridViewTextBoxColumn.DataPropertyName = "RT_RENTALDATE";
this.rTRENTALDATEDataGridViewTextBoxColumn.HeaderText = "RT_RENTALDATE";
this.rTRENTALDATEDataGridViewTextBoxColumn.Name = "rTRENTALDATEDataGridViewTextBoxColumn";
//
// rTRETURNDUEDATEDataGridViewTextBoxColumn
//
this.rTRETURNDUEDATEDataGridViewTextBoxColumn.DataPropertyName = "RT_RETURNDUEDATE";
this.rTRETURNDUEDATEDataGridViewTextBoxColumn.HeaderText = "RT_RETURNDUEDATE";
this.rTRETURNDUEDATEDataGridViewTextBoxColumn.Name = "rTRETURNDUEDATEDataGridViewTextBoxColumn";
//
// rTACTUALRETURNDATEDataGridViewTextBoxColumn
//
this.rTACTUALRETURNDATEDataGridViewTextBoxColumn.DataPropertyName = "RT_ACTUALRETURNDATE";
this.rTACTUALRETURNDATEDataGridViewTextBoxColumn.HeaderText = "RT_ACTUALRETURNDATE";
this.rTACTUALRETURNDATEDataGridViewTextBoxColumn.Name = "rTACTUALRETURNDATEDataGridViewTextBoxColumn";
//
// rTFEEDataGridViewTextBoxColumn
//
this.rTFEEDataGridViewTextBoxColumn.DataPropertyName = "RT_FEE";
this.rTFEEDataGridViewTextBoxColumn.HeaderText = "RT_FEE";
this.rTFEEDataGridViewTextBoxColumn.Name = "rTFEEDataGridViewTextBoxColumn";
//
// rTEMPLOYEEDataGridViewTextBoxColumn
//
this.rTEMPLOYEEDataGridViewTextBoxColumn.DataPropertyName = "RT_EMPLOYEE";
this.rTEMPLOYEEDataGridViewTextBoxColumn.HeaderText = "RT_EMPLOYEE";
this.rTEMPLOYEEDataGridViewTextBoxColumn.Name = "rTEMPLOYEEDataGridViewTextBoxColumn";
//
// rTNODataGridViewTextBoxColumn1
//
this.rTNODataGridViewTextBoxColumn1.DataPropertyName = "RT_NO";
this.rTNODataGridViewTextBoxColumn1.HeaderText = "RT_NO";
this.rTNODataGridViewTextBoxColumn1.Name = "rTNODataGridViewTextBoxColumn1";
//
// cIDDataGridViewTextBoxColumn2
//
this.cIDDataGridViewTextBoxColumn2.DataPropertyName = "C_ID";
this.cIDDataGridViewTextBoxColumn2.HeaderText = "C_ID";
this.cIDDataGridViewTextBoxColumn2.Name = "cIDDataGridViewTextBoxColumn2";
//
// pIDDataGridViewTextBoxColumn3
//
this.pIDDataGridViewTextBoxColumn3.DataPropertyName = "P_ID";
this.pIDDataGridViewTextBoxColumn3.HeaderText = "P_ID";
this.pIDDataGridViewTextBoxColumn3.Name = "pIDDataGridViewTextBoxColumn3";
//
// rTRENTALDATEDataGridViewTextBoxColumn1
//
this.rTRENTALDATEDataGridViewTextBoxColumn1.DataPropertyName = "RT_RENTALDATE";
this.rTRENTALDATEDataGridViewTextBoxColumn1.HeaderText = "RT_RENTALDATE";
this.rTRENTALDATEDataGridViewTextBoxColumn1.Name = "rTRENTALDATEDataGridViewTextBoxColumn1";
//
// rTRETURNDUEDATEDataGridViewTextBoxColumn1
//
this.rTRETURNDUEDATEDataGridViewTextBoxColumn1.DataPropertyName = "RT_RETURNDUEDATE";
this.rTRETURNDUEDATEDataGridViewTextBoxColumn1.HeaderText = "RT_RETURNDUEDATE";
this.rTRETURNDUEDATEDataGridViewTextBoxColumn1.Name = "rTRETURNDUEDATEDataGridViewTextBoxColumn1";
//
// rTACTUALRETURNDATEDataGridViewTextBoxColumn1
//
this.rTACTUALRETURNDATEDataGridViewTextBoxColumn1.DataPropertyName = "RT_ACTUALRETURNDATE";
this.rTACTUALRETURNDATEDataGridViewTextBoxColumn1.HeaderText = "RT_ACTUALRETURNDATE";
this.rTACTUALRETURNDATEDataGridViewTextBoxColumn1.Name = "rTACTUALRETURNDATEDataGridViewTextBoxColumn1";
//
// rTFEEDataGridViewTextBoxColumn1
//
this.rTFEEDataGridViewTextBoxColumn1.DataPropertyName = "RT_FEE";
this.rTFEEDataGridViewTextBoxColumn1.HeaderText = "RT_FEE";
this.rTFEEDataGridViewTextBoxColumn1.Name = "rTFEEDataGridViewTextBoxColumn1";
//
// rTEMPLOYEEDataGridViewTextBoxColumn1
//
this.rTEMPLOYEEDataGridViewTextBoxColumn1.DataPropertyName = "RT_EMPLOYEE";
this.rTEMPLOYEEDataGridViewTextBoxColumn1.HeaderText = "RT_EMPLOYEE";
this.rTEMPLOYEEDataGridViewTextBoxColumn1.Name = "rTEMPLOYEEDataGridViewTextBoxColumn1";
//
// Form3
//
this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(999, 668);
this.Controls.Add(this.tabControl1);
this.Controls.Add(this.dataGridView1);
this.Controls.Add(this.label1);
this.Name = "Form3";
this.Text = "Form3";
this.Load += new System.EventHandler(this.Form3_Load);
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
this.tabControl1.ResumeLayout(false);
this.tabPage1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGridView3)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).EndInit();
this.tabPage2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGridView4)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.rESERVATIONBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pRODUCTBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.rENTALSTATUSBindingSource)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
Oracle.DataAccess.Client.OracleParameter oracleParameter9 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter10 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter1 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter2 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter11 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter12 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter3 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter4 = new Oracle.DataAccess.Client.OracleParameter();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(book));
this.splitContainer1 = new System.Windows.Forms.SplitContainer();
this.label1 = new System.Windows.Forms.Label();
this.ok_btn = new System.Windows.Forms.Button();
this.textBox1 = new System.Windows.Forms.TextBox();
this.dataGridView1 = new System.Windows.Forms.DataGridView();
this.reservation = new System.Windows.Forms.Button();
this.room2 = new System.Windows.Forms.GroupBox();
this.num_4 = new System.Windows.Forms.CheckBox();
this.num_3 = new System.Windows.Forms.CheckBox();
this.num_2 = new System.Windows.Forms.CheckBox();
this.num_1 = new System.Windows.Forms.CheckBox();
this.room1 = new System.Windows.Forms.GroupBox();
this.num4 = new System.Windows.Forms.CheckBox();
this.num2 = new System.Windows.Forms.CheckBox();
this.num3 = new System.Windows.Forms.CheckBox();
this.num1 = new System.Windows.Forms.CheckBox();
this.nonReserveSeat_Cmd = new Oracle.DataAccess.Client.OracleCommand();
this.oracleConnection1 = new Oracle.DataAccess.Client.OracleConnection();
this.Reserved_Cmd = new Oracle.DataAccess.Client.OracleCommand();
this.dataSet11 = new TrainProject.DataSet1();
this.reservationTableAdapter1 = new TrainProject.DataSet1TableAdapters.RESERVATIONTableAdapter();
this.Insert = new Oracle.DataAccess.Client.OracleCommand();
this.INSERT_resNum_Cmd = new Oracle.DataAccess.Client.OracleCommand();
this.memberTableAdapter1 = new TrainProject.DataSet1TableAdapters.MEMBERTableAdapter();
this.pictureBox1 = new System.Windows.Forms.PictureBox();
((System.ComponentModel.ISupportInitialize)(this.splitContainer1)).BeginInit();
this.splitContainer1.Panel1.SuspendLayout();
this.splitContainer1.Panel2.SuspendLayout();
this.splitContainer1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
this.room2.SuspendLayout();
this.room1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).BeginInit();
this.SuspendLayout();
//
// splitContainer1
//
this.splitContainer1.Dock = System.Windows.Forms.DockStyle.Fill;
this.splitContainer1.Location = new System.Drawing.Point(0, 0);
this.splitContainer1.Name = "splitContainer1";
this.splitContainer1.Orientation = System.Windows.Forms.Orientation.Horizontal;
//
// splitContainer1.Panel1
//
this.splitContainer1.Panel1.Controls.Add(this.pictureBox1);
this.splitContainer1.Panel1.Controls.Add(this.label1);
this.splitContainer1.Panel1.Controls.Add(this.ok_btn);
this.splitContainer1.Panel1.Controls.Add(this.textBox1);
//
// splitContainer1.Panel2
//
this.splitContainer1.Panel2.Controls.Add(this.dataGridView1);
this.splitContainer1.Panel2.Controls.Add(this.reservation);
this.splitContainer1.Panel2.Controls.Add(this.room2);
this.splitContainer1.Panel2.Controls.Add(this.room1);
this.splitContainer1.Size = new System.Drawing.Size(1173, 571);
this.splitContainer1.SplitterDistance = 115;
this.splitContainer1.TabIndex = 0;
//
// label1
//
this.label1.AutoSize = true;
this.label1.Font = new System.Drawing.Font("맑은 고딕", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label1.ForeColor = System.Drawing.Color.White;
this.label1.Location = new System.Drawing.Point(18, 54);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(111, 32);
this.label1.TabIndex = 16;
this.label1.Text = "열차번호";
//
// ok_btn
//
this.ok_btn.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(28)))), ((int)(((byte)(49)))), ((int)(((byte)(50)))));
this.ok_btn.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.ok_btn.Font = new System.Drawing.Font("맑은 고딕", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.ok_btn.ForeColor = System.Drawing.Color.White;
this.ok_btn.Location = new System.Drawing.Point(991, 36);
this.ok_btn.Name = "ok_btn";
this.ok_btn.Size = new System.Drawing.Size(145, 59);
this.ok_btn.TabIndex = 15;
this.ok_btn.Text = "좌석조회";
this.ok_btn.UseVisualStyleBackColor = false;
this.ok_btn.Click += new System.EventHandler(this.ok_btn_Click);
//
// textBox1
//
this.textBox1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(24)))), ((int)(((byte)(50)))), ((int)(((byte)(80)))));
this.textBox1.Font = new System.Drawing.Font("돋움체", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.textBox1.ForeColor = System.Drawing.Color.White;
this.textBox1.Location = new System.Drawing.Point(135, 51);
this.textBox1.Name = "textBox1";
this.textBox1.ReadOnly = true;
this.textBox1.Size = new System.Drawing.Size(118, 35);
this.textBox1.TabIndex = 12;
this.textBox1.TextChanged += new System.EventHandler(this.textBox1_TextChanged);
//
// dataGridView1
//
this.dataGridView1.BackgroundColor = System.Drawing.Color.White;
this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView1.Location = new System.Drawing.Point(193, 32);
this.dataGridView1.Name = "dataGridView1";
this.dataGridView1.RowTemplate.Height = 23;
this.dataGridView1.Size = new System.Drawing.Size(788, 150);
this.dataGridView1.TabIndex = 11;
//
// reservation
//
this.reservation.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(28)))), ((int)(((byte)(49)))), ((int)(((byte)(50)))));
this.reservation.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.reservation.Font = new System.Drawing.Font("맑은 고딕", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.reservation.ForeColor = System.Drawing.Color.White;
this.reservation.Location = new System.Drawing.Point(1013, 364);
this.reservation.Name = "reservation";
this.reservation.Size = new System.Drawing.Size(123, 63);
this.reservation.TabIndex = 10;
this.reservation.Text = "예약";
this.reservation.UseVisualStyleBackColor = false;
this.reservation.Click += new System.EventHandler(this.reservation_Click);
//
// room2
//
this.room2.Controls.Add(this.num_4);
this.room2.Controls.Add(this.num_3);
this.room2.Controls.Add(this.num_2);
this.room2.Controls.Add(this.num_1);
this.room2.Font = new System.Drawing.Font("맑은 고딕", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.room2.ForeColor = System.Drawing.Color.White;
this.room2.Location = new System.Drawing.Point(595, 201);
this.room2.Name = "room2";
this.room2.Size = new System.Drawing.Size(396, 202);
this.room2.TabIndex = 8;
this.room2.TabStop = false;
this.room2.Text = "2호차";
//
// num_4
//
this.num_4.Appearance = System.Windows.Forms.Appearance.Button;
this.num_4.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(78)))), ((int)(((byte)(153)))), ((int)(((byte)(200)))));
this.num_4.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.num_4.Image = ((System.Drawing.Image)(resources.GetObject("num_4.Image")));
this.num_4.Location = new System.Drawing.Point(238, 125);
this.num_4.Name = "num_4";
this.num_4.Size = new System.Drawing.Size(91, 51);
this.num_4.TabIndex = 12;
this.num_4.Text = "8";
this.num_4.TextImageRelation = System.Windows.Forms.TextImageRelation.TextBeforeImage;
this.num_4.UseVisualStyleBackColor = false;
this.num_4.CheckedChanged += new System.EventHandler(this.num_4_CheckedChanged);
//
// num_3
//
this.num_3.Appearance = System.Windows.Forms.Appearance.Button;
this.num_3.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(78)))), ((int)(((byte)(153)))), ((int)(((byte)(200)))));
this.num_3.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.num_3.Image = ((System.Drawing.Image)(resources.GetObject("num_3.Image")));
this.num_3.Location = new System.Drawing.Point(238, 49);
this.num_3.Name = "num_3";
this.num_3.Size = new System.Drawing.Size(91, 51);
this.num_3.TabIndex = 11;
this.num_3.Text = "7";
this.num_3.TextImageRelation = System.Windows.Forms.TextImageRelation.TextBeforeImage;
this.num_3.UseVisualStyleBackColor = false;
this.num_3.CheckedChanged += new System.EventHandler(this.num_3_CheckedChanged);
//
// num_2
//
this.num_2.Appearance = System.Windows.Forms.Appearance.Button;
this.num_2.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(78)))), ((int)(((byte)(153)))), ((int)(((byte)(200)))));
this.num_2.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.num_2.Image = ((System.Drawing.Image)(resources.GetObject("num_2.Image")));
this.num_2.Location = new System.Drawing.Point(80, 125);
this.num_2.Name = "num_2";
this.num_2.Size = new System.Drawing.Size(91, 51);
this.num_2.TabIndex = 10;
this.num_2.Text = "6";
this.num_2.TextImageRelation = System.Windows.Forms.TextImageRelation.TextBeforeImage;
this.num_2.UseVisualStyleBackColor = false;
this.num_2.CheckedChanged += new System.EventHandler(this.num_2_CheckedChanged);
//
// num_1
//
this.num_1.Appearance = System.Windows.Forms.Appearance.Button;
this.num_1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(78)))), ((int)(((byte)(153)))), ((int)(((byte)(200)))));
this.num_1.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.num_1.Image = ((System.Drawing.Image)(resources.GetObject("num_1.Image")));
this.num_1.Location = new System.Drawing.Point(80, 49);
this.num_1.Name = "num_1";
this.num_1.Size = new System.Drawing.Size(91, 51);
this.num_1.TabIndex = 9;
this.num_1.Text = "5";
this.num_1.TextImageRelation = System.Windows.Forms.TextImageRelation.TextBeforeImage;
this.num_1.UseVisualStyleBackColor = false;
this.num_1.CheckedChanged += new System.EventHandler(this.num_1_CheckedChanged);
//
// room1
//
this.room1.Controls.Add(this.num4);
this.room1.Controls.Add(this.num2);
this.room1.Controls.Add(this.num3);
this.room1.Controls.Add(this.num1);
this.room1.Font = new System.Drawing.Font("맑은 고딕", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.room1.ForeColor = System.Drawing.Color.White;
this.room1.Location = new System.Drawing.Point(122, 201);
this.room1.Name = "room1";
this.room1.Size = new System.Drawing.Size(396, 202);
this.room1.TabIndex = 6;
this.room1.TabStop = false;
this.room1.Text = "1호차";
//
// num4
//
this.num4.Appearance = System.Windows.Forms.Appearance.Button;
this.num4.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(78)))), ((int)(((byte)(153)))), ((int)(((byte)(200)))));
this.num4.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.num4.Image = ((System.Drawing.Image)(resources.GetObject("num4.Image")));
this.num4.Location = new System.Drawing.Point(239, 125);
this.num4.Name = "num4";
this.num4.Size = new System.Drawing.Size(91, 51);
this.num4.TabIndex = 11;
this.num4.Text = "4";
this.num4.TextImageRelation = System.Windows.Forms.TextImageRelation.TextBeforeImage;
this.num4.UseVisualStyleBackColor = false;
this.num4.CheckedChanged += new System.EventHandler(this.num4_CheckedChanged);
//
// num2
//
this.num2.Appearance = System.Windows.Forms.Appearance.Button;
this.num2.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(78)))), ((int)(((byte)(153)))), ((int)(((byte)(200)))));
this.num2.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.num2.Image = ((System.Drawing.Image)(resources.GetObject("num2.Image")));
this.num2.Location = new System.Drawing.Point(81, 125);
this.num2.Name = "num2";
this.num2.Size = new System.Drawing.Size(91, 51);
this.num2.TabIndex = 10;
this.num2.Text = "2";
this.num2.TextImageRelation = System.Windows.Forms.TextImageRelation.TextBeforeImage;
this.num2.UseVisualStyleBackColor = false;
this.num2.CheckedChanged += new System.EventHandler(this.num2_CheckedChanged);
//
// num3
//
this.num3.Appearance = System.Windows.Forms.Appearance.Button;
this.num3.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(78)))), ((int)(((byte)(153)))), ((int)(((byte)(200)))));
this.num3.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.num3.Image = ((System.Drawing.Image)(resources.GetObject("num3.Image")));
this.num3.Location = new System.Drawing.Point(239, 49);
this.num3.Name = "num3";
this.num3.Size = new System.Drawing.Size(91, 51);
this.num3.TabIndex = 9;
this.num3.Text = "3";
this.num3.TextImageRelation = System.Windows.Forms.TextImageRelation.TextBeforeImage;
this.num3.UseVisualStyleBackColor = false;
this.num3.CheckedChanged += new System.EventHandler(this.num3_CheckedChanged);
//
// num1
//
this.num1.Appearance = System.Windows.Forms.Appearance.Button;
this.num1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(78)))), ((int)(((byte)(153)))), ((int)(((byte)(200)))));
this.num1.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.num1.Image = ((System.Drawing.Image)(resources.GetObject("num1.Image")));
this.num1.Location = new System.Drawing.Point(81, 49);
this.num1.Name = "num1";
this.num1.Size = new System.Drawing.Size(91, 51);
this.num1.TabIndex = 8;
this.num1.Text = "1";
this.num1.TextImageRelation = System.Windows.Forms.TextImageRelation.TextBeforeImage;
this.num1.UseVisualStyleBackColor = false;
this.num1.CheckedChanged += new System.EventHandler(this.num1_CheckedChanged);
//
// nonReserveSeat_Cmd
//
this.nonReserveSeat_Cmd.Connection = this.oracleConnection1;
oracleParameter9.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter9.ParameterName = "seatTID";
oracleParameter10.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter10.ParameterName = "ResrvTID";
this.nonReserveSeat_Cmd.Parameters.Add(oracleParameter9);
this.nonReserveSeat_Cmd.Parameters.Add(oracleParameter10);
this.nonReserveSeat_Cmd.Transaction = null;
//
// oracleConnection1
//
this.oracleConnection1.ConnectionString = "DATA SOURCE=chaeyeon;USER ID=A5414290;PASSWORD=A5414290";
//
// Reserved_Cmd
//
this.Reserved_Cmd.Connection = this.oracleConnection1;
oracleParameter1.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter1.ParameterName = "Seat_TID";
oracleParameter2.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter2.ParameterName = "Reserve_TID";
oracleParameter11.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Decimal;
oracleParameter11.ParameterName = "S_id";
oracleParameter12.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Decimal;
oracleParameter12.ParameterName = "A_id";
this.Reserved_Cmd.Parameters.Add(oracleParameter1);
this.Reserved_Cmd.Parameters.Add(oracleParameter2);
this.Reserved_Cmd.Parameters.Add(oracleParameter11);
this.Reserved_Cmd.Parameters.Add(oracleParameter12);
this.Reserved_Cmd.Transaction = null;
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// reservationTableAdapter1
//
this.reservationTableAdapter1.ClearBeforeFill = true;
//
// Insert
//
this.Insert.Connection = this.oracleConnection1;
this.Insert.Transaction = null;
//
// INSERT_resNum_Cmd
//
this.INSERT_resNum_Cmd.Connection = this.oracleConnection1;
oracleParameter3.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter3.ParameterName = "M_ID";
oracleParameter4.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Decimal;
oracleParameter4.ParameterName = "RES_NUM";
this.INSERT_resNum_Cmd.Parameters.Add(oracleParameter3);
this.INSERT_resNum_Cmd.Parameters.Add(oracleParameter4);
this.INSERT_resNum_Cmd.Transaction = null;
//
// memberTableAdapter1
//
this.memberTableAdapter1.ClearBeforeFill = true;
//
// pictureBox1
//
this.pictureBox1.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox1.Image")));
this.pictureBox1.Location = new System.Drawing.Point(1147, 0);
this.pictureBox1.Name = "pictureBox1";
this.pictureBox1.Size = new System.Drawing.Size(26, 28);
this.pictureBox1.TabIndex = 29;
this.pictureBox1.TabStop = false;
this.pictureBox1.Click += new System.EventHandler(this.pictureBox1_Click);
//
// book
//
this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(24)))), ((int)(((byte)(50)))), ((int)(((byte)(80)))));
this.ClientSize = new System.Drawing.Size(1173, 571);
this.Controls.Add(this.splitContainer1);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
this.Name = "book";
this.Text = "book";
this.splitContainer1.Panel1.ResumeLayout(false);
this.splitContainer1.Panel1.PerformLayout();
this.splitContainer1.Panel2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.splitContainer1)).EndInit();
this.splitContainer1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
this.room2.ResumeLayout(false);
this.room1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).EndInit();
this.ResumeLayout(false);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(SeatSelect));
Oracle.DataAccess.Client.OracleParameter oracleParameter1 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter2 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter3 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter4 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter5 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter6 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter7 = new Oracle.DataAccess.Client.OracleParameter();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.checkBox4 = new System.Windows.Forms.CheckBox();
this.checkBox3 = new System.Windows.Forms.CheckBox();
this.checkBox2 = new System.Windows.Forms.CheckBox();
this.checkBox1 = new System.Windows.Forms.CheckBox();
this.tb_normal = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.normal = new System.Windows.Forms.Label();
this.child = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.tb_child = new System.Windows.Forms.TextBox();
this.baby = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.tb_baby = new System.Windows.Forms.TextBox();
this.hero = new System.Windows.Forms.Label();
this.label14 = new System.Windows.Forms.Label();
this.tb_hero = new System.Windows.Forms.TextBox();
this.disabled = new System.Windows.Forms.Label();
this.label16 = new System.Windows.Forms.Label();
this.tb_disabled = new System.Windows.Forms.TextBox();
this.old = new System.Windows.Forms.Label();
this.label18 = new System.Windows.Forms.Label();
this.tb_old = new System.Windows.Forms.TextBox();
this.groupBox3 = new System.Windows.Forms.GroupBox();
this.lb_cost = new System.Windows.Forms.Label();
this.btnBooking = new System.Windows.Forms.Button();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.checkBox8 = new System.Windows.Forms.CheckBox();
this.checkBox7 = new System.Windows.Forms.CheckBox();
this.checkBox6 = new System.Windows.Forms.CheckBox();
this.checkBox5 = new System.Windows.Forms.CheckBox();
this.sEATSTATUSBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.dataSet1 = new Train.DataSet1();
this.button2 = new System.Windows.Forms.Button();
this.button3 = new System.Windows.Forms.Button();
this.lb_Seat = new System.Windows.Forms.Label();
this.sEAT_STATUSTableAdapter = new Train.DataSet1TableAdapters.SEAT_STATUSTableAdapter();
this.oracleConnection1 = new Oracle.DataAccess.Client.OracleConnection();
this.cmdSeatUpdate = new Oracle.DataAccess.Client.OracleCommand();
this.cmdSeat = new Oracle.DataAccess.Client.OracleCommand();
this.ticketTableAdapter2 = new Train.DataSet1TableAdapters.TICKETTableAdapter();
this.groupBox1.SuspendLayout();
this.groupBox3.SuspendLayout();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.sEATSTATUSBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit();
this.SuspendLayout();
//
// groupBox1
//
this.groupBox1.Controls.Add(this.checkBox4);
this.groupBox1.Controls.Add(this.checkBox3);
this.groupBox1.Controls.Add(this.checkBox2);
this.groupBox1.Controls.Add(this.checkBox1);
this.groupBox1.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.groupBox1.Location = new System.Drawing.Point(12, 41);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(266, 150);
this.groupBox1.TabIndex = 0;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "1 호차";
//
// checkBox4
//
this.checkBox4.AutoSize = true;
this.checkBox4.Font = new System.Drawing.Font("굴림", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.checkBox4.ForeColor = System.Drawing.SystemColors.ControlLight;
this.checkBox4.Image = ((System.Drawing.Image)(resources.GetObject("checkBox4.Image")));
this.checkBox4.Location = new System.Drawing.Point(135, 89);
this.checkBox4.Name = "checkBox4";
this.checkBox4.Size = new System.Drawing.Size(79, 32);
this.checkBox4.TabIndex = 3;
this.checkBox4.Text = " 4";
this.checkBox4.UseVisualStyleBackColor = true;
//
// checkBox3
//
this.checkBox3.AutoSize = true;
this.checkBox3.Font = new System.Drawing.Font("굴림", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.checkBox3.ForeColor = System.Drawing.SystemColors.ControlLight;
this.checkBox3.Image = ((System.Drawing.Image)(resources.GetObject("checkBox3.Image")));
this.checkBox3.Location = new System.Drawing.Point(47, 89);
this.checkBox3.Name = "checkBox3";
this.checkBox3.Size = new System.Drawing.Size(78, 32);
this.checkBox3.TabIndex = 2;
this.checkBox3.Text = " 3";
this.checkBox3.UseVisualStyleBackColor = true;
//
// checkBox2
//
this.checkBox2.AutoSize = true;
this.checkBox2.Font = new System.Drawing.Font("굴림", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.checkBox2.ForeColor = System.Drawing.SystemColors.ControlLight;
this.checkBox2.Image = ((System.Drawing.Image)(resources.GetObject("checkBox2.Image")));
this.checkBox2.Location = new System.Drawing.Point(136, 31);
this.checkBox2.Name = "checkBox2";
this.checkBox2.Size = new System.Drawing.Size(78, 32);
this.checkBox2.TabIndex = 1;
this.checkBox2.Text = " 2";
this.checkBox2.UseVisualStyleBackColor = true;
//
// checkBox1
//
this.checkBox1.AutoSize = true;
this.checkBox1.Font = new System.Drawing.Font("굴림", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.checkBox1.ForeColor = System.Drawing.SystemColors.ControlLight;
this.checkBox1.Image = ((System.Drawing.Image)(resources.GetObject("checkBox1.Image")));
this.checkBox1.Location = new System.Drawing.Point(47, 31);
this.checkBox1.Name = "checkBox1";
this.checkBox1.Size = new System.Drawing.Size(78, 32);
this.checkBox1.TabIndex = 0;
this.checkBox1.Text = " 1";
this.checkBox1.UseVisualStyleBackColor = true;
//
// tb_normal
//
this.tb_normal.Location = new System.Drawing.Point(77, 36);
this.tb_normal.Name = "tb_normal";
this.tb_normal.Size = new System.Drawing.Size(27, 23);
this.tb_normal.TabIndex = 2;
this.tb_normal.TextChanged += new System.EventHandler(this.tb_normal_TextChanged);
this.tb_normal.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.OnlyNum);
//
// label1
//
this.label1.AutoSize = true;
this.label1.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label1.Location = new System.Drawing.Point(19, 40);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(56, 16);
this.label1.TabIndex = 10;
this.label1.Text = "일반인";
//
// normal
//
this.normal.AutoSize = true;
this.normal.Location = new System.Drawing.Point(107, 41);
this.normal.Name = "normal";
this.normal.Size = new System.Drawing.Size(24, 16);
this.normal.TabIndex = 11;
this.normal.Text = "명";
//
// child
//
this.child.AutoSize = true;
this.child.Location = new System.Drawing.Point(107, 68);
this.child.Name = "child";
this.child.Size = new System.Drawing.Size(24, 16);
this.child.TabIndex = 14;
this.child.Text = "명";
//
// label4
//
this.label4.AutoSize = true;
this.label4.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label4.Location = new System.Drawing.Point(19, 67);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(56, 16);
this.label4.TabIndex = 13;
this.label4.Text = "어린이";
//
// tb_child
//
this.tb_child.Location = new System.Drawing.Point(77, 63);
this.tb_child.Name = "tb_child";
this.tb_child.Size = new System.Drawing.Size(27, 23);
this.tb_child.TabIndex = 12;
this.tb_child.TextChanged += new System.EventHandler(this.tb_child_TextChanged);
this.tb_child.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.OnlyNum);
//
// baby
//
this.baby.AutoSize = true;
this.baby.Location = new System.Drawing.Point(107, 95);
this.baby.Name = "baby";
this.baby.Size = new System.Drawing.Size(24, 16);
this.baby.TabIndex = 17;
this.baby.Text = "명";
//
// label6
//
this.label6.AutoSize = true;
this.label6.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label6.Location = new System.Drawing.Point(19, 93);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(40, 16);
this.label6.TabIndex = 16;
this.label6.Text = "유아";
//
// tb_baby
//
this.tb_baby.Location = new System.Drawing.Point(77, 90);
this.tb_baby.Name = "tb_baby";
this.tb_baby.Size = new System.Drawing.Size(27, 23);
this.tb_baby.TabIndex = 15;
this.tb_baby.TextChanged += new System.EventHandler(this.tb_baby_TextChanged);
this.tb_baby.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.OnlyNum);
//
// hero
//
this.hero.AutoSize = true;
this.hero.Location = new System.Drawing.Point(351, 94);
this.hero.Name = "hero";
this.hero.Size = new System.Drawing.Size(24, 16);
this.hero.TabIndex = 35;
this.hero.Text = "명";
//
// label14
//
this.label14.AutoSize = true;
this.label14.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label14.Location = new System.Drawing.Point(231, 93);
this.label14.Name = "label14";
this.label14.Size = new System.Drawing.Size(88, 16);
this.label14.TabIndex = 34;
this.label14.Text = "국가유공자";
//
// tb_hero
//
this.tb_hero.Location = new System.Drawing.Point(321, 89);
this.tb_hero.Name = "tb_hero";
this.tb_hero.Size = new System.Drawing.Size(27, 23);
this.tb_hero.TabIndex = 33;
this.tb_hero.TextChanged += new System.EventHandler(this.tb_hero_TextChanged);
this.tb_hero.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.OnlyNum);
//
// disabled
//
this.disabled.AutoSize = true;
this.disabled.Location = new System.Drawing.Point(351, 67);
this.disabled.Name = "disabled";
this.disabled.Size = new System.Drawing.Size(24, 16);
this.disabled.TabIndex = 32;
this.disabled.Text = "명";
//
// label16
//
this.label16.AutoSize = true;
this.label16.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label16.Location = new System.Drawing.Point(231, 66);
this.label16.Name = "label16";
this.label16.Size = new System.Drawing.Size(56, 16);
this.label16.TabIndex = 31;
this.label16.Text = "장애인";
//
// tb_disabled
//
this.tb_disabled.Location = new System.Drawing.Point(321, 62);
this.tb_disabled.Name = "tb_disabled";
this.tb_disabled.Size = new System.Drawing.Size(27, 23);
this.tb_disabled.TabIndex = 30;
this.tb_disabled.TextChanged += new System.EventHandler(this.tb_disabled_TextChanged);
this.tb_disabled.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.OnlyNum);
//
// old
//
this.old.AutoSize = true;
this.old.Location = new System.Drawing.Point(351, 40);
this.old.Name = "old";
this.old.Size = new System.Drawing.Size(24, 16);
this.old.TabIndex = 29;
this.old.Text = "명";
//
// label18
//
this.label18.AutoSize = true;
this.label18.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label18.Location = new System.Drawing.Point(231, 39);
this.label18.Name = "label18";
this.label18.Size = new System.Drawing.Size(40, 16);
this.label18.TabIndex = 28;
this.label18.Text = "경로";
//
// tb_old
//
this.tb_old.Location = new System.Drawing.Point(321, 35);
this.tb_old.Name = "tb_old";
this.tb_old.Size = new System.Drawing.Size(27, 23);
this.tb_old.TabIndex = 27;
this.tb_old.TextChanged += new System.EventHandler(this.tb_old_TextChanged);
this.tb_old.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.OnlyNum);
//
// groupBox3
//
this.groupBox3.Controls.Add(this.lb_cost);
this.groupBox3.Controls.Add(this.tb_normal);
this.groupBox3.Controls.Add(this.label16);
this.groupBox3.Controls.Add(this.tb_old);
this.groupBox3.Controls.Add(this.label1);
this.groupBox3.Controls.Add(this.label18);
this.groupBox3.Controls.Add(this.old);
this.groupBox3.Controls.Add(this.baby);
this.groupBox3.Controls.Add(this.tb_disabled);
this.groupBox3.Controls.Add(this.normal);
this.groupBox3.Controls.Add(this.disabled);
this.groupBox3.Controls.Add(this.label6);
this.groupBox3.Controls.Add(this.hero);
this.groupBox3.Controls.Add(this.tb_baby);
this.groupBox3.Controls.Add(this.tb_hero);
this.groupBox3.Controls.Add(this.tb_child);
this.groupBox3.Controls.Add(this.label14);
this.groupBox3.Controls.Add(this.child);
this.groupBox3.Controls.Add(this.label4);
this.groupBox3.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.groupBox3.Location = new System.Drawing.Point(12, 220);
this.groupBox3.Name = "groupBox3";
this.groupBox3.Size = new System.Drawing.Size(542, 141);
this.groupBox3.TabIndex = 39;
this.groupBox3.TabStop = false;
this.groupBox3.Text = "인원 선택";
//
// lb_cost
//
this.lb_cost.AutoSize = true;
this.lb_cost.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.lb_cost.Location = new System.Drawing.Point(409, 114);
this.lb_cost.Name = "lb_cost";
this.lb_cost.Size = new System.Drawing.Size(62, 16);
this.lb_cost.TabIndex = 36;
this.lb_cost.Text = "요금 : 0";
//
// btnBooking
//
this.btnBooking.BackColor = System.Drawing.SystemColors.GradientActiveCaption;
this.btnBooking.Location = new System.Drawing.Point(451, 367);
this.btnBooking.Name = "btnBooking";
this.btnBooking.Size = new System.Drawing.Size(103, 23);
this.btnBooking.TabIndex = 40;
this.btnBooking.Text = "예약하기";
this.btnBooking.UseVisualStyleBackColor = false;
this.btnBooking.Click += new System.EventHandler(this.BookingClick);
//
// groupBox2
//
this.groupBox2.Controls.Add(this.checkBox8);
this.groupBox2.Controls.Add(this.checkBox7);
this.groupBox2.Controls.Add(this.checkBox6);
this.groupBox2.Controls.Add(this.checkBox5);
this.groupBox2.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.groupBox2.Location = new System.Drawing.Point(288, 41);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(266, 150);
this.groupBox2.TabIndex = 41;
this.groupBox2.TabStop = false;
this.groupBox2.Text = "2 호차";
//
// checkBox8
//
this.checkBox8.AutoSize = true;
this.checkBox8.Font = new System.Drawing.Font("굴림", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.checkBox8.ForeColor = System.Drawing.SystemColors.ControlLight;
this.checkBox8.Image = ((System.Drawing.Image)(resources.GetObject("checkBox8.Image")));
this.checkBox8.Location = new System.Drawing.Point(135, 89);
this.checkBox8.Name = "checkBox8";
this.checkBox8.Size = new System.Drawing.Size(79, 32);
this.checkBox8.TabIndex = 3;
this.checkBox8.Text = " 4";
this.checkBox8.UseVisualStyleBackColor = true;
//
// checkBox7
//
this.checkBox7.AutoSize = true;
this.checkBox7.Font = new System.Drawing.Font("굴림", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.checkBox7.ForeColor = System.Drawing.SystemColors.ControlLight;
this.checkBox7.Image = ((System.Drawing.Image)(resources.GetObject("checkBox7.Image")));
this.checkBox7.Location = new System.Drawing.Point(47, 89);
this.checkBox7.Name = "checkBox7";
this.checkBox7.Size = new System.Drawing.Size(78, 32);
this.checkBox7.TabIndex = 2;
this.checkBox7.Text = " 3";
this.checkBox7.UseVisualStyleBackColor = true;
//
// checkBox6
//
this.checkBox6.AutoSize = true;
this.checkBox6.Font = new System.Drawing.Font("굴림", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.checkBox6.ForeColor = System.Drawing.SystemColors.ControlLight;
this.checkBox6.Image = ((System.Drawing.Image)(resources.GetObject("checkBox6.Image")));
this.checkBox6.Location = new System.Drawing.Point(136, 31);
this.checkBox6.Name = "checkBox6";
this.checkBox6.Size = new System.Drawing.Size(78, 32);
this.checkBox6.TabIndex = 1;
this.checkBox6.Text = " 2";
this.checkBox6.UseVisualStyleBackColor = true;
//
// checkBox5
//
this.checkBox5.AutoSize = true;
this.checkBox5.Font = new System.Drawing.Font("굴림", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.checkBox5.ForeColor = System.Drawing.SystemColors.ControlLight;
this.checkBox5.Image = ((System.Drawing.Image)(resources.GetObject("checkBox5.Image")));
this.checkBox5.Location = new System.Drawing.Point(47, 31);
this.checkBox5.Name = "checkBox5";
this.checkBox5.Size = new System.Drawing.Size(78, 32);
this.checkBox5.TabIndex = 0;
this.checkBox5.Text = " 1";
this.checkBox5.UseVisualStyleBackColor = true;
//
// sEATSTATUSBindingSource
//
this.sEATSTATUSBindingSource.DataMember = "SEAT_STATUS";
this.sEATSTATUSBindingSource.DataSource = this.dataSet1;
//
// dataSet1
//
this.dataSet1.DataSetName = "DataSet1";
this.dataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// button2
//
this.button2.BackColor = System.Drawing.SystemColors.GradientActiveCaption;
this.button2.Location = new System.Drawing.Point(398, 197);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(75, 23);
this.button2.TabIndex = 42;
this.button2.Text = "좌석 선택";
this.button2.UseVisualStyleBackColor = false;
this.button2.Click += new System.EventHandler(this.SelectSeatClick);
//
// button3
//
this.button3.BackColor = System.Drawing.SystemColors.GradientActiveCaption;
this.button3.Location = new System.Drawing.Point(479, 197);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(75, 23);
this.button3.TabIndex = 43;
this.button3.Text = "다시 선택";
this.button3.UseVisualStyleBackColor = false;
this.button3.Click += new System.EventHandler(this.RetryClick);
//
// lb_Seat
//
this.lb_Seat.AutoSize = true;
this.lb_Seat.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.lb_Seat.Location = new System.Drawing.Point(262, 201);
this.lb_Seat.Name = "lb_Seat";
this.lb_Seat.Size = new System.Drawing.Size(134, 16);
this.lb_Seat.TabIndex = 44;
this.lb_Seat.Text = "선택된 좌석 수 : 0";
//
// sEAT_STATUSTableAdapter
//
this.sEAT_STATUSTableAdapter.ClearBeforeFill = true;
//
// oracleConnection1
//
this.oracleConnection1.ConnectionString = "DATA SOURCE=HONG;USER ID=A5293348;PASSWORD=A5293348";
//
// cmdSeatUpdate
//
this.cmdSeatUpdate.CommandText = "UPDATE SEAT_STATUS SET STATUS = \'1\' WHERE TRAIN_ID = :T_ID AND ROOM_NUM = :R_NUM " +
"AND S_NUM = :S_NUM AND ST_NAME = :ST";
this.cmdSeatUpdate.Connection = this.oracleConnection1;
oracleParameter1.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter1.ParameterName = "T_ID";
oracleParameter2.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int32;
oracleParameter2.ParameterName = "R_NUM";
oracleParameter3.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int32;
oracleParameter3.ParameterName = "S_NUM";
oracleParameter4.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter4.ParameterName = "ST";
this.cmdSeatUpdate.Parameters.Add(oracleParameter1);
this.cmdSeatUpdate.Parameters.Add(oracleParameter2);
this.cmdSeatUpdate.Parameters.Add(oracleParameter3);
this.cmdSeatUpdate.Parameters.Add(oracleParameter4);
this.cmdSeatUpdate.Transaction = null;
//
// cmdSeat
//
this.cmdSeat.CommandText = resources.GetString("cmdSeat.CommandText");
this.cmdSeat.Connection = this.oracleConnection1;
oracleParameter5.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter5.ParameterName = "T_ID";
oracleParameter6.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter6.ParameterName = "DIREC";
oracleParameter7.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter7.ParameterName = "ST";
this.cmdSeat.Parameters.Add(oracleParameter5);
this.cmdSeat.Parameters.Add(oracleParameter6);
this.cmdSeat.Parameters.Add(oracleParameter7);
this.cmdSeat.Transaction = null;
//
// ticketTableAdapter2
//
this.ticketTableAdapter2.ClearBeforeFill = true;
//
// SeatSelect
//
this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.BackColor = System.Drawing.SystemColors.ActiveCaption;
this.ClientSize = new System.Drawing.Size(566, 406);
this.Controls.Add(this.lb_Seat);
this.Controls.Add(this.button3);
this.Controls.Add(this.button2);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.btnBooking);
this.Controls.Add(this.groupBox3);
this.Controls.Add(this.groupBox1);
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.Name = "SeatSelect";
this.Text = "칙-칙 폭-폭";
this.Load += new System.EventHandler(this.SeatSelect_Load);
this.groupBox1.ResumeLayout(false);
this.groupBox1.PerformLayout();
this.groupBox3.ResumeLayout(false);
this.groupBox3.PerformLayout();
this.groupBox2.ResumeLayout(false);
this.groupBox2.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.sEATSTATUSBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
Oracle.DataAccess.Client.OracleParameter oracleParameter1 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter2 = new Oracle.DataAccess.Client.OracleParameter();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(mainPage1));
this.splitContainer1 = new System.Windows.Forms.SplitContainer();
this.tabControl1 = new System.Windows.Forms.TabControl();
this.tabPage1 = new System.Windows.Forms.TabPage();
this.arrive_combobox = new System.Windows.Forms.ComboBox();
this.sTATIONBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.dataSet12 = new TrainProject.DataSet1();
this.sTATIONBindingSource1 = new System.Windows.Forms.BindingSource(this.components);
this.source_combobox = new System.Windows.Forms.ComboBox();
this.duration = new System.Windows.Forms.GroupBox();
this.busan_radio = new System.Windows.Forms.RadioButton();
this.seoul_radio = new System.Windows.Forms.RadioButton();
this.label3 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.search_tran_btn = new System.Windows.Forms.Button();
this.dateTime_Search = new System.Windows.Forms.DateTimePicker();
this.label5 = new System.Windows.Forms.Label();
this.tabPage2 = new System.Windows.Forms.TabPage();
this.button2 = new System.Windows.Forms.Button();
this.cancle_btn = new System.Windows.Forms.Button();
this.dataGridView1 = new System.Windows.Forms.DataGridView();
this.button1 = new System.Windows.Forms.Button();
this.train_gridView = new System.Windows.Forms.DataGridView();
this.tIDDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.a2AIDDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.rSTATEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.tDATEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.출발역DataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.도착역DataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.rOUTEBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.dataSet1 = new TrainProject.DataSet1();
this.sTATIONTableAdapter = new TrainProject.DataSet1TableAdapters.STATIONTableAdapter();
this.rOUTETableAdapter = new TrainProject.DataSet1TableAdapters.ROUTETableAdapter();
this.dataSet11 = new TrainProject.DataSet1();
this.book_info_Cmd = new Oracle.DataAccess.Client.OracleCommand();
this.oracleConnection1 = new Oracle.DataAccess.Client.OracleConnection();
this.my_booking_Cmd = new Oracle.DataAccess.Client.OracleCommand();
this.reservedTableAdapter1 = new TrainProject.DataSet1TableAdapters.RESERVEDTableAdapter();
this.label1 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.pictureBox1 = new System.Windows.Forms.PictureBox();
((System.ComponentModel.ISupportInitialize)(this.splitContainer1)).BeginInit();
this.splitContainer1.Panel1.SuspendLayout();
this.splitContainer1.Panel2.SuspendLayout();
this.splitContainer1.SuspendLayout();
this.tabControl1.SuspendLayout();
this.tabPage1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.sTATIONBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet12)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.sTATIONBindingSource1)).BeginInit();
this.duration.SuspendLayout();
this.tabPage2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.train_gridView)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.rOUTEBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).BeginInit();
this.SuspendLayout();
//
// splitContainer1
//
this.splitContainer1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(24)))), ((int)(((byte)(50)))), ((int)(((byte)(80)))));
this.splitContainer1.Dock = System.Windows.Forms.DockStyle.Fill;
this.splitContainer1.Location = new System.Drawing.Point(0, 0);
this.splitContainer1.Name = "splitContainer1";
//
// splitContainer1.Panel1
//
this.splitContainer1.Panel1.Controls.Add(this.tabControl1);
this.splitContainer1.Panel1.Paint += new System.Windows.Forms.PaintEventHandler(this.splitContainer1_Panel1_Paint);
//
// splitContainer1.Panel2
//
this.splitContainer1.Panel2.AutoScroll = true;
this.splitContainer1.Panel2.Controls.Add(this.pictureBox1);
this.splitContainer1.Panel2.Controls.Add(this.label1);
this.splitContainer1.Panel2.Controls.Add(this.button1);
this.splitContainer1.Panel2.Controls.Add(this.train_gridView);
this.splitContainer1.Size = new System.Drawing.Size(1280, 500);
this.splitContainer1.SplitterDistance = 517;
this.splitContainer1.SplitterWidth = 5;
this.splitContainer1.TabIndex = 0;
//
// tabControl1
//
this.tabControl1.Controls.Add(this.tabPage1);
this.tabControl1.Controls.Add(this.tabPage2);
this.tabControl1.Font = new System.Drawing.Font("돋움체", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.tabControl1.Location = new System.Drawing.Point(21, 3);
this.tabControl1.Multiline = true;
this.tabControl1.Name = "tabControl1";
this.tabControl1.SelectedIndex = 0;
this.tabControl1.Size = new System.Drawing.Size(487, 488);
this.tabControl1.TabIndex = 46;
//
// tabPage1
//
this.tabPage1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(78)))), ((int)(((byte)(90)))), ((int)(((byte)(150)))));
this.tabPage1.BackgroundImageLayout = System.Windows.Forms.ImageLayout.None;
this.tabPage1.Controls.Add(this.arrive_combobox);
this.tabPage1.Controls.Add(this.source_combobox);
this.tabPage1.Controls.Add(this.duration);
this.tabPage1.Controls.Add(this.label3);
this.tabPage1.Controls.Add(this.label2);
this.tabPage1.Controls.Add(this.search_tran_btn);
this.tabPage1.Controls.Add(this.dateTime_Search);
this.tabPage1.Controls.Add(this.label5);
this.tabPage1.ForeColor = System.Drawing.Color.Black;
this.tabPage1.Location = new System.Drawing.Point(4, 26);
this.tabPage1.Name = "tabPage1";
this.tabPage1.Padding = new System.Windows.Forms.Padding(3);
this.tabPage1.Size = new System.Drawing.Size(479, 458);
this.tabPage1.TabIndex = 0;
this.tabPage1.Text = "열차예약";
//
// arrive_combobox
//
this.arrive_combobox.BackColor = System.Drawing.SystemColors.MenuBar;
this.arrive_combobox.DataBindings.Add(new System.Windows.Forms.Binding("SelectedValue", this.sTATIONBindingSource, "S_NAME", true));
this.arrive_combobox.DataSource = this.sTATIONBindingSource1;
this.arrive_combobox.DisplayMember = "S_NAME";
this.arrive_combobox.Font = new System.Drawing.Font("돋움", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.arrive_combobox.FormattingEnabled = true;
this.arrive_combobox.Location = new System.Drawing.Point(136, 227);
this.arrive_combobox.Name = "arrive_combobox";
this.arrive_combobox.Size = new System.Drawing.Size(216, 29);
this.arrive_combobox.TabIndex = 61;
this.arrive_combobox.ValueMember = "S_NAME";
//
// sTATIONBindingSource
//
this.sTATIONBindingSource.DataMember = "STATION";
this.sTATIONBindingSource.DataSource = this.dataSet12;
//
// dataSet12
//
this.dataSet12.DataSetName = "DataSet1";
this.dataSet12.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// sTATIONBindingSource1
//
this.sTATIONBindingSource1.DataMember = "STATION";
this.sTATIONBindingSource1.DataSource = this.dataSet12;
//
// source_combobox
//
this.source_combobox.BackColor = System.Drawing.SystemColors.MenuBar;
this.source_combobox.DataSource = this.sTATIONBindingSource;
this.source_combobox.DisplayMember = "S_NAME";
this.source_combobox.Font = new System.Drawing.Font("돋움", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.source_combobox.FormattingEnabled = true;
this.source_combobox.Location = new System.Drawing.Point(136, 163);
this.source_combobox.Name = "source_combobox";
this.source_combobox.Size = new System.Drawing.Size(216, 29);
this.source_combobox.TabIndex = 60;
this.source_combobox.ValueMember = "S_NAME";
//
// duration
//
this.duration.Controls.Add(this.busan_radio);
this.duration.Controls.Add(this.seoul_radio);
this.duration.Location = new System.Drawing.Point(63, 43);
this.duration.Name = "duration";
this.duration.Size = new System.Drawing.Size(360, 85);
this.duration.TabIndex = 59;
this.duration.TabStop = false;
//
// busan_radio
//
this.busan_radio.AutoSize = true;
this.busan_radio.Font = new System.Drawing.Font("맑은 고딕", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.busan_radio.ForeColor = System.Drawing.Color.White;
this.busan_radio.Location = new System.Drawing.Point(204, 30);
this.busan_radio.Name = "busan_radio";
this.busan_radio.Size = new System.Drawing.Size(94, 34);
this.busan_radio.TabIndex = 44;
this.busan_radio.TabStop = true;
this.busan_radio.Text = "부산행";
this.busan_radio.UseVisualStyleBackColor = true;
//
// seoul_radio
//
this.seoul_radio.AutoSize = true;
this.seoul_radio.Font = new System.Drawing.Font("맑은 고딕", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.seoul_radio.ForeColor = System.Drawing.Color.White;
this.seoul_radio.Location = new System.Drawing.Point(57, 30);
this.seoul_radio.Name = "seoul_radio";
this.seoul_radio.Size = new System.Drawing.Size(94, 34);
this.seoul_radio.TabIndex = 43;
this.seoul_radio.TabStop = true;
this.seoul_radio.Text = "서울행";
this.seoul_radio.UseVisualStyleBackColor = true;
//
// label3
//
this.label3.AutoSize = true;
this.label3.Font = new System.Drawing.Font("맑은 고딕", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label3.ForeColor = System.Drawing.Color.White;
this.label3.Location = new System.Drawing.Point(75, 219);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(55, 30);
this.label3.TabIndex = 58;
this.label3.Text = "도착";
//
// label2
//
this.label2.AutoSize = true;
this.label2.Font = new System.Drawing.Font("맑은 고딕", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label2.ForeColor = System.Drawing.Color.White;
this.label2.Location = new System.Drawing.Point(75, 159);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(55, 30);
this.label2.TabIndex = 57;
this.label2.Text = "출발";
//
// search_tran_btn
//
this.search_tran_btn.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(28)))), ((int)(((byte)(49)))), ((int)(((byte)(50)))));
this.search_tran_btn.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.search_tran_btn.Font = new System.Drawing.Font("맑은 고딕", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.search_tran_btn.ForeColor = System.Drawing.Color.White;
this.search_tran_btn.Location = new System.Drawing.Point(267, 357);
this.search_tran_btn.Name = "search_tran_btn";
this.search_tran_btn.Size = new System.Drawing.Size(168, 62);
this.search_tran_btn.TabIndex = 56;
this.search_tran_btn.Text = "열차조회";
this.search_tran_btn.UseVisualStyleBackColor = false;
this.search_tran_btn.Click += new System.EventHandler(this.search_tran_btn_Click_1);
//
// dateTime_Search
//
this.dateTime_Search.CalendarFont = new System.Drawing.Font("맑은 고딕", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.dateTime_Search.Font = new System.Drawing.Font("굴림", 13.8F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.dateTime_Search.Location = new System.Drawing.Point(136, 296);
this.dateTime_Search.Name = "dateTime_Search";
this.dateTime_Search.Size = new System.Drawing.Size(216, 29);
this.dateTime_Search.TabIndex = 55;
//
// label5
//
this.label5.AutoSize = true;
this.label5.Font = new System.Drawing.Font("맑은 고딕", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label5.ForeColor = System.Drawing.Color.White;
this.label5.Location = new System.Drawing.Point(76, 292);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(55, 30);
this.label5.TabIndex = 54;
this.label5.Text = "날짜";
//
// tabPage2
//
this.tabPage2.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(78)))), ((int)(((byte)(90)))), ((int)(((byte)(150)))));
this.tabPage2.Controls.Add(this.label4);
this.tabPage2.Controls.Add(this.button2);
this.tabPage2.Controls.Add(this.cancle_btn);
this.tabPage2.Controls.Add(this.dataGridView1);
this.tabPage2.Location = new System.Drawing.Point(4, 26);
this.tabPage2.Name = "tabPage2";
this.tabPage2.Padding = new System.Windows.Forms.Padding(3);
this.tabPage2.Size = new System.Drawing.Size(479, 458);
this.tabPage2.TabIndex = 1;
this.tabPage2.Text = "예약조회";
this.tabPage2.Click += new System.EventHandler(this.tabPage2_Click);
//
// button2
//
this.button2.BackColor = System.Drawing.SystemColors.ActiveCaption;
this.button2.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.button2.Font = new System.Drawing.Font("돋움체", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.button2.Location = new System.Drawing.Point(323, 260);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(129, 41);
this.button2.TabIndex = 44;
this.button2.Text = "재확인";
this.button2.UseVisualStyleBackColor = false;
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// cancle_btn
//
this.cancle_btn.BackColor = System.Drawing.SystemColors.ActiveCaption;
this.cancle_btn.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.cancle_btn.Font = new System.Drawing.Font("돋움체", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.cancle_btn.Location = new System.Drawing.Point(174, 260);
this.cancle_btn.Name = "cancle_btn";
this.cancle_btn.Size = new System.Drawing.Size(129, 41);
this.cancle_btn.TabIndex = 43;
this.cancle_btn.Text = "예약취소";
this.cancle_btn.UseVisualStyleBackColor = false;
this.cancle_btn.Click += new System.EventHandler(this.cancle_btn_Click);
//
// dataGridView1
//
this.dataGridView1.BackgroundColor = System.Drawing.Color.White;
this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView1.Location = new System.Drawing.Point(6, 80);
this.dataGridView1.Name = "dataGridView1";
this.dataGridView1.RowTemplate.Height = 23;
this.dataGridView1.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect;
this.dataGridView1.Size = new System.Drawing.Size(455, 168);
this.dataGridView1.TabIndex = 0;
this.dataGridView1.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.train_gridView_CellMouseClick);
//
// button1
//
this.button1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(28)))), ((int)(((byte)(49)))), ((int)(((byte)(50)))));
this.button1.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this.button1.Font = new System.Drawing.Font("맑은 고딕", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.button1.ForeColor = System.Drawing.Color.White;
this.button1.Location = new System.Drawing.Point(582, 386);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(152, 62);
this.button1.TabIndex = 41;
this.button1.Text = "좌석선택";
this.button1.UseVisualStyleBackColor = false;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// train_gridView
//
dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.TopLeft;
dataGridViewCellStyle1.BackColor = System.Drawing.Color.White;
this.train_gridView.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1;
this.train_gridView.Anchor = System.Windows.Forms.AnchorStyles.None;
this.train_gridView.AutoGenerateColumns = false;
this.train_gridView.BackgroundColor = System.Drawing.Color.White;
this.train_gridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.train_gridView.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.tIDDataGridViewTextBoxColumn,
this.dataGridViewTextBoxColumn1,
this.a2AIDDataGridViewTextBoxColumn,
this.rSTATEDataGridViewTextBoxColumn,
this.tDATEDataGridViewTextBoxColumn,
this.출발역DataGridViewTextBoxColumn,
this.도착역DataGridViewTextBoxColumn
});
this.train_gridView.DataSource = this.rOUTEBindingSource;
this.train_gridView.EditMode = System.Windows.Forms.DataGridViewEditMode.EditOnF2;
this.train_gridView.Location = new System.Drawing.Point(45, 111);
this.train_gridView.Margin = new System.Windows.Forms.Padding(23, 22, 23, 22);
this.train_gridView.MultiSelect = false;
this.train_gridView.Name = "train_gridView";
this.train_gridView.RowHeadersVisible = false;
this.train_gridView.RowHeadersWidthSizeMode = System.Windows.Forms.DataGridViewRowHeadersWidthSizeMode.AutoSizeToFirstHeader;
this.train_gridView.RowTemplate.Height = 23;
this.train_gridView.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect;
this.train_gridView.Size = new System.Drawing.Size(703, 221);
this.train_gridView.TabIndex = 0;
this.train_gridView.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.train_gridView_CellMouseClick);
//
// tIDDataGridViewTextBoxColumn
//
this.tIDDataGridViewTextBoxColumn.DataPropertyName = "T_ID";
this.tIDDataGridViewTextBoxColumn.HeaderText = "열차번호";
this.tIDDataGridViewTextBoxColumn.Name = "tIDDataGridViewTextBoxColumn";
this.tIDDataGridViewTextBoxColumn.ReadOnly = true;
//
// dataGridViewTextBoxColumn1
//
this.dataGridViewTextBoxColumn1.DataPropertyName = "SOURCE_S_ID";
this.dataGridViewTextBoxColumn1.HeaderText = "출발역번호";
this.dataGridViewTextBoxColumn1.Name = "dataGridViewTextBoxColumn1";
this.dataGridViewTextBoxColumn1.ReadOnly = true;
//
// a2AIDDataGridViewTextBoxColumn
//
this.a2AIDDataGridViewTextBoxColumn.DataPropertyName = "A2_A_ID";
this.a2AIDDataGridViewTextBoxColumn.HeaderText = "도착역번호";
this.a2AIDDataGridViewTextBoxColumn.Name = "a2AIDDataGridViewTextBoxColumn";
this.a2AIDDataGridViewTextBoxColumn.ReadOnly = true;
//
// rSTATEDataGridViewTextBoxColumn
//
this.rSTATEDataGridViewTextBoxColumn.DataPropertyName = "R_STATE";
this.rSTATEDataGridViewTextBoxColumn.HeaderText = "상태";
this.rSTATEDataGridViewTextBoxColumn.Name = "rSTATEDataGridViewTextBoxColumn";
this.rSTATEDataGridViewTextBoxColumn.ReadOnly = true;
//
// tDATEDataGridViewTextBoxColumn
//
this.tDATEDataGridViewTextBoxColumn.DataPropertyName = "T_DATE";
this.tDATEDataGridViewTextBoxColumn.HeaderText = "날짜";
this.tDATEDataGridViewTextBoxColumn.Name = "tDATEDataGridViewTextBoxColumn";
this.tDATEDataGridViewTextBoxColumn.ReadOnly = true;
//
// 출발역DataGridViewTextBoxColumn
//
this.출발역DataGridViewTextBoxColumn.DataPropertyName = "출발역";
this.출발역DataGridViewTextBoxColumn.HeaderText = "출발역";
this.출발역DataGridViewTextBoxColumn.Name = "출발역DataGridViewTextBoxColumn";
this.출발역DataGridViewTextBoxColumn.ReadOnly = true;
//
// 도착역DataGridViewTextBoxColumn
//
this.도착역DataGridViewTextBoxColumn.DataPropertyName = "도착역";
this.도착역DataGridViewTextBoxColumn.HeaderText = "도착역";
this.도착역DataGridViewTextBoxColumn.Name = "도착역DataGridViewTextBoxColumn";
this.도착역DataGridViewTextBoxColumn.ReadOnly = true;
//
// rOUTEBindingSource
//
this.rOUTEBindingSource.DataMember = "ROUTE";
this.rOUTEBindingSource.DataSource = this.dataSet1;
//
// dataSet1
//
this.dataSet1.DataSetName = "DataSet1";
this.dataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// sTATIONTableAdapter
//
this.sTATIONTableAdapter.ClearBeforeFill = true;
//
// rOUTETableAdapter
//
this.rOUTETableAdapter.ClearBeforeFill = true;
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// book_info_Cmd
//
this.book_info_Cmd.Connection = this.oracleConnection1;
oracleParameter1.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Decimal;
oracleParameter1.ParameterName = "RES_NUM";
this.book_info_Cmd.Parameters.Add(oracleParameter1);
this.book_info_Cmd.Transaction = null;
//
// oracleConnection1
//
this.oracleConnection1.ConnectionString = "DATA SOURCE=chaeyeon;USER ID=A5414290;PASSWORD=A5414290";
//
// my_booking_Cmd
//
this.my_booking_Cmd.Connection = this.oracleConnection1;
oracleParameter2.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter2.ParameterName = "M_ID";
this.my_booking_Cmd.Parameters.Add(oracleParameter2);
this.my_booking_Cmd.Transaction = null;
//
// reservedTableAdapter1
//
this.reservedTableAdapter1.ClearBeforeFill = true;
//
// label1
//
this.label1.AutoSize = true;
this.label1.Font = new System.Drawing.Font("맑은 고딕", 26.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label1.ForeColor = System.Drawing.Color.White;
this.label1.Location = new System.Drawing.Point(54, 42);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(195, 47);
this.label1.TabIndex = 42;
this.label1.Text = "열차시간표";
//
// label4
//
this.label4.AutoSize = true;
this.label4.Font = new System.Drawing.Font("맑은 고딕", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label4.ForeColor = System.Drawing.Color.White;
this.label4.Location = new System.Drawing.Point(6, 45);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(167, 32);
this.label4.TabIndex = 45;
this.label4.Text = "나의 예약현황";
//
// pictureBox1
//
this.pictureBox1.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox1.Image")));
this.pictureBox1.Location = new System.Drawing.Point(732, 3);
this.pictureBox1.Name = "pictureBox1";
this.pictureBox1.Size = new System.Drawing.Size(26, 28);
this.pictureBox1.TabIndex = 43;
this.pictureBox1.TabStop = false;
this.pictureBox1.Click += new System.EventHandler(this.pictureBox1_Click);
//
// mainPage1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(24)))), ((int)(((byte)(50)))), ((int)(((byte)(80)))));
this.ClientSize = new System.Drawing.Size(1280, 500);
this.Controls.Add(this.splitContainer1);
this.Font = new System.Drawing.Font("굴림", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
this.Name = "mainPage1";
this.Text = "열차조회";
this.Load += new System.EventHandler(this.mainPage1_Load);
this.splitContainer1.Panel1.ResumeLayout(false);
this.splitContainer1.Panel2.ResumeLayout(false);
this.splitContainer1.Panel2.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.splitContainer1)).EndInit();
this.splitContainer1.ResumeLayout(false);
this.tabControl1.ResumeLayout(false);
this.tabPage1.ResumeLayout(false);
this.tabPage1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.sTATIONBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet12)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.sTATIONBindingSource1)).EndInit();
this.duration.ResumeLayout(false);
this.duration.PerformLayout();
this.tabPage2.ResumeLayout(false);
this.tabPage2.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.train_gridView)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.rOUTEBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).EndInit();
this.ResumeLayout(false);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Main));
Oracle.DataAccess.Client.OracleParameter oracleParameter8 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter9 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter10 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter1 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter2 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter3 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter11 = new Oracle.DataAccess.Client.OracleParameter();
this.label_ID = new System.Windows.Forms.Label();
this.tabControl1 = new System.Windows.Forms.TabControl();
this.tabPage1 = new System.Windows.Forms.TabPage();
this.dataGridView2 = new System.Windows.Forms.DataGridView();
this.tRAINIDDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.sTNAMEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.ST_NAME = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.sTARTTIMEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.START_TIME = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.DIRECTION = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dISPATCHBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.dataSet11 = new Train.DataSet1();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.btnDispatchCheck = new System.Windows.Forms.Button();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.rb_bu = new System.Windows.Forms.RadioButton();
this.rb_seo = new System.Windows.Forms.RadioButton();
this.label8 = new System.Windows.Forms.Label();
this.cb_end = new System.Windows.Forms.ComboBox();
this.button1 = new System.Windows.Forms.Button();
this.cb_hour = new System.Windows.Forms.ComboBox();
this.label1 = new System.Windows.Forms.Label();
this.label7 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.cb_start = new System.Windows.Forms.ComboBox();
this.label5 = new System.Windows.Forms.Label();
this.tabPage2 = new System.Windows.Forms.TabPage();
this.button4 = new System.Windows.Forms.Button();
this.TicketView = new System.Windows.Forms.DataGridView();
this.tIDDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.tRAINIDDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.rOOMNUMDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.sNUMDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.sTSTARTDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.sTENDDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.sTARTTIMEDataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.eNDTIMEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dIRECTIONDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.cOSTDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.tICKETBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.oracleConnection1 = new Oracle.DataAccess.Client.OracleConnection();
this.cmdSeatHelper = new Oracle.DataAccess.Client.OracleCommand();
this.cmdSeatCancel = new Oracle.DataAccess.Client.OracleCommand();
this.dISPATCHBindingSource1 = new System.Windows.Forms.BindingSource(this.components);
this.stationTableAdapter1 = new Train.DataSet1TableAdapters.STATIONTableAdapter();
this.sectionTableAdapter1 = new Train.DataSet1TableAdapters.SECTIONTableAdapter();
this.dISPATCHTableAdapter = new Train.DataSet1TableAdapters.DISPATCHTableAdapter();
this.seaT_STATUSTableAdapter1 = new Train.DataSet1TableAdapters.SEAT_STATUSTableAdapter();
this.SeatHelper = new Train.DataSet1TableAdapters.DISPATCHTableAdapter();
this.tICKETTableAdapter2 = new Train.DataSet1TableAdapters.TICKETTableAdapter();
this.pictureBox1 = new System.Windows.Forms.PictureBox();
this.tabControl1.SuspendLayout();
this.tabPage1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dISPATCHBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
this.groupBox1.SuspendLayout();
this.groupBox2.SuspendLayout();
this.tabPage2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.TicketView)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.tICKETBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dISPATCHBindingSource1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).BeginInit();
this.SuspendLayout();
//
// label_ID
//
this.label_ID.AutoSize = true;
this.label_ID.Font = new System.Drawing.Font("경기천년제목V Bold", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label_ID.Location = new System.Drawing.Point(12, 9);
this.label_ID.Name = "label_ID";
this.label_ID.Size = new System.Drawing.Size(74, 21);
this.label_ID.TabIndex = 0;
this.label_ID.Text = "label1";
//
// tabControl1
//
this.tabControl1.Controls.Add(this.tabPage1);
this.tabControl1.Controls.Add(this.tabPage2);
this.tabControl1.Location = new System.Drawing.Point(14, 79);
this.tabControl1.Name = "tabControl1";
this.tabControl1.SelectedIndex = 0;
this.tabControl1.Size = new System.Drawing.Size(907, 463);
this.tabControl1.TabIndex = 1;
//
// tabPage1
//
this.tabPage1.AutoScroll = true;
this.tabPage1.BackColor = System.Drawing.SystemColors.ActiveCaption;
this.tabPage1.Controls.Add(this.dataGridView2);
this.tabPage1.Controls.Add(this.groupBox1);
this.tabPage1.Location = new System.Drawing.Point(4, 22);
this.tabPage1.Name = "tabPage1";
this.tabPage1.Padding = new System.Windows.Forms.Padding(3);
this.tabPage1.Size = new System.Drawing.Size(899, 437);
this.tabPage1.TabIndex = 0;
this.tabPage1.Text = "승차권 예매";
//
// dataGridView2
//
this.dataGridView2.AllowUserToAddRows = false;
this.dataGridView2.AllowUserToDeleteRows = false;
this.dataGridView2.AutoGenerateColumns = false;
this.dataGridView2.BackgroundColor = System.Drawing.SystemColors.ActiveCaption;
this.dataGridView2.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView2.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.tRAINIDDataGridViewTextBoxColumn,
this.sTNAMEDataGridViewTextBoxColumn,
this.ST_NAME,
this.sTARTTIMEDataGridViewTextBoxColumn,
this.START_TIME,
this.DIRECTION
});
this.dataGridView2.DataSource = this.dISPATCHBindingSource;
this.dataGridView2.GridColor = System.Drawing.SystemColors.ActiveBorder;
this.dataGridView2.Location = new System.Drawing.Point(8, 137);
this.dataGridView2.Name = "dataGridView2";
this.dataGridView2.ReadOnly = true;
this.dataGridView2.RowTemplate.Height = 23;
this.dataGridView2.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.CellSelect;
this.dataGridView2.Size = new System.Drawing.Size(885, 294);
this.dataGridView2.TabIndex = 9;
this.dataGridView2.CellClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.SelectSeat);
//
// tRAINIDDataGridViewTextBoxColumn
//
this.tRAINIDDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.tRAINIDDataGridViewTextBoxColumn.DataPropertyName = "TRAIN_ID";
this.tRAINIDDataGridViewTextBoxColumn.HeaderText = "기차 번호";
this.tRAINIDDataGridViewTextBoxColumn.Name = "tRAINIDDataGridViewTextBoxColumn";
this.tRAINIDDataGridViewTextBoxColumn.ReadOnly = true;
//
// sTNAMEDataGridViewTextBoxColumn
//
this.sTNAMEDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.sTNAMEDataGridViewTextBoxColumn.DataPropertyName = "ST_NAME";
this.sTNAMEDataGridViewTextBoxColumn.HeaderText = "출발 역";
this.sTNAMEDataGridViewTextBoxColumn.Name = "sTNAMEDataGridViewTextBoxColumn";
this.sTNAMEDataGridViewTextBoxColumn.ReadOnly = true;
//
// ST_NAME
//
this.ST_NAME.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.ST_NAME.DataPropertyName = "EXPR1";
this.ST_NAME.HeaderText = "도착 역";
this.ST_NAME.Name = "ST_NAME";
this.ST_NAME.ReadOnly = true;
//
// sTARTTIMEDataGridViewTextBoxColumn
//
this.sTARTTIMEDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.sTARTTIMEDataGridViewTextBoxColumn.DataPropertyName = "START_TIME";
this.sTARTTIMEDataGridViewTextBoxColumn.HeaderText = "출발 시간";
this.sTARTTIMEDataGridViewTextBoxColumn.Name = "sTARTTIMEDataGridViewTextBoxColumn";
this.sTARTTIMEDataGridViewTextBoxColumn.ReadOnly = true;
//
// START_TIME
//
this.START_TIME.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.START_TIME.DataPropertyName = "DISPATCH";
this.START_TIME.HeaderText = "도착 시간";
this.START_TIME.Name = "START_TIME";
this.START_TIME.ReadOnly = true;
//
// DIRECTION
//
this.DIRECTION.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.DIRECTION.DataPropertyName = "DIRECTION";
this.DIRECTION.HeaderText = "방향";
this.DIRECTION.Name = "DIRECTION";
this.DIRECTION.ReadOnly = true;
//
// dISPATCHBindingSource
//
this.dISPATCHBindingSource.DataMember = "DISPATCH";
this.dISPATCHBindingSource.DataSource = this.dataSet11;
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// groupBox1
//
this.groupBox1.BackColor = System.Drawing.SystemColors.ActiveCaption;
this.groupBox1.Controls.Add(this.btnDispatchCheck);
this.groupBox1.Controls.Add(this.groupBox2);
this.groupBox1.Controls.Add(this.label8);
this.groupBox1.Controls.Add(this.cb_end);
this.groupBox1.Controls.Add(this.button1);
this.groupBox1.Controls.Add(this.cb_hour);
this.groupBox1.Controls.Add(this.label1);
this.groupBox1.Controls.Add(this.label7);
this.groupBox1.Controls.Add(this.label6);
this.groupBox1.Controls.Add(this.cb_start);
this.groupBox1.Controls.Add(this.label5);
this.groupBox1.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.groupBox1.Location = new System.Drawing.Point(8, 11);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(885, 120);
this.groupBox1.TabIndex = 8;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "SEARCH";
//
// btnDispatchCheck
//
this.btnDispatchCheck.BackColor = System.Drawing.SystemColors.GradientInactiveCaption;
this.btnDispatchCheck.Font = new System.Drawing.Font("경기천년제목V Bold", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.btnDispatchCheck.Location = new System.Drawing.Point(667, 49);
this.btnDispatchCheck.Name = "btnDispatchCheck";
this.btnDispatchCheck.Size = new System.Drawing.Size(212, 59);
this.btnDispatchCheck.TabIndex = 22;
this.btnDispatchCheck.Text = "열차 시간표 확인";
this.btnDispatchCheck.UseVisualStyleBackColor = false;
this.btnDispatchCheck.Click += new System.EventHandler(this.btnDispatchCheck_Click);
//
// groupBox2
//
this.groupBox2.Controls.Add(this.rb_bu);
this.groupBox2.Controls.Add(this.rb_seo);
this.groupBox2.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.groupBox2.Location = new System.Drawing.Point(6, 34);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(90, 77);
this.groupBox2.TabIndex = 21;
this.groupBox2.TabStop = false;
this.groupBox2.Text = "방향";
//
// rb_bu
//
this.rb_bu.AutoSize = true;
this.rb_bu.Checked = true;
this.rb_bu.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.rb_bu.Location = new System.Drawing.Point(6, 20);
this.rb_bu.Name = "rb_bu";
this.rb_bu.Size = new System.Drawing.Size(74, 20);
this.rb_bu.TabIndex = 19;
this.rb_bu.TabStop = true;
this.rb_bu.Text = "부산행";
this.rb_bu.UseVisualStyleBackColor = true;
this.rb_bu.Click += new System.EventHandler(this.DicrecClick);
//
// rb_seo
//
this.rb_seo.AutoSize = true;
this.rb_seo.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.rb_seo.Location = new System.Drawing.Point(6, 42);
this.rb_seo.Name = "rb_seo";
this.rb_seo.Size = new System.Drawing.Size(74, 20);
this.rb_seo.TabIndex = 20;
this.rb_seo.Text = "서울행";
this.rb_seo.UseVisualStyleBackColor = true;
this.rb_seo.Click += new System.EventHandler(this.DicrecClick);
//
// label8
//
this.label8.AutoSize = true;
this.label8.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label8.Location = new System.Drawing.Point(382, 83);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(24, 16);
this.label8.TabIndex = 17;
this.label8.Text = "시";
//
// cb_end
//
this.cb_end.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cb_end.Font = new System.Drawing.Font("굴림", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.cb_end.FormattingEnabled = true;
this.cb_end.Location = new System.Drawing.Point(276, 49);
this.cb_end.Name = "cb_end";
this.cb_end.Size = new System.Drawing.Size(124, 27);
this.cb_end.TabIndex = 18;
//
// button1
//
this.button1.BackColor = System.Drawing.SystemColors.GradientInactiveCaption;
this.button1.Font = new System.Drawing.Font("경기천년제목V Bold", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.button1.Location = new System.Drawing.Point(438, 48);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(212, 60);
this.button1.TabIndex = 5;
this.button1.Text = "열 차 조 회 하 기";
this.button1.UseVisualStyleBackColor = false;
this.button1.Click += new System.EventHandler(this.SearchTrainClick);
//
// cb_hour
//
this.cb_hour.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cb_hour.Font = new System.Drawing.Font("굴림", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.cb_hour.FormattingEnabled = true;
this.cb_hour.Location = new System.Drawing.Point(292, 81);
this.cb_hour.Name = "cb_hour";
this.cb_hour.Size = new System.Drawing.Size(87, 27);
this.cb_hour.TabIndex = 13;
//
// label1
//
this.label1.AutoSize = true;
this.label1.Font = new System.Drawing.Font("경기천년제목V Bold", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label1.Location = new System.Drawing.Point(111, 85);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(24, 16);
this.label1.TabIndex = 14;
this.label1.Text = "년";
//
// label7
//
this.label7.AutoSize = true;
this.label7.Font = new System.Drawing.Font("경기천년제목V Bold", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label7.Location = new System.Drawing.Point(141, 24);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(52, 21);
this.label7.TabIndex = 5;
this.label7.Text = "출발";
//
// label6
//
this.label6.AutoSize = true;
this.label6.Font = new System.Drawing.Font("경기천년제목V Bold", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label6.Location = new System.Drawing.Point(307, 25);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(52, 21);
this.label6.TabIndex = 6;
this.label6.Text = "도착";
//
// cb_start
//
this.cb_start.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cb_start.Font = new System.Drawing.Font("굴림", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.cb_start.FormattingEnabled = true;
this.cb_start.Location = new System.Drawing.Point(108, 48);
this.cb_start.Name = "cb_start";
this.cb_start.Size = new System.Drawing.Size(130, 27);
this.cb_start.TabIndex = 7;
this.cb_start.SelectedIndexChanged += new System.EventHandler(this.cb_start_SelectedIndexChanged);
//
// label5
//
this.label5.AutoSize = true;
this.label5.Font = new System.Drawing.Font("굴림", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.label5.Location = new System.Drawing.Point(243, 48);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(29, 19);
this.label5.TabIndex = 9;
this.label5.Text = "→";
//
// tabPage2
//
this.tabPage2.BackColor = System.Drawing.SystemColors.ActiveCaption;
this.tabPage2.Controls.Add(this.button4);
this.tabPage2.Controls.Add(this.TicketView);
this.tabPage2.Location = new System.Drawing.Point(4, 22);
this.tabPage2.Name = "tabPage2";
this.tabPage2.Padding = new System.Windows.Forms.Padding(3);
this.tabPage2.Size = new System.Drawing.Size(899, 437);
this.tabPage2.TabIndex = 1;
this.tabPage2.Text = "예약 조회";
//
// button4
//
this.button4.BackColor = System.Drawing.SystemColors.GradientInactiveCaption;
this.button4.Font = new System.Drawing.Font("경기천년제목V Bold", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.button4.Location = new System.Drawing.Point(741, 6);
this.button4.Name = "button4";
this.button4.Size = new System.Drawing.Size(152, 41);
this.button4.TabIndex = 4;
this.button4.Text = "새로고침";
this.button4.UseVisualStyleBackColor = false;
this.button4.Click += new System.EventHandler(this.button4_Click);
//
// TicketView
//
this.TicketView.AllowUserToAddRows = false;
this.TicketView.AutoGenerateColumns = false;
this.TicketView.BackgroundColor = System.Drawing.SystemColors.ActiveCaption;
this.TicketView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.TicketView.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.tIDDataGridViewTextBoxColumn,
this.tRAINIDDataGridViewTextBoxColumn1,
this.rOOMNUMDataGridViewTextBoxColumn,
this.sNUMDataGridViewTextBoxColumn,
this.sTSTARTDataGridViewTextBoxColumn,
this.sTENDDataGridViewTextBoxColumn,
this.sTARTTIMEDataGridViewTextBoxColumn1,
this.eNDTIMEDataGridViewTextBoxColumn,
this.dIRECTIONDataGridViewTextBoxColumn,
this.cOSTDataGridViewTextBoxColumn
});
this.TicketView.DataSource = this.tICKETBindingSource;
this.TicketView.GridColor = System.Drawing.SystemColors.ActiveBorder;
this.TicketView.Location = new System.Drawing.Point(6, 53);
this.TicketView.Name = "TicketView";
this.TicketView.ReadOnly = true;
this.TicketView.RowTemplate.Height = 23;
this.TicketView.Size = new System.Drawing.Size(887, 378);
this.TicketView.TabIndex = 0;
this.TicketView.CellClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.TicketView_CellClick);
//
// tIDDataGridViewTextBoxColumn
//
this.tIDDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.tIDDataGridViewTextBoxColumn.DataPropertyName = "T_ID";
this.tIDDataGridViewTextBoxColumn.HeaderText = "예약 번호";
this.tIDDataGridViewTextBoxColumn.Name = "tIDDataGridViewTextBoxColumn";
this.tIDDataGridViewTextBoxColumn.ReadOnly = true;
//
// tRAINIDDataGridViewTextBoxColumn1
//
this.tRAINIDDataGridViewTextBoxColumn1.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.tRAINIDDataGridViewTextBoxColumn1.DataPropertyName = "TRAIN_ID";
this.tRAINIDDataGridViewTextBoxColumn1.HeaderText = "열차 번호";
this.tRAINIDDataGridViewTextBoxColumn1.Name = "tRAINIDDataGridViewTextBoxColumn1";
this.tRAINIDDataGridViewTextBoxColumn1.ReadOnly = true;
//
// rOOMNUMDataGridViewTextBoxColumn
//
this.rOOMNUMDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.rOOMNUMDataGridViewTextBoxColumn.DataPropertyName = "ROOM_NUM";
this.rOOMNUMDataGridViewTextBoxColumn.HeaderText = "객차";
this.rOOMNUMDataGridViewTextBoxColumn.Name = "rOOMNUMDataGridViewTextBoxColumn";
this.rOOMNUMDataGridViewTextBoxColumn.ReadOnly = true;
//
// sNUMDataGridViewTextBoxColumn
//
this.sNUMDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.sNUMDataGridViewTextBoxColumn.DataPropertyName = "S_NUM";
this.sNUMDataGridViewTextBoxColumn.HeaderText = "좌석";
this.sNUMDataGridViewTextBoxColumn.Name = "sNUMDataGridViewTextBoxColumn";
this.sNUMDataGridViewTextBoxColumn.ReadOnly = true;
//
// sTSTARTDataGridViewTextBoxColumn
//
this.sTSTARTDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.sTSTARTDataGridViewTextBoxColumn.DataPropertyName = "ST_START";
this.sTSTARTDataGridViewTextBoxColumn.HeaderText = "출발 역";
this.sTSTARTDataGridViewTextBoxColumn.Name = "sTSTARTDataGridViewTextBoxColumn";
this.sTSTARTDataGridViewTextBoxColumn.ReadOnly = true;
//
// sTENDDataGridViewTextBoxColumn
//
this.sTENDDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.sTENDDataGridViewTextBoxColumn.DataPropertyName = "ST_END";
this.sTENDDataGridViewTextBoxColumn.HeaderText = "도착 역";
this.sTENDDataGridViewTextBoxColumn.Name = "sTENDDataGridViewTextBoxColumn";
this.sTENDDataGridViewTextBoxColumn.ReadOnly = true;
//
// sTARTTIMEDataGridViewTextBoxColumn1
//
this.sTARTTIMEDataGridViewTextBoxColumn1.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.sTARTTIMEDataGridViewTextBoxColumn1.DataPropertyName = "START_TIME";
this.sTARTTIMEDataGridViewTextBoxColumn1.HeaderText = "출발 시간";
this.sTARTTIMEDataGridViewTextBoxColumn1.Name = "sTARTTIMEDataGridViewTextBoxColumn1";
this.sTARTTIMEDataGridViewTextBoxColumn1.ReadOnly = true;
//
// eNDTIMEDataGridViewTextBoxColumn
//
this.eNDTIMEDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.eNDTIMEDataGridViewTextBoxColumn.DataPropertyName = "END_TIME";
this.eNDTIMEDataGridViewTextBoxColumn.HeaderText = "도착 시간";
this.eNDTIMEDataGridViewTextBoxColumn.Name = "eNDTIMEDataGridViewTextBoxColumn";
this.eNDTIMEDataGridViewTextBoxColumn.ReadOnly = true;
//
// dIRECTIONDataGridViewTextBoxColumn
//
this.dIRECTIONDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.dIRECTIONDataGridViewTextBoxColumn.DataPropertyName = "DIRECTION";
this.dIRECTIONDataGridViewTextBoxColumn.HeaderText = "방향";
this.dIRECTIONDataGridViewTextBoxColumn.Name = "dIRECTIONDataGridViewTextBoxColumn";
this.dIRECTIONDataGridViewTextBoxColumn.ReadOnly = true;
//
// cOSTDataGridViewTextBoxColumn
//
this.cOSTDataGridViewTextBoxColumn.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.cOSTDataGridViewTextBoxColumn.DataPropertyName = "COST";
this.cOSTDataGridViewTextBoxColumn.HeaderText = "요금";
this.cOSTDataGridViewTextBoxColumn.Name = "cOSTDataGridViewTextBoxColumn";
this.cOSTDataGridViewTextBoxColumn.ReadOnly = true;
//
// tICKETBindingSource
//
this.tICKETBindingSource.DataMember = "TICKET";
this.tICKETBindingSource.DataSource = this.dataSet11;
//
// oracleConnection1
//
this.oracleConnection1.ConnectionString = "DATA SOURCE=HONG;USER ID=A5293348;PASSWORD=A5293348";
//
// cmdSeatHelper
//
this.cmdSeatHelper.CommandText = resources.GetString("cmdSeatHelper.CommandText");
this.cmdSeatHelper.Connection = this.oracleConnection1;
oracleParameter8.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter8.ParameterName = "T_ID";
oracleParameter9.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter9.ParameterName = "DIREC";
oracleParameter10.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter10.ParameterName = "ST";
this.cmdSeatHelper.Parameters.Add(oracleParameter8);
this.cmdSeatHelper.Parameters.Add(oracleParameter9);
this.cmdSeatHelper.Parameters.Add(oracleParameter10);
this.cmdSeatHelper.Transaction = null;
//
// cmdSeatCancel
//
this.cmdSeatCancel.AddRowid = true;
this.cmdSeatCancel.CommandText = "UPDATE SEAT_STATUS SET STATUS = \'0\' WHERE TRAIN_ID = :T_ID AND ROOM_NUM = :R_NUM " +
"AND S_NUM = :S_NUM AND ST_NAME = :ST";
this.cmdSeatCancel.Connection = this.oracleConnection1;
oracleParameter1.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter1.ParameterName = "T_ID";
oracleParameter2.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int32;
oracleParameter2.ParameterName = "R_NUM";
oracleParameter3.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int32;
oracleParameter3.ParameterName = "S_NUM";
oracleParameter11.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter11.ParameterName = "ST";
this.cmdSeatCancel.Parameters.Add(oracleParameter1);
this.cmdSeatCancel.Parameters.Add(oracleParameter2);
this.cmdSeatCancel.Parameters.Add(oracleParameter3);
this.cmdSeatCancel.Parameters.Add(oracleParameter11);
this.cmdSeatCancel.Transaction = null;
//
// dISPATCHBindingSource1
//
this.dISPATCHBindingSource1.DataMember = "DISPATCH";
this.dISPATCHBindingSource1.DataSource = this.dataSet11;
//
// stationTableAdapter1
//
this.stationTableAdapter1.ClearBeforeFill = true;
//
// sectionTableAdapter1
//
this.sectionTableAdapter1.ClearBeforeFill = true;
//
// dISPATCHTableAdapter
//
this.dISPATCHTableAdapter.ClearBeforeFill = true;
//
// seaT_STATUSTableAdapter1
//
this.seaT_STATUSTableAdapter1.ClearBeforeFill = true;
//
// SeatHelper
//
this.SeatHelper.ClearBeforeFill = true;
//
// tICKETTableAdapter2
//
this.tICKETTableAdapter2.ClearBeforeFill = true;
//
// pictureBox1
//
this.pictureBox1.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox1.Image")));
this.pictureBox1.Location = new System.Drawing.Point(619, 9);
this.pictureBox1.Name = "pictureBox1";
this.pictureBox1.Size = new System.Drawing.Size(298, 86);
this.pictureBox1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.CenterImage;
this.pictureBox1.TabIndex = 2;
this.pictureBox1.TabStop = false;
//
// Main
//
this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.BackColor = System.Drawing.SystemColors.ActiveCaption;
this.ClientSize = new System.Drawing.Size(923, 554);
this.Controls.Add(this.pictureBox1);
this.Controls.Add(this.tabControl1);
this.Controls.Add(this.label_ID);
this.ForeColor = System.Drawing.SystemColors.ControlText;
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.Name = "Main";
this.Text = "칙-칙 폭-폭";
this.Load += new System.EventHandler(this.Main_Load);
this.tabControl1.ResumeLayout(false);
this.tabPage1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dISPATCHBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
this.groupBox1.ResumeLayout(false);
this.groupBox1.PerformLayout();
this.groupBox2.ResumeLayout(false);
this.groupBox2.PerformLayout();
this.tabPage2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.TicketView)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.tICKETBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dISPATCHBindingSource1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
public bool CaptureTIS(IList <TISDataModel> models)
{
try
{
using (var connection = new Oracle.DataAccess.Client.OracleConnection(DataContextConnectionString))
using (var command = new Oracle.DataAccess.Client.OracleCommand())
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
var tisObjects = models.Select(
model => new TISType
{
//ID = model.ID,
REFERENCE_NUMBER = model.ReferenceNumber,
VEHICLE_REGISTRATION_NUMBER = model.VehicleRegistrationNumber,
VEHICLE_MAKE_ID = model.VehicleMakeID,
VEHICLE_MAKE = model.VehicleMake,
VEHICLE_MODEL_ID = model.VehicleModelID,
VEHICLE_MODEL = model.VehicleModel,
VEHICLE_TYPE_ID = model.VehicleTypeID,
VEHICLE_TYPE = model.VehicleType,
VEHICLE_USAGE_ID = model.VehicleUsageID,
VEHICLE_COLOUR_ID = model.VehicleColourID,
YEAR_OF_MAKE = model.YearOfMake,
LICENSE_EXPIRE_DATE = model.LicenseExpireDate,
CLEARENCE_CERT_NO = model.ClearanceCertificateNumber,
OWNER_ID = model.OwnerID,
OWNER_ID_TYPE = model.OwnerIDType,
OWNER_NAME = model.OwnerName,
OWNER_INIT = model.OwnerInitials,
OWNER_SURNAME = model.Surname,
OWNER_GENDER = model.OwnerGender,
OWNER_POSTAL = model.OwnerPostal,
OWNER_POSTAL_STREET = model.OwnerPostalStreet,
OWNER_POSTAL_SUBURB = model.OwnerPostalSuburb,
OWNER_POSTAL_TOWN = model.OwnerPostalTown,
OWNER_POSTAL_CODE = model.PostalCode,
OWNER_PHYS = model.OwnerPhysical,
OWNER_PHYS_STREET = model.OwnerPhysicalStreet,
OWNER_PHYS_SUBURB = model.OwnerPhysicalSuburb,
OWNER_PHYS_TOWN = model.OwnerPhysicalTown,
OWNER_PHYS_CODE = model.PhysicalCode,
OWNER_TELEPHONE = model.OwnerTelephone,
OWNER_CELLPHONE = model.OwnerCellphone,
OWNER_COMPANY = model.OwnerCompany,
DATE_OF_OWNERSHIP = model.DateOfOwnership,
IMPORT_FILE_NAME = model.ImportFileName,
NATURE_OF_OWNERSHIP = model.NatureOfOwnership,
PROXY_INDICATOR = model.ProxyIndicator,
EMAIL_ADDRESS = model.EmailAddress,
})
.ToList();
var par = new Oracle.DataAccess.Client.OracleParameter("P_CREDENTIAL_ID", _credentialID);
par.Direction = ParameterDirection.Input;
par.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Int32;
command.Parameters.Add(par);
var param =
new Oracle.DataAccess.Client.OracleParameter("P_TABLE_NATIS_VEH_DETAIL_TYPE", Oracle.DataAccess.Client.OracleDbType.Array)
{
Value = tisObjects.ToArray(),
UdtTypeName = "ITS.TABLE_NATIS_VEH_DETAIL_TYPE"
};
command.Parameters.Add(param);
//par = new Oracle.DataAccess.Client.OracleParameter();
//par.ParameterName = "O_MESSAGE";
//par.Direction = ParameterDirection.Output;
//par.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
//par.Size = 4000;
//command.Parameters.Add(par);
command.BindByName = true;
try
{
ExcecuteNonQuery(command, "ITS.INFO_HANDLING.CAPTURE_NATIS", connection);
//if (!(command.Parameters["O_MESSAGE"].Value is DBNull))
//{
// var isSuccessful = command.Parameters["O_MESSAGE"].Value.ToString();
//}
}
catch (Exception ex)
{
_error = ex.Message;
ErrorCheckFriendly();
return(false);
}
finally
{
command.Dispose();
}
}
}
catch (Exception e)
{
_error = e.Message;
ErrorCheckFriendly();
return(false);
}
return(true);
}
/// <summary>
/// 디자이너 지원에 필요한 메서드입니다.
/// 이 메서드의 내용을 코드 편집기로 수정하지 마십시오.
/// </summary>
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Login));
Oracle.DataAccess.Client.OracleParameter oracleParameter1 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter2 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter3 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter4 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter5 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter6 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter7 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter8 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter9 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter10 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter11 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter12 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter13 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter14 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter15 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter16 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter17 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter18 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter19 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter20 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter21 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter22 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter23 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter24 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter25 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter26 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter27 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter28 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter29 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter30 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter31 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter32 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter33 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter34 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter35 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter36 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter37 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter38 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter39 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter40 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter41 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter42 = new Oracle.DataAccess.Client.OracleParameter();
this.labelId = new System.Windows.Forms.Label();
this.labelPw = new System.Windows.Forms.Label();
this.textBoxId = new System.Windows.Forms.TextBox();
this.textBoxPw = new System.Windows.Forms.TextBox();
this.buttonLogin = new System.Windows.Forms.Button();
this.oracleDataAdapter1 = new Oracle.DataAccess.Client.OracleDataAdapter();
this.deleteOracleCommand1 = new Oracle.DataAccess.Client.OracleCommand();
this.oracleConnection1 = new Oracle.DataAccess.Client.OracleConnection();
this.insertOracleCommand1 = new Oracle.DataAccess.Client.OracleCommand();
this.selectOracleCommand1 = new Oracle.DataAccess.Client.OracleCommand();
this.updateOracleCommand1 = new Oracle.DataAccess.Client.OracleCommand();
this.oracleDataAdapter2 = new Oracle.DataAccess.Client.OracleDataAdapter();
this.deleteOracleCommand2 = new Oracle.DataAccess.Client.OracleCommand();
this.oracleConnection2 = new Oracle.DataAccess.Client.OracleConnection();
this.insertOracleCommand2 = new Oracle.DataAccess.Client.OracleCommand();
this.selectOracleCommand2 = new Oracle.DataAccess.Client.OracleCommand();
this.updateOracleCommand2 = new Oracle.DataAccess.Client.OracleCommand();
this.dataSet11 = new DB_2.DataSet1();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
this.SuspendLayout();
//
// labelId
//
this.labelId.AutoSize = true;
this.labelId.Font = new System.Drawing.Font("휴먼편지체", 15.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.labelId.Location = new System.Drawing.Point(54, 68);
this.labelId.Name = "labelId";
this.labelId.Size = new System.Drawing.Size(28, 24);
this.labelId.TabIndex = 0;
this.labelId.Text = "ID";
//
// labelPw
//
this.labelPw.AutoSize = true;
this.labelPw.Font = new System.Drawing.Font("휴먼편지체", 15.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.labelPw.Location = new System.Drawing.Point(53, 104);
this.labelPw.Name = "labelPw";
this.labelPw.Size = new System.Drawing.Size(36, 24);
this.labelPw.TabIndex = 1;
this.labelPw.Text = "PW";
//
// textBoxId
//
this.textBoxId.Font = new System.Drawing.Font("굴림", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.textBoxId.Location = new System.Drawing.Point(107, 66);
this.textBoxId.Name = "textBoxId";
this.textBoxId.Size = new System.Drawing.Size(142, 26);
this.textBoxId.TabIndex = 2;
//
// textBoxPw
//
this.textBoxPw.Font = new System.Drawing.Font("굴림", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.textBoxPw.Location = new System.Drawing.Point(107, 102);
this.textBoxPw.Name = "textBoxPw";
this.textBoxPw.PasswordChar = '●';
this.textBoxPw.Size = new System.Drawing.Size(142, 26);
this.textBoxPw.TabIndex = 3;
this.textBoxPw.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.textBoxPw_KeyPress);
//
// buttonLogin
//
this.buttonLogin.Font = new System.Drawing.Font("휴먼편지체", 15.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.buttonLogin.Location = new System.Drawing.Point(264, 66);
this.buttonLogin.Name = "buttonLogin";
this.buttonLogin.Size = new System.Drawing.Size(66, 62);
this.buttonLogin.TabIndex = 4;
this.buttonLogin.Text = "Login";
this.buttonLogin.UseVisualStyleBackColor = true;
this.buttonLogin.Click += new System.EventHandler(this.buttonLogin_Click);
//
// oracleDataAdapter1
//
this.oracleDataAdapter1.DeleteCommand = this.deleteOracleCommand1;
this.oracleDataAdapter1.InsertCommand = this.insertOracleCommand1;
this.oracleDataAdapter1.SelectCommand = this.selectOracleCommand1;
this.oracleDataAdapter1.UpdateCommand = this.updateOracleCommand1;
//
// deleteOracleCommand1
//
this.deleteOracleCommand1.CommandText = resources.GetString("deleteOracleCommand1.CommandText");
this.deleteOracleCommand1.Connection = this.oracleConnection1;
oracleParameter1.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Decimal;
oracleParameter1.ParameterName = ":ori_STD_NUM_p0";
oracleParameter1.SourceColumn = "STD_NUM";
oracleParameter1.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter2.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter2.ParameterName = ":ori_STD_PAS_p1";
oracleParameter2.SourceColumn = "STD_PASSWORD";
oracleParameter2.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter3.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter3.ParameterName = ":ori_STD_PAS_p2";
oracleParameter3.SourceColumn = "STD_PASSWORD";
oracleParameter3.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter4.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter4.ParameterName = ":ori_STD_NAM_p3";
oracleParameter4.SourceColumn = "STD_NAME";
oracleParameter4.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter5.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter5.ParameterName = ":ori_STD_DEP_p4";
oracleParameter5.SourceColumn = "STD_DEPT_NAME";
oracleParameter5.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter6.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter6.ParameterName = ":ori_STD_DEP_p5";
oracleParameter6.SourceColumn = "STD_DEPT_NAME";
oracleParameter6.SourceVersion = System.Data.DataRowVersion.Original;
this.deleteOracleCommand1.Parameters.Add(oracleParameter1);
this.deleteOracleCommand1.Parameters.Add(oracleParameter2);
this.deleteOracleCommand1.Parameters.Add(oracleParameter3);
this.deleteOracleCommand1.Parameters.Add(oracleParameter4);
this.deleteOracleCommand1.Parameters.Add(oracleParameter5);
this.deleteOracleCommand1.Parameters.Add(oracleParameter6);
this.deleteOracleCommand1.Transaction = null;
//
// oracleConnection1
//
this.oracleConnection1.ConnectionString = "USER ID=S5049986;DATA SOURCE=ORAORA;PASSWORD=s5049986;PERSIST SECURITY INFO=true;" +
"";
//
// insertOracleCommand1
//
this.insertOracleCommand1.CommandText = "INSERT INTO \"PRO1_STUDENTS\"( \"STD_NUM\", \"STD_PASSWORD\", \"STD_NAME\", \"STD_DEPT_NAM" +
"E\") VALUES ( :cur_STD_NUM_p0, :cur_STD_PAS_p1, :cur_STD_NAM_p2, :cur_STD_DEP_p3)" +
"";
this.insertOracleCommand1.Connection = this.oracleConnection1;
oracleParameter7.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Decimal;
oracleParameter7.ParameterName = ":cur_STD_NUM_p0";
oracleParameter7.SourceColumn = "STD_NUM";
oracleParameter8.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter8.ParameterName = ":cur_STD_PAS_p1";
oracleParameter8.SourceColumn = "STD_PASSWORD";
oracleParameter9.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter9.ParameterName = ":cur_STD_NAM_p2";
oracleParameter9.SourceColumn = "STD_NAME";
oracleParameter10.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter10.ParameterName = ":cur_STD_DEP_p3";
oracleParameter10.SourceColumn = "STD_DEPT_NAME";
this.insertOracleCommand1.Parameters.Add(oracleParameter7);
this.insertOracleCommand1.Parameters.Add(oracleParameter8);
this.insertOracleCommand1.Parameters.Add(oracleParameter9);
this.insertOracleCommand1.Parameters.Add(oracleParameter10);
this.insertOracleCommand1.Transaction = null;
//
// selectOracleCommand1
//
this.selectOracleCommand1.CommandText = "SELECT STD_NUM, STD_PASSWORD, STD_NAME\n\n, STD_DEPT_NAME FROM PRO1_STUDENTS";
this.selectOracleCommand1.Connection = this.oracleConnection1;
this.selectOracleCommand1.Transaction = null;
//
// updateOracleCommand1
//
this.updateOracleCommand1.CommandText = resources.GetString("updateOracleCommand1.CommandText");
this.updateOracleCommand1.Connection = this.oracleConnection1;
oracleParameter11.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Decimal;
oracleParameter11.ParameterName = ":cur_STD_NUM_p0";
oracleParameter11.SourceColumn = "STD_NUM";
oracleParameter12.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter12.ParameterName = ":cur_STD_PAS_p1";
oracleParameter12.SourceColumn = "STD_PASSWORD";
oracleParameter13.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter13.ParameterName = ":cur_STD_NAM_p2";
oracleParameter13.SourceColumn = "STD_NAME";
oracleParameter14.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter14.ParameterName = ":cur_STD_DEP_p3";
oracleParameter14.SourceColumn = "STD_DEPT_NAME";
oracleParameter15.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Decimal;
oracleParameter15.ParameterName = ":ori_STD_NUM_p4";
oracleParameter15.SourceColumn = "STD_NUM";
oracleParameter15.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter16.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter16.ParameterName = ":ori_STD_PAS_p5";
oracleParameter16.SourceColumn = "STD_PASSWORD";
oracleParameter16.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter17.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter17.ParameterName = ":ori_STD_PAS_p6";
oracleParameter17.SourceColumn = "STD_PASSWORD";
oracleParameter17.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter18.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter18.ParameterName = ":ori_STD_NAM_p7";
oracleParameter18.SourceColumn = "STD_NAME";
oracleParameter18.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter19.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter19.ParameterName = ":ori_STD_DEP_p8";
oracleParameter19.SourceColumn = "STD_DEPT_NAME";
oracleParameter19.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter20.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter20.ParameterName = ":ori_STD_DEP_p9";
oracleParameter20.SourceColumn = "STD_DEPT_NAME";
oracleParameter20.SourceVersion = System.Data.DataRowVersion.Original;
this.updateOracleCommand1.Parameters.Add(oracleParameter11);
this.updateOracleCommand1.Parameters.Add(oracleParameter12);
this.updateOracleCommand1.Parameters.Add(oracleParameter13);
this.updateOracleCommand1.Parameters.Add(oracleParameter14);
this.updateOracleCommand1.Parameters.Add(oracleParameter15);
this.updateOracleCommand1.Parameters.Add(oracleParameter16);
this.updateOracleCommand1.Parameters.Add(oracleParameter17);
this.updateOracleCommand1.Parameters.Add(oracleParameter18);
this.updateOracleCommand1.Parameters.Add(oracleParameter19);
this.updateOracleCommand1.Parameters.Add(oracleParameter20);
this.updateOracleCommand1.Transaction = null;
//
// oracleDataAdapter2
//
this.oracleDataAdapter2.DeleteCommand = this.deleteOracleCommand2;
this.oracleDataAdapter2.InsertCommand = this.insertOracleCommand2;
this.oracleDataAdapter2.SelectCommand = this.selectOracleCommand2;
this.oracleDataAdapter2.UpdateCommand = this.updateOracleCommand2;
//
// deleteOracleCommand2
//
this.deleteOracleCommand2.CommandText = resources.GetString("deleteOracleCommand2.CommandText");
this.deleteOracleCommand2.Connection = this.oracleConnection2;
oracleParameter21.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Decimal;
oracleParameter21.ParameterName = ":ori_PRF_NUM_p0";
oracleParameter21.SourceColumn = "PRF_NUM";
oracleParameter21.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter22.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter22.ParameterName = ":ori_PRF_PAS_p1";
oracleParameter22.SourceColumn = "PRF_PASSWORD";
oracleParameter22.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter23.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter23.ParameterName = ":ori_PRF_PAS_p2";
oracleParameter23.SourceColumn = "PRF_PASSWORD";
oracleParameter23.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter24.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter24.ParameterName = ":ori_PRF_NAM_p3";
oracleParameter24.SourceColumn = "PRF_NAME";
oracleParameter24.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter25.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter25.ParameterName = ":ori_PRF_NAM_p4";
oracleParameter25.SourceColumn = "PRF_NAME";
oracleParameter25.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter26.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter26.ParameterName = ":ori_PRF_DEP_p5";
oracleParameter26.SourceColumn = "PRF_DEPT_NAME";
oracleParameter26.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter27.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter27.ParameterName = ":ori_PRF_DEP_p6";
oracleParameter27.SourceColumn = "PRF_DEPT_NAME";
oracleParameter27.SourceVersion = System.Data.DataRowVersion.Original;
this.deleteOracleCommand2.Parameters.Add(oracleParameter21);
this.deleteOracleCommand2.Parameters.Add(oracleParameter22);
this.deleteOracleCommand2.Parameters.Add(oracleParameter23);
this.deleteOracleCommand2.Parameters.Add(oracleParameter24);
this.deleteOracleCommand2.Parameters.Add(oracleParameter25);
this.deleteOracleCommand2.Parameters.Add(oracleParameter26);
this.deleteOracleCommand2.Parameters.Add(oracleParameter27);
this.deleteOracleCommand2.Transaction = null;
//
// oracleConnection2
//
this.oracleConnection2.ConnectionString = "USER ID=S5049986;DATA SOURCE=ORAORA;PASSWORD=s5049986;PERSIST SECURITY INFO=true;" +
"";
//
// insertOracleCommand2
//
this.insertOracleCommand2.CommandText = "INSERT INTO \"PRO1_PROFESSORS\"( \"PRF_NUM\", \"PRF_PASSWORD\", \"PRF_NAME\", \"PRF_DEPT_N" +
"AME\") VALUES ( :cur_PRF_NUM_p0, :cur_PRF_PAS_p1, :cur_PRF_NAM_p2, :cur_PRF_DEP_p" +
"3)";
this.insertOracleCommand2.Connection = this.oracleConnection2;
oracleParameter28.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Decimal;
oracleParameter28.ParameterName = ":cur_PRF_NUM_p0";
oracleParameter28.SourceColumn = "PRF_NUM";
oracleParameter29.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter29.ParameterName = ":cur_PRF_PAS_p1";
oracleParameter29.SourceColumn = "PRF_PASSWORD";
oracleParameter30.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter30.ParameterName = ":cur_PRF_NAM_p2";
oracleParameter30.SourceColumn = "PRF_NAME";
oracleParameter31.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter31.ParameterName = ":cur_PRF_DEP_p3";
oracleParameter31.SourceColumn = "PRF_DEPT_NAME";
this.insertOracleCommand2.Parameters.Add(oracleParameter28);
this.insertOracleCommand2.Parameters.Add(oracleParameter29);
this.insertOracleCommand2.Parameters.Add(oracleParameter30);
this.insertOracleCommand2.Parameters.Add(oracleParameter31);
this.insertOracleCommand2.Transaction = null;
//
// selectOracleCommand2
//
this.selectOracleCommand2.CommandText = "SELECT PRF_NUM\n, PRF_PASSWORD, PRF_NAME\n\n, PRF_DEPT_NAME FROM PRO1_PROFESSORS";
this.selectOracleCommand2.Connection = this.oracleConnection2;
this.selectOracleCommand2.Transaction = null;
//
// updateOracleCommand2
//
this.updateOracleCommand2.CommandText = resources.GetString("updateOracleCommand2.CommandText");
this.updateOracleCommand2.Connection = this.oracleConnection2;
oracleParameter32.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Decimal;
oracleParameter32.ParameterName = ":cur_PRF_NUM_p0";
oracleParameter32.SourceColumn = "PRF_NUM";
oracleParameter33.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter33.ParameterName = ":cur_PRF_PAS_p1";
oracleParameter33.SourceColumn = "PRF_PASSWORD";
oracleParameter34.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter34.ParameterName = ":cur_PRF_NAM_p2";
oracleParameter34.SourceColumn = "PRF_NAME";
oracleParameter35.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter35.ParameterName = ":cur_PRF_DEP_p3";
oracleParameter35.SourceColumn = "PRF_DEPT_NAME";
oracleParameter36.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Decimal;
oracleParameter36.ParameterName = ":ori_PRF_NUM_p4";
oracleParameter36.SourceColumn = "PRF_NUM";
oracleParameter36.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter37.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter37.ParameterName = ":ori_PRF_PAS_p5";
oracleParameter37.SourceColumn = "PRF_PASSWORD";
oracleParameter37.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter38.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter38.ParameterName = ":ori_PRF_PAS_p6";
oracleParameter38.SourceColumn = "PRF_PASSWORD";
oracleParameter38.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter39.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter39.ParameterName = ":ori_PRF_NAM_p7";
oracleParameter39.SourceColumn = "PRF_NAME";
oracleParameter39.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter40.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter40.ParameterName = ":ori_PRF_NAM_p8";
oracleParameter40.SourceColumn = "PRF_NAME";
oracleParameter40.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter41.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter41.ParameterName = ":ori_PRF_DEP_p9";
oracleParameter41.SourceColumn = "PRF_DEPT_NAME";
oracleParameter41.SourceVersion = System.Data.DataRowVersion.Original;
oracleParameter42.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter42.ParameterName = ":ori_PRF_DEP_p10";
oracleParameter42.SourceColumn = "PRF_DEPT_NAME";
oracleParameter42.SourceVersion = System.Data.DataRowVersion.Original;
this.updateOracleCommand2.Parameters.Add(oracleParameter32);
this.updateOracleCommand2.Parameters.Add(oracleParameter33);
this.updateOracleCommand2.Parameters.Add(oracleParameter34);
this.updateOracleCommand2.Parameters.Add(oracleParameter35);
this.updateOracleCommand2.Parameters.Add(oracleParameter36);
this.updateOracleCommand2.Parameters.Add(oracleParameter37);
this.updateOracleCommand2.Parameters.Add(oracleParameter38);
this.updateOracleCommand2.Parameters.Add(oracleParameter39);
this.updateOracleCommand2.Parameters.Add(oracleParameter40);
this.updateOracleCommand2.Parameters.Add(oracleParameter41);
this.updateOracleCommand2.Parameters.Add(oracleParameter42);
this.updateOracleCommand2.Transaction = null;
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// Login
//
this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.Controls.Add(this.buttonLogin);
this.Controls.Add(this.textBoxPw);
this.Controls.Add(this.textBoxId);
this.Controls.Add(this.labelPw);
this.Controls.Add(this.labelId);
this.Location = new System.Drawing.Point(50, 50);
this.MaximumSize = new System.Drawing.Size(400, 200);
this.MinimumSize = new System.Drawing.Size(400, 200);
this.Name = "Login";
this.Size = new System.Drawing.Size(400, 200);
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// 디자이너 지원에 필요한 메서드입니다.
/// 이 메서드의 내용을 코드 편집기로 수정하지 마세요.
/// </summary>
private void InitializeComponent()
{
Oracle.DataAccess.Client.OracleParameter oracleParameter2 = new Oracle.DataAccess.Client.OracleParameter();
this.oracleCommand1 = new Oracle.DataAccess.Client.OracleCommand();
this.oracleConnection1 = new Oracle.DataAccess.Client.OracleConnection();
this.listBox1 = new System.Windows.Forms.ListBox();
this.button1 = new System.Windows.Forms.Button();
this.button2 = new System.Windows.Forms.Button();
this.oracleCommand2 = new Oracle.DataAccess.Client.OracleCommand();
this.serch = new System.Windows.Forms.Button();
this.textBox1 = new System.Windows.Forms.TextBox();
this.oracleCommand3 = new Oracle.DataAccess.Client.OracleCommand();
this.SuspendLayout();
//
// oracleCommand1
//
this.oracleCommand1.CommandText = "SELECT * FROM EMP";
this.oracleCommand1.Connection = this.oracleConnection1;
this.oracleCommand1.Transaction = null;
//
// oracleConnection1
//
this.oracleConnection1.ConnectionString = "Data Source=ORARA;User ID=A5293638;Password=san9yun2;";
//
// listBox1
//
this.listBox1.FormattingEnabled = true;
this.listBox1.ItemHeight = 12;
this.listBox1.Location = new System.Drawing.Point(21, 44);
this.listBox1.Name = "listBox1";
this.listBox1.Size = new System.Drawing.Size(167, 196);
this.listBox1.TabIndex = 0;
//
// button1
//
this.button1.Location = new System.Drawing.Point(197, 44);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(75, 23);
this.button1.TabIndex = 1;
this.button1.Text = "연결";
this.button1.UseVisualStyleBackColor = true;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// button2
//
this.button2.Location = new System.Drawing.Point(197, 73);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(75, 23);
this.button2.TabIndex = 2;
this.button2.Text = "불러오기";
this.button2.UseVisualStyleBackColor = true;
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// oracleCommand2
//
this.oracleCommand2.CommandText = "SELECT * FROM EMP";
this.oracleCommand2.Connection = this.oracleConnection1;
this.oracleCommand2.Transaction = null;
//
// serch
//
this.serch.Location = new System.Drawing.Point(197, 102);
this.serch.Name = "serch";
this.serch.Size = new System.Drawing.Size(75, 23);
this.serch.TabIndex = 3;
this.serch.Text = "검색";
this.serch.UseVisualStyleBackColor = true;
this.serch.Click += new System.EventHandler(this.serch_Click);
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(287, 102);
this.textBox1.Name = "textBox1";
this.textBox1.Size = new System.Drawing.Size(100, 21);
this.textBox1.TabIndex = 4;
//
// oracleCommand3
//
this.oracleCommand3.CommandText = "SELECT * FROM EMP";
this.oracleCommand3.Connection = this.oracleConnection1;
oracleParameter2.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter2.ParameterName = "pa";
this.oracleCommand3.Parameters.Add(oracleParameter2);
this.oracleCommand3.Transaction = null;
//
// Form1
//
this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(422, 261);
this.Controls.Add(this.textBox1);
this.Controls.Add(this.serch);
this.Controls.Add(this.button2);
this.Controls.Add(this.button1);
this.Controls.Add(this.listBox1);
this.Name = "Form1";
this.Text = "Form1";
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(FormSignUpAnother));
Oracle.DataAccess.Client.OracleParameter oracleParameter1 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter2 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter3 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter4 = new Oracle.DataAccess.Client.OracleParameter();
this.labelFindID = new System.Windows.Forms.Label();
this.pictureBox1 = new System.Windows.Forms.PictureBox();
this.buttonConfirm = new System.Windows.Forms.Button();
this.buttonDoubleCheck = new System.Windows.Forms.Button();
this.textBoxEmail = new System.Windows.Forms.TextBox();
this.oracleCommand1 = new Oracle.DataAccess.Client.OracleCommand();
this.oracleConnection1 = new Oracle.DataAccess.Client.OracleConnection();
this.textBoxName = new System.Windows.Forms.TextBox();
this.textBoxPasswd = new System.Windows.Forms.TextBox();
this.labelEmail = new System.Windows.Forms.Label();
this.labelName = new System.Windows.Forms.Label();
this.textBoxID = new System.Windows.Forms.TextBox();
this.labelPasswd = new System.Windows.Forms.Label();
this.labelID = new System.Windows.Forms.Label();
this.dataSet11 = new EVERYTHIN_5293993.DataSet1();
this.administerTableAdapter1 = new EVERYTHIN_5293993.DataSet1TableAdapters.ADMINISTERTableAdapter();
this.employeeTableAdapter1 = new EVERYTHIN_5293993.DataSet1TableAdapters.EMPLOYEETableAdapter();
((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
this.SuspendLayout();
//
// labelFindID
//
this.labelFindID.AutoSize = true;
this.labelFindID.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(119)))), ((int)(((byte)(134)))), ((int)(((byte)(153)))));
this.labelFindID.Font = new System.Drawing.Font("나눔스퀘어", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.labelFindID.ForeColor = System.Drawing.Color.White;
this.labelFindID.Location = new System.Drawing.Point(12, 15);
this.labelFindID.Name = "labelFindID";
this.labelFindID.Size = new System.Drawing.Size(141, 26);
this.labelFindID.TabIndex = 60;
this.labelFindID.Text = "회원 가입>>";
//
// pictureBox1
//
this.pictureBox1.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox1.Image")));
this.pictureBox1.Location = new System.Drawing.Point(-2, 0);
this.pictureBox1.Name = "pictureBox1";
this.pictureBox1.Size = new System.Drawing.Size(467, 50);
this.pictureBox1.TabIndex = 59;
this.pictureBox1.TabStop = false;
//
// buttonConfirm
//
this.buttonConfirm.BackColor = System.Drawing.Color.LightSlateGray;
this.buttonConfirm.Font = new System.Drawing.Font("나눔스퀘어", 15.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.buttonConfirm.ForeColor = System.Drawing.Color.White;
this.buttonConfirm.Location = new System.Drawing.Point(175, 294);
this.buttonConfirm.Name = "buttonConfirm";
this.buttonConfirm.Size = new System.Drawing.Size(119, 51);
this.buttonConfirm.TabIndex = 54;
this.buttonConfirm.Tag = "6";
this.buttonConfirm.Text = "확인";
this.buttonConfirm.UseVisualStyleBackColor = false;
this.buttonConfirm.UseWaitCursor = true;
this.buttonConfirm.Click += new System.EventHandler(this.buttonConfirmClicked);
//
// buttonDoubleCheck
//
this.buttonDoubleCheck.BackColor = System.Drawing.Color.LightSlateGray;
this.buttonDoubleCheck.Font = new System.Drawing.Font("나눔스퀘어", 15.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.buttonDoubleCheck.ForeColor = System.Drawing.Color.White;
this.buttonDoubleCheck.Location = new System.Drawing.Point(320, 73);
this.buttonDoubleCheck.Name = "buttonDoubleCheck";
this.buttonDoubleCheck.Size = new System.Drawing.Size(106, 37);
this.buttonDoubleCheck.TabIndex = 50;
this.buttonDoubleCheck.Tag = "2";
this.buttonDoubleCheck.Text = "중복 확인";
this.buttonDoubleCheck.UseVisualStyleBackColor = false;
this.buttonDoubleCheck.Click += new System.EventHandler(this.buttonDoubleCheckClicked);
//
// textBoxEmail
//
this.textBoxEmail.Font = new System.Drawing.Font("나눔스퀘어", 15.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.textBoxEmail.Location = new System.Drawing.Point(111, 233);
this.textBoxEmail.Name = "textBoxEmail";
this.textBoxEmail.Size = new System.Drawing.Size(203, 31);
this.textBoxEmail.TabIndex = 53;
this.textBoxEmail.Tag = "5";
this.textBoxEmail.KeyDown += new System.Windows.Forms.KeyEventHandler(this.textBoxEmail_KeyDown);
//
// oracleCommand1
//
this.oracleCommand1.Connection = this.oracleConnection1;
oracleParameter1.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter1.ParameterName = "id";
oracleParameter2.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter2.ParameterName = "password";
oracleParameter3.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter3.ParameterName = "name";
oracleParameter4.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter4.ParameterName = "email";
this.oracleCommand1.Parameters.Add(oracleParameter1);
this.oracleCommand1.Parameters.Add(oracleParameter2);
this.oracleCommand1.Parameters.Add(oracleParameter3);
this.oracleCommand1.Parameters.Add(oracleParameter4);
this.oracleCommand1.Transaction = null;
//
// oracleConnection1
//
this.oracleConnection1.ConnectionString = "DATA SOURCE=ORAORA;USER ID=B5293993;PASSWORD=B5293993;";
//
// textBoxName
//
this.textBoxName.Font = new System.Drawing.Font("나눔스퀘어", 15.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.textBoxName.Location = new System.Drawing.Point(111, 177);
this.textBoxName.Name = "textBoxName";
this.textBoxName.Size = new System.Drawing.Size(203, 31);
this.textBoxName.TabIndex = 52;
this.textBoxName.Tag = "4";
//
// textBoxPasswd
//
this.textBoxPasswd.Font = new System.Drawing.Font("나눔스퀘어", 15.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.textBoxPasswd.Location = new System.Drawing.Point(111, 126);
this.textBoxPasswd.Name = "textBoxPasswd";
this.textBoxPasswd.Size = new System.Drawing.Size(203, 31);
this.textBoxPasswd.TabIndex = 51;
this.textBoxPasswd.Tag = "3";
//
// labelEmail
//
this.labelEmail.AutoSize = true;
this.labelEmail.Font = new System.Drawing.Font("나눔스퀘어", 15.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.labelEmail.ForeColor = System.Drawing.Color.White;
this.labelEmail.Location = new System.Drawing.Point(16, 236);
this.labelEmail.Name = "labelEmail";
this.labelEmail.Size = new System.Drawing.Size(88, 23);
this.labelEmail.TabIndex = 56;
this.labelEmail.Text = "이 메 일 :";
//
// labelName
//
this.labelName.AutoSize = true;
this.labelName.Font = new System.Drawing.Font("나눔스퀘어", 15.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.labelName.ForeColor = System.Drawing.Color.White;
this.labelName.Location = new System.Drawing.Point(16, 180);
this.labelName.Name = "labelName";
this.labelName.Size = new System.Drawing.Size(89, 23);
this.labelName.TabIndex = 57;
this.labelName.Text = "이 름 :";
//
// textBoxID
//
this.textBoxID.Font = new System.Drawing.Font("나눔스퀘어", 15.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.textBoxID.Location = new System.Drawing.Point(111, 77);
this.textBoxID.Name = "textBoxID";
this.textBoxID.Size = new System.Drawing.Size(203, 31);
this.textBoxID.TabIndex = 49;
this.textBoxID.Tag = "1";
//
// labelPasswd
//
this.labelPasswd.AutoSize = true;
this.labelPasswd.Font = new System.Drawing.Font("나눔스퀘어", 15.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.labelPasswd.ForeColor = System.Drawing.Color.White;
this.labelPasswd.Location = new System.Drawing.Point(15, 129);
this.labelPasswd.Name = "labelPasswd";
this.labelPasswd.Size = new System.Drawing.Size(97, 23);
this.labelPasswd.TabIndex = 58;
this.labelPasswd.Text = "비밀번호 :";
//
// labelID
//
this.labelID.AutoSize = true;
this.labelID.Font = new System.Drawing.Font("나눔스퀘어", 15.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(129)));
this.labelID.ForeColor = System.Drawing.Color.White;
this.labelID.Location = new System.Drawing.Point(16, 80);
this.labelID.Name = "labelID";
this.labelID.Size = new System.Drawing.Size(88, 23);
this.labelID.TabIndex = 55;
this.labelID.Text = "아 이 디 :";
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// administerTableAdapter1
//
this.administerTableAdapter1.ClearBeforeFill = true;
//
// employeeTableAdapter1
//
this.employeeTableAdapter1.ClearBeforeFill = true;
//
// FormSignUpAnother
//
this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(83)))), ((int)(((byte)(95)))), ((int)(((byte)(111)))));
this.ClientSize = new System.Drawing.Size(440, 362);
this.Controls.Add(this.labelFindID);
this.Controls.Add(this.pictureBox1);
this.Controls.Add(this.buttonConfirm);
this.Controls.Add(this.buttonDoubleCheck);
this.Controls.Add(this.textBoxEmail);
this.Controls.Add(this.textBoxName);
this.Controls.Add(this.textBoxPasswd);
this.Controls.Add(this.labelEmail);
this.Controls.Add(this.labelName);
this.Controls.Add(this.textBoxID);
this.Controls.Add(this.labelPasswd);
this.Controls.Add(this.labelID);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
this.Name = "FormSignUpAnother";
this.Text = "EVERYTHIN\'";
this.Load += new System.EventHandler(this.FormSignUpAnother_Load);
((System.ComponentModel.ISupportInitialize)(this.pictureBox1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
Oracle.DataAccess.Client.OracleParameter oracleParameter8 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter9 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter10 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter11 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter12 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter13 = new Oracle.DataAccess.Client.OracleParameter();
Oracle.DataAccess.Client.OracleParameter oracleParameter14 = new Oracle.DataAccess.Client.OracleParameter();
this.label1 = new System.Windows.Forms.Label();
this.dataGridView1 = new System.Windows.Forms.DataGridView();
this.pRODUCTBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.dataSet12 = new final_project.DataSet1();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.tbx_pID = new System.Windows.Forms.TextBox();
this.label4 = new System.Windows.Forms.Label();
this.btn_review = new System.Windows.Forms.Button();
this.label5 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.tbx_title = new System.Windows.Forms.TextBox();
this.tbx_contents = new System.Windows.Forms.TextBox();
this.lbx_review = new System.Windows.Forms.ListBox();
this.tabControl1 = new System.Windows.Forms.TabControl();
this.tabPage3 = new System.Windows.Forms.TabPage();
this.tbx_rental_pID = new System.Windows.Forms.TextBox();
this.label14 = new System.Windows.Forms.Label();
this.btn_rent = new System.Windows.Forms.Button();
this.btn_search = new System.Windows.Forms.Button();
this.tbx_size = new System.Windows.Forms.TextBox();
this.cbx_type = new System.Windows.Forms.ComboBox();
this.label15 = new System.Windows.Forms.Label();
this.cbx_color = new System.Windows.Forms.ComboBox();
this.label12 = new System.Windows.Forms.Label();
this.label11 = new System.Windows.Forms.Label();
this.label10 = new System.Windows.Forms.Label();
this.cbx_fee = new System.Windows.Forms.ComboBox();
this.tabPage1 = new System.Windows.Forms.TabPage();
this.tabPage2 = new System.Windows.Forms.TabPage();
this.label9 = new System.Windows.Forms.Label();
this.lbx_pID = new System.Windows.Forms.ListBox();
this.btn_save = new System.Windows.Forms.Button();
this.tbx_contents2 = new System.Windows.Forms.TextBox();
this.tbx_title2 = new System.Windows.Forms.TextBox();
this.label7 = new System.Windows.Forms.Label();
this.label8 = new System.Windows.Forms.Label();
this.oracleConnection1 = new Oracle.DataAccess.Client.OracleConnection();
this.oracleCommand1 = new Oracle.DataAccess.Client.OracleCommand();
this.oracleCommand2 = new Oracle.DataAccess.Client.OracleCommand();
this.dataSet1 = new final_project.DataSet1();
this.dataSet11 = new final_project.DataSet1();
this.customerTableAdapter1 = new final_project.DataSet1TableAdapters.CUSTOMERTableAdapter();
this.rentaL_STATUSTableAdapter1 = new final_project.DataSet1TableAdapters.RENTAL_STATUSTableAdapter();
this.reservationTableAdapter1 = new final_project.DataSet1TableAdapters.RESERVATIONTableAdapter();
this.reviewTableAdapter1 = new final_project.DataSet1TableAdapters.REVIEWTableAdapter();
this.pRODUCTTableAdapter = new final_project.DataSet1TableAdapters.PRODUCTTableAdapter();
this.pIDDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pTYPEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pLOCATIONDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pFEEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pCONDITIONDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pSIZEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pCOLORDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pRECEIVINGDATEDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pRENTALPERIODDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pAVAILABILITYDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.pRODUCTBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet12)).BeginInit();
this.tabControl1.SuspendLayout();
this.tabPage3.SuspendLayout();
this.tabPage1.SuspendLayout();
this.tabPage2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
this.SuspendLayout();
//
// label1
//
this.label1.AutoSize = true;
this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 20.25F, System.Drawing.FontStyle.Bold);
this.label1.Location = new System.Drawing.Point(417, 20);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(134, 31);
this.label1.TabIndex = 11;
this.label1.Text = "고객 화면";
//
// dataGridView1
//
this.dataGridView1.AutoGenerateColumns = false;
this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.pIDDataGridViewTextBoxColumn,
this.pTYPEDataGridViewTextBoxColumn,
this.pLOCATIONDataGridViewTextBoxColumn,
this.pFEEDataGridViewTextBoxColumn,
this.pCONDITIONDataGridViewTextBoxColumn,
this.pSIZEDataGridViewTextBoxColumn,
this.pCOLORDataGridViewTextBoxColumn,
this.pRECEIVINGDATEDataGridViewTextBoxColumn,
this.pRENTALPERIODDataGridViewTextBoxColumn,
this.pAVAILABILITYDataGridViewTextBoxColumn
});
this.dataGridView1.DataSource = this.pRODUCTBindingSource;
this.dataGridView1.Location = new System.Drawing.Point(12, 81);
this.dataGridView1.Name = "dataGridView1";
this.dataGridView1.RowTemplate.Height = 23;
this.dataGridView1.Size = new System.Drawing.Size(974, 227);
this.dataGridView1.TabIndex = 12;
this.dataGridView1.CellClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dataGridView1_CellClick);
//
// pRODUCTBindingSource
//
this.pRODUCTBindingSource.DataMember = "PRODUCT";
this.pRODUCTBindingSource.DataSource = this.dataSet12;
//
// dataSet12
//
this.dataSet12.DataSetName = "DataSet1";
this.dataSet12.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// label2
//
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(12, 57);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(67, 12);
this.label2.TabIndex = 13;
this.label2.Text = "- 물품 현황";
//
// label3
//
this.label3.AutoSize = true;
this.label3.Location = new System.Drawing.Point(3, 15);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(67, 12);
this.label3.TabIndex = 14;
this.label3.Text = "- 물품 리뷰";
//
// tbx_pID
//
this.tbx_pID.Location = new System.Drawing.Point(76, 36);
this.tbx_pID.Name = "tbx_pID";
this.tbx_pID.Size = new System.Drawing.Size(100, 21);
this.tbx_pID.TabIndex = 15;
//
// label4
//
this.label4.AutoSize = true;
this.label4.Location = new System.Drawing.Point(13, 39);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(57, 12);
this.label4.TabIndex = 16;
this.label4.Text = "물품 번호";
//
// btn_review
//
this.btn_review.Location = new System.Drawing.Point(193, 34);
this.btn_review.Name = "btn_review";
this.btn_review.Size = new System.Drawing.Size(75, 23);
this.btn_review.TabIndex = 17;
this.btn_review.Text = "리뷰 검색";
this.btn_review.UseVisualStyleBackColor = true;
this.btn_review.Click += new System.EventHandler(this.btn_review_Click);
//
// label5
//
this.label5.AutoSize = true;
this.label5.Location = new System.Drawing.Point(289, 75);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(33, 12);
this.label5.TabIndex = 18;
this.label5.Text = "제 목";
//
// label6
//
this.label6.AutoSize = true;
this.label6.Location = new System.Drawing.Point(289, 120);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(33, 12);
this.label6.TabIndex = 19;
this.label6.Text = "내 용";
//
// tbx_title
//
this.tbx_title.Location = new System.Drawing.Point(291, 90);
this.tbx_title.Name = "tbx_title";
this.tbx_title.Size = new System.Drawing.Size(654, 21);
this.tbx_title.TabIndex = 20;
//
// tbx_contents
//
this.tbx_contents.Location = new System.Drawing.Point(291, 138);
this.tbx_contents.Multiline = true;
this.tbx_contents.Name = "tbx_contents";
this.tbx_contents.Size = new System.Drawing.Size(654, 159);
this.tbx_contents.TabIndex = 21;
//
// lbx_review
//
this.lbx_review.FormattingEnabled = true;
this.lbx_review.ItemHeight = 12;
this.lbx_review.Location = new System.Drawing.Point(15, 65);
this.lbx_review.Name = "lbx_review";
this.lbx_review.Size = new System.Drawing.Size(253, 232);
this.lbx_review.TabIndex = 22;
this.lbx_review.SelectedIndexChanged += new System.EventHandler(this.lbx_review_SelectedIndexChanged);
//
// tabControl1
//
this.tabControl1.Controls.Add(this.tabPage3);
this.tabControl1.Controls.Add(this.tabPage1);
this.tabControl1.Controls.Add(this.tabPage2);
this.tabControl1.Location = new System.Drawing.Point(12, 314);
this.tabControl1.Name = "tabControl1";
this.tabControl1.SelectedIndex = 0;
this.tabControl1.Size = new System.Drawing.Size(974, 342);
this.tabControl1.TabIndex = 23;
//
// tabPage3
//
this.tabPage3.Controls.Add(this.tbx_rental_pID);
this.tabPage3.Controls.Add(this.label14);
this.tabPage3.Controls.Add(this.btn_rent);
this.tabPage3.Controls.Add(this.btn_search);
this.tabPage3.Controls.Add(this.tbx_size);
this.tabPage3.Controls.Add(this.cbx_type);
this.tabPage3.Controls.Add(this.label15);
this.tabPage3.Controls.Add(this.cbx_color);
this.tabPage3.Controls.Add(this.label12);
this.tabPage3.Controls.Add(this.label11);
this.tabPage3.Controls.Add(this.label10);
this.tabPage3.Controls.Add(this.cbx_fee);
this.tabPage3.Location = new System.Drawing.Point(4, 22);
this.tabPage3.Name = "tabPage3";
this.tabPage3.Size = new System.Drawing.Size(966, 316);
this.tabPage3.TabIndex = 2;
this.tabPage3.Text = "대여 신청";
this.tabPage3.UseVisualStyleBackColor = true;
//
// tbx_rental_pID
//
this.tbx_rental_pID.Location = new System.Drawing.Point(155, 183);
this.tbx_rental_pID.Name = "tbx_rental_pID";
this.tbx_rental_pID.Size = new System.Drawing.Size(148, 21);
this.tbx_rental_pID.TabIndex = 18;
//
// label14
//
this.label14.AutoSize = true;
this.label14.Location = new System.Drawing.Point(92, 186);
this.label14.Name = "label14";
this.label14.Size = new System.Drawing.Size(57, 12);
this.label14.TabIndex = 17;
this.label14.Text = "물품 번호";
//
// btn_rent
//
this.btn_rent.Location = new System.Drawing.Point(769, 175);
this.btn_rent.Name = "btn_rent";
this.btn_rent.Size = new System.Drawing.Size(75, 23);
this.btn_rent.TabIndex = 14;
this.btn_rent.Text = "대여 신청";
this.btn_rent.UseVisualStyleBackColor = true;
this.btn_rent.Click += new System.EventHandler(this.btn_rent_Click);
//
// btn_search
//
this.btn_search.Cursor = System.Windows.Forms.Cursors.Default;
this.btn_search.Location = new System.Drawing.Point(769, 79);
this.btn_search.Name = "btn_search";
this.btn_search.Size = new System.Drawing.Size(75, 23);
this.btn_search.TabIndex = 13;
this.btn_search.Text = "검 색";
this.btn_search.UseVisualStyleBackColor = true;
this.btn_search.Click += new System.EventHandler(this.btn_search_Click);
//
// tbx_size
//
this.tbx_size.Location = new System.Drawing.Point(651, 80);
this.tbx_size.Name = "tbx_size";
this.tbx_size.Size = new System.Drawing.Size(100, 21);
this.tbx_size.TabIndex = 12;
//
// cbx_type
//
this.cbx_type.FormattingEnabled = true;
this.cbx_type.Items.AddRange(new object[] {
"coat",
"jacket",
"sweater",
"vest",
"shirts",
"pants",
"jeans",
"shoes",
"bag",
"hat"
});
this.cbx_type.Location = new System.Drawing.Point(127, 79);
this.cbx_type.Name = "cbx_type";
this.cbx_type.Size = new System.Drawing.Size(121, 20);
this.cbx_type.TabIndex = 11;
this.cbx_type.SelectedIndexChanged += new System.EventHandler(this.cbx_type_SelectedIndexChanged);
//
// label15
//
this.label15.AutoSize = true;
this.label15.Location = new System.Drawing.Point(92, 82);
this.label15.Name = "label15";
this.label15.Size = new System.Drawing.Size(33, 12);
this.label15.TabIndex = 10;
this.label15.Text = "종 류";
//
// cbx_color
//
this.cbx_color.FormattingEnabled = true;
this.cbx_color.Items.AddRange(new object[] {
"black",
"white",
"red",
"green",
"yellow",
"blue",
"purple",
"blue",
"beige",
"brown",
"orange",
"navy"
});
this.cbx_color.Location = new System.Drawing.Point(476, 80);
this.cbx_color.Name = "cbx_color";
this.cbx_color.Size = new System.Drawing.Size(121, 20);
this.cbx_color.TabIndex = 5;
this.cbx_color.SelectedIndexChanged += new System.EventHandler(this.cbx_color_SelectedIndexChanged);
//
// label12
//
this.label12.AutoSize = true;
this.label12.Location = new System.Drawing.Point(436, 83);
this.label12.Name = "label12";
this.label12.Size = new System.Drawing.Size(33, 12);
this.label12.TabIndex = 4;
this.label12.Text = "색 상";
//
// label11
//
this.label11.AutoSize = true;
this.label11.Location = new System.Drawing.Point(603, 83);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(41, 12);
this.label11.TabIndex = 2;
this.label11.Text = "사이즈";
//
// label10
//
this.label10.AutoSize = true;
this.label10.Location = new System.Drawing.Point(253, 82);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(33, 12);
this.label10.TabIndex = 1;
this.label10.Text = "가 격";
//
// cbx_fee
//
this.cbx_fee.FormattingEnabled = true;
this.cbx_fee.Items.AddRange(new object[] {
"1000원 미만",
"1000원 이상 2000원 미만",
"2000원 이상 3000원 미만",
"3000원 이상 4000원 미만",
"4000원 이상 5000원 미만",
"5000원 이상"
});
this.cbx_fee.Location = new System.Drawing.Point(288, 79);
this.cbx_fee.Name = "cbx_fee";
this.cbx_fee.Size = new System.Drawing.Size(143, 20);
this.cbx_fee.TabIndex = 0;
this.cbx_fee.SelectedIndexChanged += new System.EventHandler(this.cbx_fee_SelectedIndexChanged);
//
// tabPage1
//
this.tabPage1.Controls.Add(this.lbx_review);
this.tabPage1.Controls.Add(this.label3);
this.tabPage1.Controls.Add(this.tbx_contents);
this.tabPage1.Controls.Add(this.tbx_pID);
this.tabPage1.Controls.Add(this.tbx_title);
this.tabPage1.Controls.Add(this.label4);
this.tabPage1.Controls.Add(this.label6);
this.tabPage1.Controls.Add(this.btn_review);
this.tabPage1.Controls.Add(this.label5);
this.tabPage1.Location = new System.Drawing.Point(4, 22);
this.tabPage1.Name = "tabPage1";
this.tabPage1.Padding = new System.Windows.Forms.Padding(3);
this.tabPage1.Size = new System.Drawing.Size(966, 316);
this.tabPage1.TabIndex = 0;
this.tabPage1.Text = "리뷰 보기";
this.tabPage1.UseVisualStyleBackColor = true;
//
// tabPage2
//
this.tabPage2.Controls.Add(this.label9);
this.tabPage2.Controls.Add(this.lbx_pID);
this.tabPage2.Controls.Add(this.btn_save);
this.tabPage2.Controls.Add(this.tbx_contents2);
this.tabPage2.Controls.Add(this.tbx_title2);
this.tabPage2.Controls.Add(this.label7);
this.tabPage2.Controls.Add(this.label8);
this.tabPage2.Location = new System.Drawing.Point(4, 22);
this.tabPage2.Name = "tabPage2";
this.tabPage2.Padding = new System.Windows.Forms.Padding(3);
this.tabPage2.Size = new System.Drawing.Size(966, 316);
this.tabPage2.TabIndex = 1;
this.tabPage2.Text = "리뷰 작성";
this.tabPage2.UseVisualStyleBackColor = true;
//
// label9
//
this.label9.AutoSize = true;
this.label9.Location = new System.Drawing.Point(20, 20);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(57, 12);
this.label9.TabIndex = 28;
this.label9.Text = "물품 번호";
//
// lbx_pID
//
this.lbx_pID.FormattingEnabled = true;
this.lbx_pID.ItemHeight = 12;
this.lbx_pID.Location = new System.Drawing.Point(20, 38);
this.lbx_pID.Name = "lbx_pID";
this.lbx_pID.Size = new System.Drawing.Size(120, 256);
this.lbx_pID.TabIndex = 27;
this.lbx_pID.SelectedIndexChanged += new System.EventHandler(this.lbx_pID_SelectedIndexChanged);
//
// btn_save
//
this.btn_save.Location = new System.Drawing.Point(885, 276);
this.btn_save.Name = "btn_save";
this.btn_save.Size = new System.Drawing.Size(75, 23);
this.btn_save.TabIndex = 26;
this.btn_save.Text = "저 장";
this.btn_save.UseVisualStyleBackColor = true;
this.btn_save.Click += new System.EventHandler(this.btn_save_Click);
//
// tbx_contents2
//
this.tbx_contents2.Location = new System.Drawing.Point(185, 85);
this.tbx_contents2.Multiline = true;
this.tbx_contents2.Name = "tbx_contents2";
this.tbx_contents2.Size = new System.Drawing.Size(696, 213);
this.tbx_contents2.TabIndex = 25;
//
// tbx_title2
//
this.tbx_title2.Location = new System.Drawing.Point(185, 37);
this.tbx_title2.Name = "tbx_title2";
this.tbx_title2.Size = new System.Drawing.Size(696, 21);
this.tbx_title2.TabIndex = 24;
//
// label7
//
this.label7.AutoSize = true;
this.label7.Location = new System.Drawing.Point(183, 70);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(33, 12);
this.label7.TabIndex = 23;
this.label7.Text = "내 용";
//
// label8
//
this.label8.AutoSize = true;
this.label8.Location = new System.Drawing.Point(183, 22);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(33, 12);
this.label8.TabIndex = 22;
this.label8.Text = "제 목";
//
// oracleConnection1
//
this.oracleConnection1.ConnectionString = "DATA SOURCE=KIMSIYOUNG;USER ID=A5234150;password=A5234150;";
//
// oracleCommand1
//
oracleParameter8.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter8.ParameterName = "aa";
oracleParameter9.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter9.ParameterName = "bb";
oracleParameter10.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter10.ParameterName = "cc";
oracleParameter11.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter11.ParameterName = "dd";
this.oracleCommand1.Parameters.Add(oracleParameter8);
this.oracleCommand1.Parameters.Add(oracleParameter9);
this.oracleCommand1.Parameters.Add(oracleParameter10);
this.oracleCommand1.Parameters.Add(oracleParameter11);
this.oracleCommand1.Transaction = null;
//
// oracleCommand2
//
oracleParameter12.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter12.ParameterName = "aa";
oracleParameter13.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter13.ParameterName = "bb";
oracleParameter14.OracleDbType = Oracle.DataAccess.Client.OracleDbType.Varchar2;
oracleParameter14.ParameterName = "cc";
this.oracleCommand2.Parameters.Add(oracleParameter12);
this.oracleCommand2.Parameters.Add(oracleParameter13);
this.oracleCommand2.Parameters.Add(oracleParameter14);
this.oracleCommand2.Transaction = null;
//
// dataSet1
//
this.dataSet1.DataSetName = "DataSet1";
this.dataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// customerTableAdapter1
//
this.customerTableAdapter1.ClearBeforeFill = true;
//
// rentaL_STATUSTableAdapter1
//
this.rentaL_STATUSTableAdapter1.ClearBeforeFill = true;
//
// reservationTableAdapter1
//
this.reservationTableAdapter1.ClearBeforeFill = true;
//
// reviewTableAdapter1
//
this.reviewTableAdapter1.ClearBeforeFill = true;
//
// pRODUCTTableAdapter
//
this.pRODUCTTableAdapter.ClearBeforeFill = true;
//
// pIDDataGridViewTextBoxColumn
//
this.pIDDataGridViewTextBoxColumn.DataPropertyName = "P_ID";
this.pIDDataGridViewTextBoxColumn.HeaderText = "물품 번호";
this.pIDDataGridViewTextBoxColumn.Name = "pIDDataGridViewTextBoxColumn";
//
// pTYPEDataGridViewTextBoxColumn
//
this.pTYPEDataGridViewTextBoxColumn.DataPropertyName = "P_TYPE";
this.pTYPEDataGridViewTextBoxColumn.HeaderText = "물품 종류";
this.pTYPEDataGridViewTextBoxColumn.Name = "pTYPEDataGridViewTextBoxColumn";
//
// pLOCATIONDataGridViewTextBoxColumn
//
this.pLOCATIONDataGridViewTextBoxColumn.DataPropertyName = "P_LOCATION";
this.pLOCATIONDataGridViewTextBoxColumn.HeaderText = "위치";
this.pLOCATIONDataGridViewTextBoxColumn.Name = "pLOCATIONDataGridViewTextBoxColumn";
//
// pFEEDataGridViewTextBoxColumn
//
this.pFEEDataGridViewTextBoxColumn.DataPropertyName = "P_FEE";
this.pFEEDataGridViewTextBoxColumn.HeaderText = "대여료";
this.pFEEDataGridViewTextBoxColumn.Name = "pFEEDataGridViewTextBoxColumn";
//
// pCONDITIONDataGridViewTextBoxColumn
//
this.pCONDITIONDataGridViewTextBoxColumn.DataPropertyName = "P_CONDITION";
this.pCONDITIONDataGridViewTextBoxColumn.HeaderText = "물품 상태";
this.pCONDITIONDataGridViewTextBoxColumn.Name = "pCONDITIONDataGridViewTextBoxColumn";
//
// pSIZEDataGridViewTextBoxColumn
//
this.pSIZEDataGridViewTextBoxColumn.DataPropertyName = "P_SIZE";
this.pSIZEDataGridViewTextBoxColumn.HeaderText = "사이즈";
this.pSIZEDataGridViewTextBoxColumn.Name = "pSIZEDataGridViewTextBoxColumn";
//
// pCOLORDataGridViewTextBoxColumn
//
this.pCOLORDataGridViewTextBoxColumn.DataPropertyName = "P_COLOR";
this.pCOLORDataGridViewTextBoxColumn.HeaderText = "색상";
this.pCOLORDataGridViewTextBoxColumn.Name = "pCOLORDataGridViewTextBoxColumn";
//
// pRECEIVINGDATEDataGridViewTextBoxColumn
//
this.pRECEIVINGDATEDataGridViewTextBoxColumn.DataPropertyName = "P_RECEIVINGDATE";
this.pRECEIVINGDATEDataGridViewTextBoxColumn.HeaderText = "입고일";
this.pRECEIVINGDATEDataGridViewTextBoxColumn.Name = "pRECEIVINGDATEDataGridViewTextBoxColumn";
//
// pRENTALPERIODDataGridViewTextBoxColumn
//
this.pRENTALPERIODDataGridViewTextBoxColumn.DataPropertyName = "P_RENTALPERIOD";
this.pRENTALPERIODDataGridViewTextBoxColumn.HeaderText = "대여 기간";
this.pRENTALPERIODDataGridViewTextBoxColumn.Name = "pRENTALPERIODDataGridViewTextBoxColumn";
//
// pAVAILABILITYDataGridViewTextBoxColumn
//
this.pAVAILABILITYDataGridViewTextBoxColumn.DataPropertyName = "P_AVAILABILITY";
this.pAVAILABILITYDataGridViewTextBoxColumn.HeaderText = "대여 가능 여부";
this.pAVAILABILITYDataGridViewTextBoxColumn.Name = "pAVAILABILITYDataGridViewTextBoxColumn";
this.pAVAILABILITYDataGridViewTextBoxColumn.Width = 120;
//
// Form2
//
this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(998, 668);
this.Controls.Add(this.tabControl1);
this.Controls.Add(this.label2);
this.Controls.Add(this.dataGridView1);
this.Controls.Add(this.label1);
this.Name = "Form2";
this.Text = "Form2";
this.Load += new System.EventHandler(this.Form2_Load);
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pRODUCTBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet12)).EndInit();
this.tabControl1.ResumeLayout(false);
this.tabPage3.ResumeLayout(false);
this.tabPage3.PerformLayout();
this.tabPage1.ResumeLayout(false);
this.tabPage1.PerformLayout();
this.tabPage2.ResumeLayout(false);
this.tabPage2.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
protected override void PrepareParameters()
{
// Prepare parameters
foreach (SQLParameter parameter in Parameters)
{
OraHome.Client.OracleParameter oracleParameter = (OraHome.Client.OracleParameter)_command.CreateParameter();
oracleParameter.ParameterName = String.Format("@{0}", parameter.Name);
switch (parameter.Direction)
{
case SQLDirection.Out: oracleParameter.Direction = System.Data.ParameterDirection.Output; break;
case SQLDirection.InOut: oracleParameter.Direction = System.Data.ParameterDirection.InputOutput; break;
case SQLDirection.Result: oracleParameter.Direction = System.Data.ParameterDirection.ReturnValue; break;
default: oracleParameter.Direction = System.Data.ParameterDirection.Input; break;
}
if (parameter.Type is SQLStringType)
{
oracleParameter.OracleDbType = OraHome.Client.OracleDbType.Varchar2;
oracleParameter.Size = ((SQLStringType)parameter.Type).Length;
}
else if (parameter.Type is SQLBooleanType)
{
oracleParameter.OracleDbType = OraHome.Client.OracleDbType.Int32;
}
else if (parameter.Type is SQLIntegerType)
{
switch (((SQLIntegerType)parameter.Type).ByteCount)
{
case 1: oracleParameter.OracleDbType = OraHome.Client.OracleDbType.Byte; break;
case 2: oracleParameter.OracleDbType = OraHome.Client.OracleDbType.Int16; break;
case 8:
oracleParameter.OracleDbType = OraHome.Client.OracleDbType.Decimal;
oracleParameter.Precision = 20;
oracleParameter.Scale = 0;
break;
default: oracleParameter.OracleDbType = OraHome.Client.OracleDbType.Int32; break;
}
}
else if (parameter.Type is SQLNumericType)
{
SQLNumericType type = (SQLNumericType)parameter.Type;
oracleParameter.OracleDbType = OraHome.Client.OracleDbType.Decimal;
oracleParameter.Precision = type.Precision;
oracleParameter.Scale = type.Scale;
}
else if (parameter.Type is SQLBinaryType)
{
oracleParameter.OracleDbType = OraHome.Client.OracleDbType.Blob;
}
else if (parameter.Type is SQLTextType)
{
oracleParameter.OracleDbType = OraHome.Client.OracleDbType.Clob;
}
else if (parameter.Type is SQLDateTimeType)
{
oracleParameter.OracleDbType = OraHome.Client.OracleDbType.Date;
}
else if (parameter.Type is SQLDateType)
{
oracleParameter.OracleDbType = OraHome.Client.OracleDbType.Date;
}
else if (parameter.Type is SQLTimeType)
{
oracleParameter.OracleDbType = OraHome.Client.OracleDbType.Date;
}
else if (parameter.Type is SQLGuidType)
{
oracleParameter.OracleDbType = OraHome.Client.OracleDbType.Char;
oracleParameter.Size = 24;
}
else if (parameter.Type is SQLMoneyType)
{
oracleParameter.OracleDbType = OraHome.Client.OracleDbType.Decimal;
oracleParameter.Precision = 28;
oracleParameter.Scale = 8;
}
else
{
throw new ConnectionException(ConnectionException.Codes.UnknownSQLDataType, parameter.Type.GetType().Name);
}
_command.Parameters.Add(oracleParameter);
}
}
/// <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;
}
