//선배차 차량 관리 화면 차량 리스트
internal OracleDataTable GetCarUsageList()
{
//OracleDataTable dataTable = _dbService.ExecuteQuery("SELECT * FROM TKXADS18_CAR");
OracleDataTable dataTable = _dbService.SP_VRO_GET_CAR_USAGE(ApplicationKey.company, ApplicationKey.center, ApplicationKey.mst_id, ApplicationKey.current_plan_id, "", ApplicationKey.plan_st, ApplicationKey.userId);
return(dataTable);
}
//선택 시나리오 적용
public OracleDataTable GetGridSelectedOptionByScenario(string type, string policy_code, string plan_id)
{
//OracleDataTable dataTable = _dbService.ExecuteQuery("SELECT * FROM TKXADS18_ENG WHERE POLYID ='PLC_DEFAULT'");
OracleDataTable dataTable = _dbService.SP_VRO_GET_OPTION4_BY_PLANPOLY(type, ApplicationKey.division, ApplicationKey.corporation, ApplicationKey.plant, ApplicationKey.masterID, policy_code, ApplicationKey.plansST, plan_id, ApplicationKey.userId);
return(dataTable);
}
//선배차 차량 관리 화면 차량 리스트
internal OracleDataTable GetCarUsageList()
{
//OracleDataTable dataTable = _dbService.ExecuteQuery("SELECT * FROM TKXADS18_CAR");
OracleDataTable dataTable = _dbService.SP_VRO_GET_CAR_USAGE(ApplicationKey.division, ApplicationKey.corporation, ApplicationKey.plant, ApplicationKey.masterID, ApplicationKey.current_planID, "", ApplicationKey.plansST, ApplicationKey.userId);
return(dataTable);
}
private void setButton()
{
//자동배차 실행 관리의 현재 단계 status 가져오기
bizService = getBizService();
oraDt = bizService.GetAutoallocate();
#region Print dt
//PrintDebug(oraDt);
#endregion
DataRow statusDr = oraDt.Rows[0];
//textEdit_plan_date.Text = statusDr["plan_date"].ToString();
//textEdit_planst.Text = statusDr["planst"].ToString();
//textEdit_policy_list.Text = statusDr["policy_list"].ToString();
//textEdit_plan_status.Text = statusDr["plan_status"].ToString();
//plan_status_button = statusDr["plan_status_button"].ToString();
textEdit_plan_date.Text = statusDr["PLANDT"].ToString();
textEdit_planst.Text = statusDr["PLANST"].ToString();
textEdit_policy_list.Text = statusDr["POLYID"].ToString();
plan_status_button = statusDr["PLAN_STATUS_BUTTON"].ToString();
SetStatus(plan_status_button);
}
public OracleDataTable GetPolicyList()
{
// Parameter ( 조회타입, 법인코드, 공장코드,마스터ID, USERID)
OracleDataTable dataTable = _dbService.SP_VRO_GET_POLICY_LIST("N", ApplicationKey.company, ApplicationKey.center, ApplicationKey.mst_id, ApplicationKey.userId);
return(dataTable);
}
private void FormMakeDispatching_Load(object sender, EventArgs e)
{
//자동배차 실행 관리의 현재 단계 status 가져오기
bizService = getBizService();
oraDt = bizService.GetAutoallocate();
#region Print dt
PrintDebug(oraDt);
#endregion
DataRow statusDr = oraDt.Rows[0];
//textEdit_plan_date.Text = statusDr["plan_date"].ToString();
//textEdit_planst.Text = statusDr["planst"].ToString();
//textEdit_policy_list.Text = statusDr["policy_list"].ToString();
//textEdit_plan_status.Text = statusDr["plan_status"].ToString();
//plan_status_button = statusDr["plan_status_button"].ToString();
textEdit_plan_date.Text = statusDr["PLANDT"].ToString();
textEdit_planst.Text = statusDr["PLANST"].ToString();
textEdit_policy_list.Text = statusDr["POLYID"].ToString();
plan_status_button = statusDr["PLAN_STATUS_BUTTON"].ToString();
SetStatus(plan_status_button);
InitializeData();
setGridColumn();
SetSummary();
}
public OracleDataTable GetScenarioList()
{
// Parameter ( 조회타입, 사업부코드, 법인코드, 공장코드,마스터ID, USERID)
OracleDataTable dataTable = _dbService.SP_VRO_GET_SCENARIO_LIST(ApplicationKey.company, ApplicationKey.center, ApplicationKey.mst_id, ApplicationKey.plan_id, ApplicationKey.userId);
//OracleDataTable dataTable = _dbService.ExecuteQuery("SELECT * FROM TKXADS18_PLC WHERE DELMAK='N'");
return(dataTable);
}
public OracleDataTable GetPolicyList()
{
// Parameter ( 조회타입, 사업부코드, 법인코드, 공장코드,마스터ID, USERID)
OracleDataTable dataTable = _dbService.SP_VRO_GET_POLICY_LIST("N", ApplicationKey.division, ApplicationKey.corporation, ApplicationKey.plant, ApplicationKey.masterID, ApplicationKey.userId);
//OracleDataTable dataTable = _dbService.ExecuteQuery("SELECT * FROM TKXADS18_PLC WHERE DELMAK='N'");
return(dataTable);
}
public OracleDataTable GetOptionList(string type)
{
//string planDate = "20131001";
string planid = ApplicationKey.planID2[0] + '↑' + ApplicationKey.planID2[1] + '↑' + ApplicationKey.planID2[2];
OracleDataTable dataTable = _dbService.SP_VRO_GET_OPTION4_ALL_LIST(type, ApplicationKey.division, ApplicationKey.corporation, ApplicationKey.plant, ApplicationKey.masterID, planid, ApplicationKey.plansST, ApplicationKey.plansST, ApplicationKey.userId);
//OracleDataTable dataTable = _dbService.ExecuteQuery("SELECT * FROM TKXADS18_ENG");
return(dataTable);
}
public OracleDataTable GetOptionList(string type)
{
//string planDate = "20131001";
string planid = ApplicationKey.plan_id2[0] + '↑' + ApplicationKey.plan_id2[1] + '↑' + ApplicationKey.plan_id2[2];
OracleDataTable dataTable = _dbService.SP_VRO_GET_OPTION4_ALL_LIST(type, ApplicationKey.company, ApplicationKey.center, ApplicationKey.mst_id, planid, ApplicationKey.plan_st, ApplicationKey.plan_st, ApplicationKey.userId);
//OracleDataTable dataTable = _dbService.ExecuteQuery("SELECT * FROM TKXADS18_ENG");
return(dataTable);
}
private void buttonTest_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
IApplicationContext _applicationContext = ContextRegistry.GetContext();
BizService bizService = (BizService)_applicationContext.GetObject("BizService");
OracleDataTable dt = bizService.GetInBound();
// gridControl1.DataSource = dt; // 그리드에연결
// gridControl1.RefreshDataSource() ; // 화면 Refresh
}
/// <summary>
/// Multi-ResultSet일 경우에 DataTable 컬렉션으로 반환합니다.
/// NOTE: Oracle에서는 Multi-ResultSet 작업을 위해서 SQL 문이 상당히 복잡합니다. 차라리 ExecuteDataTableAsync를 여러개 호출하세요.
/// </summary>
public static Task <IList <OracleDataTable> > ExecuteDataTableAsListAsync(this EnterpriseLibrary.OracleDatabase oraDatabase,
OracleCommand oraCommand,
int?firstResult,
int?maxResults,
params IAdoParameter[] parameters)
{
oraCommand.ShouldNotBeNull("oraCommand");
if (IsDebugEnabled)
{
log.Debug(
"비동기 방식으로 ExecuteDataTable을 실행합니다... CommandText=[{0}], firstResult=[{1}], maxResults=[{2}], Parameters=[{3}]",
oraCommand.CommandText, firstResult, maxResults, parameters.CollectionToString());
}
return
(ExecuteReaderAsync(oraDatabase, oraCommand, parameters)
.ContinueWith(task => {
IList <OracleDataTable> tables = new List <OracleDataTable>();
if (IsDebugEnabled)
{
log.Debug("비동기방식으로 OracleDataReader를 가져와, OracleDataTable로 빌드합니다...");
}
using (var reader = task.Result)
using (var adapter = new AdoDataAdapter(oraDatabase.GetDataAdapter())) {
do
{
var dataTable = new OracleDataTable {
Locale = CultureInfo.InvariantCulture
};
adapter.Fill(new[] { dataTable }, reader, firstResult ?? 0, maxResults ?? 0);
tables.Add(dataTable);
} while(reader.IsClosed == false && reader.NextResult());
}
if (IsDebugEnabled)
{
log.Debug("OracleDataReader로부터 OracleDataTable [{0}] 개를 빌드했습니다.", tables.Count);
}
return tables;
},
TaskContinuationOptions.ExecuteSynchronously));
}
private void PrintDebug(OracleDataTable dt)
{
int rCnt = dt.Rows.Count;
int cCnt = dt.Columns.Count;
int nExit = 0;
foreach (DataRow row2 in dt.Rows)
{
for (int idx = 0; idx < dt.Columns.Count; idx++)
{
Debug.Write(string.Format("\t{0}", row2[idx]));
}
Debug.WriteLine("");
nExit++;
if (nExit == 50)
{
break;
}
}
}
private void FormMakeDispatching_Activated(object sender, EventArgs e)
{
try
{
bizService = getBizService();
oraDt = bizService.GetAutoallocate();
#region Print dt
//PrintDebug(oraDt);
#endregion
DataRow statusDr = oraDt.Rows[0];
//textEdit_plan_date.Text = statusDr["plan_date"].ToString();
//textEdit_planst.Text = statusDr["planst"].ToString();
//textEdit_policy_list.Text = statusDr["policy_list"].ToString();
//textEdit_plan_status.Text = statusDr["plan_status"].ToString();
//plan_status_button = statusDr["plan_status_button"].ToString();
textEdit_plan_date.Text = statusDr["PLANDT"].ToString();
textEdit_planst.Text = statusDr["PLANST"].ToString();
textEdit_policy_list.Text = statusDr["POLYID"].ToString();
plan_status_button = statusDr["PLAN_STATUS_BUTTON"].ToString();
SetStatus(plan_status_button);
InitializeData();
SetSummary();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
setButton();
}
}
/// <summary>
/// 선배차 종료시 Button_change 발. 쿼리로 현재 단계 재조회
/// </summary>
public void Button_change()
{
bizService = getBizService();
oraDt = bizService.GetAutoallocate();
DataRow statusDr = oraDt.Rows[0];
//textEdit_plan_date.Text = statusDr["plan_date"].ToString();
//textEdit_planst.Text = statusDr["planst"].ToString();
//textEdit_policy_list.Text = statusDr["policy_list"].ToString();
//textEdit_plan_status.Text = statusDr["plan_status"].ToString();
//plan_status_button = statusDr["plan_status_button"].ToString();
textEdit_plan_date.Text = statusDr["PLANDT"].ToString();
textEdit_planst.Text = statusDr["PLANST"].ToString();
textEdit_policy_list.Text = statusDr["POLYID"].ToString();
plan_status_button = statusDr["PLAN_STATUS_BUTTON"].ToString();
SetStatus(plan_status_button);
}
private void SetSummary()
{
try
{
GridView view_gridSummary = (GridView)gridDispatchingSummary.Views[0];
dtGridSummary.Rows.Clear();
bizService = getBizService();
OracleDataTable summaryOradt = bizService.GetMakeDispatchSummary();
#region Print dt
//PrintDebug(summaryOradt);
#endregion
foreach (DataRow _row in summaryOradt.Rows)
{
DataRow dr = dtGridSummary.NewRow();
gridView1.Columns["gridColumn1"].ColumnEdit = GetRepositoryItemCheckEdit();
dr["gridColumn2"] = _row["POLYID"];
dr["gridColumn3"] = _row["PLANPH"];
dr["gridColumn4"] = _row["VHCCNT"];
dr["gridColumn5"] = _row["NALRTO"];
dr["gridColumn6"] = _row["ALDRTO"];
dr["gridColumn7"] = _row["PERCST"];
dtGridSummary.Rows.Add(dr);
}
gridDispatchingSummary.DataSource = dtGridSummary;
gridDispatchingSummary.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
internal OracleDataTable GetDeletePolicyList()
{
OracleDataTable dataTable = _dbService.SP_VRO_GET_POLICY_LIST("D", ApplicationKey.division, ApplicationKey.corporation, ApplicationKey.plant, ApplicationKey.masterID, ApplicationKey.userId);
return(dataTable);
}
//가확정 차량리스트
internal OracleDataTable GetTmpcarallocCarlist(string policyID)
{
OracleDataTable dataTable = _dbService.SP_VRO_GET_TMPCARALLOC_CARLIST(ApplicationKey.division, ApplicationKey.corporation, ApplicationKey.plant, ApplicationKey.masterID, ApplicationKey.planID2[0], " ", ApplicationKey.plansST, ApplicationKey.userId, policyID);
return(dataTable);
}
//엔진옵션 콤보박스 리스트(권역정렬)
internal OracleDataTable GetGridSelectedOptionByPolicy_combobox(string query_type, string key_id)
{
OracleDataTable dataTable = _dbService.SP_VRO_GET_COMMON_CODE(query_type, key_id, ApplicationKey.userId);
return(dataTable);
}
//선택 policy 관련 옵션 리스트
public OracleDataTable GetGridSelectedOptionByPolicy(string type, string policy_code)
{
OracleDataTable dataTable = _dbService.SP_VRO_GET_OPTION4_BY_POLICY(type, ApplicationKey.company, ApplicationKey.center, ApplicationKey.mst_id, policy_code, ApplicationKey.plan_id, ApplicationKey.plan_st, ApplicationKey.userId);
return(dataTable);
}
//신규버튼 클릭시 디폴트 저장옵션 리스트
internal OracleDataTable GetGridSelectedOptionDefault(string type)
{
OracleDataTable dataTable = _dbService.SP_VRO_GET_OPTION4_DEFAULT(type, ApplicationKey.division, ApplicationKey.corporation, ApplicationKey.plant, ApplicationKey.masterID, "", "", ApplicationKey.plansST, ApplicationKey.userId);
return(dataTable);
}
//이동 속도 콤보박스
internal OracleDataTable GetGridSelectedOptionByPolicy_movingSpeed_combobox()
{
OracleDataTable dataTable = _dbService.SP_VRO_GET_MOVING_SPEED(ApplicationKey.division, ApplicationKey.corporation, ApplicationKey.plant, ApplicationKey.masterID, ApplicationKey.planID, "", ApplicationKey.plansST, ApplicationKey.userId);
return(dataTable);
}
internal OracleDataTable GetAutoallocate()
{
OracleDataTable dataTable = _dbService.SP_VRO_GET_AUTOALLOCATE_INFO(ApplicationKey.division, ApplicationKey.corporation, ApplicationKey.plant, ApplicationKey.masterID, ApplicationKey.planID, "", ApplicationKey.plansST, ApplicationKey.userId);
return(dataTable);
}
internal OracleDataTable GetDeletePolicyList()
{
OracleDataTable dataTable = _dbService.SP_VRO_GET_POLICY_LIST("D", ApplicationKey.company, ApplicationKey.center, ApplicationKey.mst_id, ApplicationKey.userId);
return(dataTable);
}
//선배차 차량 관리 화면 차량 리스트
internal OracleDataTable GetPreOrderCarList()
{
OracleDataTable dataTable = _dbService.SP_VRO_GET_PREORDERCAR_INFO(ApplicationKey.division, ApplicationKey.corporation, ApplicationKey.plant, ApplicationKey.masterID, ApplicationKey.planID, " ", ApplicationKey.plansST, ApplicationKey.userId);
return(dataTable);
}
//가확정 할당,미할당
internal OracleDataTable sp_vro_get_caralloc_phalist(string type, string carNumber)
{
OracleDataTable dataTable = _dbService.SP_VRO_GET_CARALLOC_PHALIST(type, ApplicationKey.division, ApplicationKey.corporation, ApplicationKey.plant, ApplicationKey.masterID, ApplicationKey.current_planID, "", ApplicationKey.plansST, ApplicationKey.userId, carNumber);
return(dataTable);
}
public OracleDataTable GetData_HST()
{
OracleDataTable dataTable = _dbService.ExecuteQuery("SELECT * FROM TKXADS18_HST");
return(dataTable);
}
//배차 실행 관리 summary
internal OracleDataTable GetMakeDispatchSummary()
{
OracleDataTable dataTable = _dbService.SP_VRO_GET_MAKE_DISPATCH_SUM(ApplicationKey.division, ApplicationKey.corporation, ApplicationKey.plant, ApplicationKey.masterID, ApplicationKey.planID, " ", ApplicationKey.plansST, ApplicationKey.userId);
return(dataTable);
}
//조회버튼 클릭
private void buttonView_Click(object sender, EventArgs e)
{
try
{
screenManager.ShowWaitForm();
dtGridCarDispatching.Rows.Clear();
bizService = (BizService)_applicationContext.GetObject("BizService");
//OracleDataTable dt = bizService.GetCarList();
OracleDataTable dt = bizService.GetPreOrderCarList();
foreach (DataRow _row in dt.Rows)
{
SetRepositoryItemSpinEditBindData(gridCarDispatching, "working_startTime_hour", 23);
SetRepositoryItemSpinEditBindData(gridCarDispatching, "working_startTime_minute", 59);
SetRepositoryItemSpinEditBindData(gridCarDispatching, "working_startTime_second", 59);
SetRepositoryItemSpinEditBindData(gridCarDispatching, "working_endTime_hour", 23);
SetRepositoryItemSpinEditBindData(gridCarDispatching, "working_endTime_minute", 59);
SetRepositoryItemSpinEditBindData(gridCarDispatching, "working_endTime_second", 59);
SetRepositoryItemComboBoxBindData(gridCarDispatching, "FINTWA", "working_apply", dt);
DataRow dr = dtGridCarDispatching.NewRow();
dr["carNum"] = _row["VEHCID"];
dr["carType"] = _row["VHCTON"];
string work_startTime = _row["TIMWFR"].ToString();
if (!(work_startTime == null || work_startTime.Equals("")))
{
dr["working_startTime_hour"] = work_startTime.Substring(0, 2);;
dr["working_startTime_minute"] = work_startTime.Substring(3, 2);
dr["working_startTime_second"] = work_startTime.Substring(6, 2);
}
string work_endTime = _row["TIMWTO"].ToString();
if (!(work_endTime == null || work_endTime.Equals("")))
{
dr["working_endTime_hour"] = work_endTime.Substring(0, 2);
dr["working_endTime_minute"] = work_endTime.Substring(3, 2);
dr["working_endTime_second"] = work_endTime.Substring(6, 2);
}
dr["working_apply"] = "Y";;
dtGridCarDispatching.Rows.Add(dr);
gridCarDispatching.DataSource = dtGridCarDispatching;
}
//gridCarDispatching.DataSource = dt;
gridCarDispatching.RefreshDataSource();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
screenManager.CloseWaitForm();
}
}
public OracleDataTable GetInBound()
{
OracleDataTable dataTable = _dbService.SP_VRO_GET_INBOUND("DIV1", "PLAN2", "KIM");
return(dataTable);
}
