private void LoadData()
{
machineList = R_service.GetMachineAll();
dataGridView2.DataSource = machineList;
machineGreadeList = R_service.GetMachineGrpAll();
dataGridView1.DataSource = machineGreadeList;
}
private void ShiftMain_Load(object sender, EventArgs e)
{
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "ID", "s_id", false, 60);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비코드", "m_code", true, 80);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비명", "m_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "Shift", "common_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "시작시간", "shift_stime", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "완료시간", "shift_etime", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "적용시작일", "shift_sdate", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "적용완료일", "shift_edate", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "사용유무", "shift_yn", true);
dataGridView1.AllowUserToAddRows = false;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
// ShiftService S_service = new ShiftService();
LoadData();
ResourceService R_service = new ResourceService();
List <MachineVO> m_list = R_service.GetMachineAll();
ComboUtil.ComboBinding(cboMachine, m_list, "m_id", "m_name", "미선택");
CommonCodeService C_service = new CommonCodeService();
List <CommonVO> c_list = C_service.GetCommonCodeAll();
var shift_code = (from shift in c_list
where shift.common_type == "shift_code"
select shift).ToList();
ComboUtil.ComboBinding(cboShift, shift_code, "common_value", "common_name", "전체");
GridViewUtil.SetDataGridView(dataGridView1);
}
private void DMRMgt_Load(object sender, EventArgs e)
{
{
ResourceService R_survice = new ResourceService();
List <MachineVO> lst = R_survice.GetMachineAll();
ComboUtil.ComboBinding <MachineVO>(comboBox1, lst, "m_id", "m_name", "미선택");
}
dataGridView1.RowHeadersVisible = false;
dataGridView1.ReadOnly = true;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
DataGridViewCheckBoxColumn checkBoxColumn = new DataGridViewCheckBoxColumn();
checkBoxColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
checkBoxColumn.Name = "ck";
checkBoxColumn.HeaderText = "선택";
checkBoxColumn.MinimumWidth = 50;
dataGridView1.Columns.Add(checkBoxColumn);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "pro_id", "pro_id", false, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "플랜id", "plan_id", false, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "계획시작일자", "pro_date", true, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, " ", "so_sdate", false, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "설비코드", "m_code", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "설비명", "m_name", true, 100, DataGridViewContentAlignment.MiddleLeft); //
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "상태", "pro_state", false, 100, DataGridViewContentAlignment.MiddleLeft); //ff
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "상태", "common_name", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "상품코드", "product_codename", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "상품명", "producct_name", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "소요창고", "m_use_sector", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "양품창고", "m_ok_sector", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "불량창고", "m_ng_sector", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "계획수량", "pro_count", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "", "pro_pcount", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "", "pro_mcount", false, 100, DataGridViewContentAlignment.MiddleLeft);
DateTime today = DateTime.Now;
dateTimePicker1.Value = today.AddDays(-10);
dateTimePicker2.Value = today.AddDays(20);
ProcessService P_service = new ProcessService();
dt = P_service.GetProductionPlanCheckHis(dateTimePicker1.Value.ToShortDateString(), dateTimePicker2.Value.ToShortDateString());
// dataGridView1.DataSource =
DataView dv = dt.DefaultView;
DataTable table = new DataTable();
dv.RowFilter = "pro_state = 'COMMAND' ";
if (dv.Count > 0)
{
table = dv.ToTable();
dataGridView1.DataSource = table;
}
GridViewUtil.SetDataGridView(dataGridView1);
}
private void InitComboBox()
{
OrderService service = new OrderService();
List <string> list = service.GetPlanID();
// list.Insert(0, );
cboPlanID.DataSource = list;
List <MachineVO> lst = R_service.GetMachineAll();
ComboUtil.ComboBinding(cboMachine, lst, "m_id", "m_name", "전체");
}
private void SOO_Load(object sender, EventArgs e)
{
radioButton6.Checked = true;
ResourceService R_service = new ResourceService();
CommonCodeService C_service = new CommonCodeService();
List <CommonVO> c_list = C_service.GetCommonCodeAll();
{
var list_c = (from item in c_list
where item.common_type == "create_work_order"
select item).ToList();
ComboUtil.ComboBinding(cboStatus, list_c, "common_value", "common_name", "미선택");
}
{
var R_list = (from item in R_service.GetFactoryAll()
where item.facility_class == "창고"
select item).ToList();
ComboUtil.ComboBinding(cboWH, R_list, "factory_id", "factory_name", "미선택");
}
{
ComboUtil.ComboBinding(cboMachine, R_service.GetMachineAll(), "m_id", "m_name", "미선택");
}
dateTimePicker1.Value = today.AddDays(-10);
dateTimePicker2.Value = today.AddDays(20);
dt = P_service.GetProductionPlanCheckHis(dateTimePicker1.Value.ToShortDateString(), dateTimePicker2.Value.ToShortDateString());
GridViewUtil.SetDataGridView(dataGridView1);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "상품ID", "pro_id", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "투입일", "pro_date", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "지시일", "so_sdate", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비코드", "m_code", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비명", "m_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "상태", "common_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "상태", "pro_state", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목", "product_codename", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품명", "producct_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "소진창고", "m_use_sector", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "양품창고", "m_ok_sector", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "불량창고", "m_ng_sector", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "계획수량", "pro_count", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "지시수량", "pro_pcount", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "수량", "pro_mcount", true);
GridViewUtil.SetDataGridView(dataGridView1);
dataGridView1.DataSource = dt;
}
private void GOO_Load(object sender, EventArgs e)
{
CommonCodeService C_service = new CommonCodeService();
List <CommonVO> c_list = C_service.GetCommonCodeAll();
{
var list_c = (from item in c_list
where item.common_type == "create_work_order"
select item).ToList();
ComboUtil.ComboBinding(cboStatus, list_c, "common_value", "common_name", "미선택");
}
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.AllowUserToAddRows = false;
dateTimePicker1.Value = DateTime.Now.AddDays(-7);
dateTimePicker2.Value = DateTime.Now.AddDays(7);
ResourceService R_service = new ResourceService();
List <MachineVO> m_list = R_service.GetMachineAll();
ComboUtil.ComboBinding(cboMachine, m_list, "m_code", "m_name", "미선택");
DataGridViewCheckBoxColumn checkBoxColumn = new DataGridViewCheckBoxColumn();
checkBoxColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
checkBoxColumn.HeaderText = "선택";
dataGridView1.Columns.Add(checkBoxColumn);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "작업지시번호", "WorkID", true, 60);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목", "product_codename", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품명", "product_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "상태", "common_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "상태", "pro_state", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비코드", "m_code", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비명", "m_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "계획수량", "pro_count", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "지시수량", "pro_pcount", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "계획시작일", "pro_date", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "마스터ID", "plan_id", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "상품ID", "pro_id", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "소요시간", "use_time", true);
GridViewUtil.SetDataGridView(dataGridView1);
LoadData();
}
private void BORPop_Load(object sender, EventArgs e)
{
R_survice = new ResourceService();
#region 콤보박스 바인딩
common_service = new CommonCodeService();
common_list = common_service.GetCommonCodeAll();
{
//공정
var mCode = (from item in common_list
where item.common_type == "route"
select item).ToList();
ComboUtil.ComboBinding <CommonVO>(cboRoute, mCode, "common_value", "common_name", "미선택");
}
{
//사용유무
var mCode = (from item in common_list
where item.common_type == "user_flag"
select item).ToList();
ComboUtil.ComboBinding <CommonVO>(cboYN, mCode, "common_value", "common_name");
}
R_survice = new ResourceService();
List <MachineVO> lst = R_survice.GetMachineAll();
ComboUtil.ComboBinding <MachineVO>(cboM_name, lst, "m_id", "m_name", "미선택");
ProductService product_service = new ProductService();
List <ProductVO> list = product_service.GetAllProducts();
ComboUtil.ComboBinding <ProductVO>(cboP_Name, list, "product_id", "product_name", "미선택");
#endregion
if (mode == EditMode.Update)
{
R_survice = new ResourceService();
vo = R_survice.GetBORByID(Convert.ToInt32(lblID.Text), lblRoute.Text);
lblID.Text = vo.bor_id.ToString();
cboP_Name.Text = vo.product_name;
cboM_name.Text = vo.m_name;
cboYN.Text = vo.bor_yn;
cboRoute.Text = vo.common_name;
txtComment.Text = vo.bor_comment;
txtReadyTime.Text = vo.bor_readytime.ToString();
txtTactTime.Text = vo.bor_tacktime.ToString();
}
}
private void InitComboBind()
{
string todayFormat = string.Format("{0:yyyy-MM-dd HH:mm:ss}", today);
txtUdate.Text = todayFormat;
ResourceService R_service = new ResourceService();
List <MachineVO> m_list = R_service.GetMachineAll();
ComboUtil.ComboBinding(cboM_code, m_list, "m_id", "m_code");
CommonCodeService C_service = new CommonCodeService();
List <CommonVO> c_list = C_service.GetCommonCodeAll();
var shift_code = (from shift in c_list
where shift.common_type == "shift_code"
select shift).ToList();
ComboUtil.ComboBinding(cboShiftID, shift_code, "common_value", "common_name");
var YN = (from shift in c_list
where shift.common_type == "user_flag"
select shift).ToList();
ComboUtil.ComboBinding(cboYN, YN, "common_value", "common_name");
}
