private void SetDataGridOrdering()
{
dgvOrdering.Columns.Clear();
GridViewUtil.SetDataGridView(dgvOrdering);
dgvOrdering.AutoGenerateColumns = false;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "선택";
chk.Name = "chk";
chk.Width = 40;
dgvOrdering.Columns.Add(chk);
//Point headerLocation = dgvOrdering.GetCellDisplayRectangle(0, -1, true).Location;
//headerCheckBox1.Location = new Point(headerLocation.X + 8, headerLocation.Y + 2); //그냥 이렇게 주면 위치가 썩 이쁘지않아서 숫자 좀 더 플러스함
//headerCheckBox1.BackColor = Color.White;
//headerCheckBox1.Size = new Size(18, 18);
//headerCheckBox1.Click += new EventHandler(HeaderCheckbox_Click);
//dgvOrdering.Controls.Add(headerCheckBox1);
GridViewUtil.AddNewColumnToDataGridView(dgvOrdering, "Plan ID", "plan_id", true, 110);
GridViewUtil.AddNewColumnToDataGridView(dgvOrdering, "발주업체", "company_name", true);
GridViewUtil.AddNewColumnToDataGridView(dgvOrdering, "품목", "product_codename", true);
//GridViewUtil.AddNewColumnToDataGridView(dgvOrdering, "창고", "factory_name", true);
GridViewUtil.AddNewColumnToDataGridView(dgvOrdering, "품명", "producct_name", true);
GridViewUtil.AddNewColumnToTextBoxGridView(dgvOrdering, "납기일", "pro_date", true);
GridViewUtil.AddNewColumnToDataGridView(dgvOrdering, "현재고", "present_count", true, 70, DataGridViewContentAlignment.MiddleRight, true);
GridViewUtil.AddNewColumnToDataGridView(dgvOrdering, "발주제안수량", "pro_count", true, 110, DataGridViewContentAlignment.MiddleRight, true);
GridViewUtil.AddNewColumnToTextBoxGridView(dgvOrdering, "발주수량", "", true, 80, DataGridViewContentAlignment.MiddleRight);
}
private void FactoryMgt_Load(object sender, EventArgs e)
{
this.ImeMode = ImeMode.Hangul;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "ID", "factory_id", false, 60);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "시설군", "facility_class", true, 80);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "시설구분", "facility_type", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "시설타입", "facility_value", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "시설코드", "factory_code", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "시설명", "factory_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "상위시설", "factory_parent", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "업체명", "company_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "사용유무", "factory_yn", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "수정자", "factory_uadmin", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "수정시간", "factory_udate", true);
GridViewUtil.SetDataGridView(dataGridView1);
LoadData();
CommonCodeService Common_service = new CommonCodeService();
common_list = Common_service.GetCommonCodeAll();
var mCode = (from item in common_list
where item.common_type == "facility_class_id"
select item).ToList();
ComboUtil.ComboBinding <CommonVO>(cboSearchFacilityGroup, mCode, "common_value", "common_name", "미선택");
panel1.Focus();
dataGridView1.CurrentCell = null;
dataGridView1.ClearSelection();
}
private void InitControl()
{
OrderService order_service = new OrderService();
#region 업체cbo
List <CompanyVO> company_list = order_service.GetCompanyAll("CUSTOMER");
ComboUtil.ComboBinding(cboCompany, company_list, "company_id", "company_name", "전체");
#endregion
price_service = new PriceService();
pricelist = price_service.GetPriceInfo("COOPERATIVE");
dgvMUPM.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvMUPM.Columns.Add("Number", "No.");
dgvMUPM.Columns[0].Width = 53;
dgvMUPM.Columns[0].Visible = false;
#region DGV바인딩
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "업체", "company_code", true, 170, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "업체명", "company_name", true, 200, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "품목", "product_codename", true, 180, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "품명", "product_name", true, 240, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "단위", "product_unit", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "현재단가", "price_present", true, 150, DataGridViewContentAlignment.MiddleRight, true);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "이전단가", "price_past", true, 150, DataGridViewContentAlignment.MiddleRight, true);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "시작일", "price_sdate", true, 150, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "종료일", "price_edate", true, 150, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "비고", "price_comment", true, 170, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dgvMUPM, "사용유무", "price_yn", true, 100, DataGridViewContentAlignment.MiddleCenter);
#endregion
GridViewUtil.SetDataGridView(dgvMUPM);
dgvMUPM.AutoGenerateColumns = false;
dgvMUPM.DataSource = pricelist;
}
private void SetDataGridCompany()
{
dgvCompany.Columns.Clear();
GridViewUtil.SetDataGridView(dgvCompany);
dgvCompany.AutoGenerateColumns = false;
//DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
//chk.HeaderText = "선택";
//chk.Name = "chk";
//chk.Width = 40;
//dgvCompany.Columns.Add(chk);
//Point headerLocation = dgvCompany.GetCellDisplayRectangle(0, -1, true).Location;
//headerCheckBox2.Location = new Point(headerLocation.X + 8, headerLocation.Y + 2); //그냥 이렇게 주면 위치가 썩 이쁘지않아서 숫자 좀 더 플러스함
//headerCheckBox2.BackColor = Color.White;
//headerCheckBox2.Size = new Size(18, 18);
//headerCheckBox2.Click += new EventHandler(HeaderCheckbox_Click2);
//dgvCompany.Controls.Add(headerCheckBox2);
//GridCheckBox(dgvCompany);
//GridViewUtil.AddNewColumnToDataGridView(dgvCompany, "No.", "count", true, 30);
GridViewUtil.AddNewColumnToDataGridView(dgvCompany, "발주업체", "company_name", true);
GridViewUtil.AddNewColumnToDataGridView(dgvCompany, "업체코드", "company_order_code", true, 78);
}
private void SetDataGrid()
{
dataGridView1.Columns.Clear();
GridViewUtil.SetDataGridView(dataGridView1);
dataGridView1.AutoGenerateColumns = false;
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "고객WO", "so_wo_id", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "고객사코드", "company_code", true, 130);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "고객사명", "company_name", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "도착지코드", "company_code", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "도착지명", "company_name", true, 150);
//GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "고객주문유형", "", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목", "product_codename", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품명", "product_name", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "등록일", "so_sdate", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "생산납기일", "so_edate", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "주문수량", "so_pcount", true, 150, DataGridViewContentAlignment.MiddleRight, true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "출고수량", "so_ocount", true, 150, DataGridViewContentAlignment.MiddleRight, true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "취소수량", "so_ccount", true, 150, DataGridViewContentAlignment.MiddleRight, true);
//GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "발주구분", "", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "비고", "so_comment", true, 150);
//GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "수정자", "so_uadmin", true, 150);
//GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "수정일", "so_udate", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "so_id", "so_id", false, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "plan_id", "plan_id", false, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "company_type", "company_type", false, 150);
}
private void SetDataGridResult()
{
dgvResult.Columns.Clear();
GridViewUtil.SetDataGridView(dgvResult);
dgvResult.AutoGenerateColumns = false;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "";
chk.Name = "chk";
chk.Width = 30;
dgvResult.Columns.Add(chk);
Point headerLocation = dgvResult.GetCellDisplayRectangle(0, -1, true).Location;
headerCheckBox2.Location = new Point(headerLocation.X + 8, headerLocation.Y + 2); //그냥 이렇게 주면 위치가 썩 이쁘지않아서 숫자 좀 더 플러스함
headerCheckBox2.BackColor = Color.White;
headerCheckBox2.Size = new Size(18, 18);
headerCheckBox2.Click += new EventHandler(HeaderCheckbox_Click2);
dgvResult.Controls.Add(headerCheckBox2);
GridViewUtil.AddNewColumnToDataGridView(dgvResult, "발주시리얼", "order_serial", true, 110);
GridViewUtil.AddNewColumnToDataGridView(dgvResult, "발주일자", "order_ddate", true, 200);
GridViewUtil.AddNewColumnToDataGridView(dgvResult, "발주업체", "company_name", true, 200);
GridViewUtil.AddNewColumnToDataGridView(dgvResult, "품목", "product_codename", true, 200);
GridViewUtil.AddNewColumnToDataGridView(dgvResult, "품명", "product_name", true, 200);
GridViewUtil.AddNewColumnToDataGridView(dgvResult, "발주량", "order_count", true, 200);
GridViewUtil.AddNewColumnToTextBoxGridView(dgvResult, "입고일자", "order_pdate", true, 200);
GridViewUtil.AddNewColumnToTextBoxGridView(dgvResult, "출발일", "order_sdate", true, 200);
GridViewUtil.AddNewColumnToDataGridView(dgvResult, "주문상태", "common_name", true, 200);
}
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 SetDataGrid()
{
dataGridView1.Columns.Clear();
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "날짜", "date", true);
//GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "수량", "", true, 130);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "수량", "", true, 130);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "주중/주말", "plan_type", false, 130);
}
private void btnSearch_Click(object sender, EventArgs e)
{
dataGridView1.DataSource = null;
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비", "m_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "공정", "bor_route", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "상품코드", "product_codename", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "상품명", "producct_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "영업마스터ID", "plan_id", false);
string Machine = cboMachine.Text;
DataTable dt = service.GetProductPlan(cboPlanID.Text, dateTimePicker1.Value.ToShortDateString(), dateTimePicker2.Value.ToShortDateString());
DataTable table = new DataTable();
try
{
//if (Machine == "전체" && txtProduct.Text == "") //둘다 빈값
//{
// dataGridView1.DataSource = dt;
//}
if (txtProduct.Text == "" && Machine == "전체") // 둘다 빈값
{
dataGridView1.DataSource = dt;
}
else if (txtProduct.Text != "" && Machine == "전체") //product만 입력
{
table =
dt.AsEnumerable().Where(Row =>
Row.Field <string>("product_codename") == txtProduct.Text).CopyToDataTable();
dataGridView1.DataSource = table;
}
else if (Machine != "" && txtProduct.Text == "") //설비만 입력
{
table =
dt.AsEnumerable().Where(Row =>
Row.Field <string>("m_name") == cboMachine.Text).CopyToDataTable();
dataGridView1.DataSource = table;
}
else if (Machine != "" && txtProduct.Text != "") //둘다 입력
{
table =
dt.AsEnumerable().Where(Row =>
Row.Field <string>("m_name") == cboMachine.Text && Row.Field <string>("product_codename") == txtProduct.Text).CopyToDataTable();
dataGridView1.DataSource = table;
}
dataGridView1.ClearSelection();
}
catch (InvalidOperationException)
{
SetBottomStatusLabel("해당 조건의 검색결과가 없습니다");
MessageBox.Show("해당 조건의 검색결과가 없습니다");
}
catch (Exception err)
{
string str = err.Message;
}
}
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 LoadDGV()
{
dgvProductList.RowHeadersVisible = false;
//품목 가져오기
ProductService product_service = new ProductService();
List <ProductVO> list = product_service.GetAllProducts();
ProductVO vo = new ProductVO();
dgvProductList.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvProductList.Columns.Add("Number", "No.");
dgvProductList.Columns[0].Width = 53;
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "품목유형", "product_type", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "품목", "product_codename", true, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "품명", "product_name", true, 220);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "단위", "product_unit", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "단위수량", "product_unit_count", true, 100, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "발주방식", "product_ordertype", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "최소발주수량", "product_lorder_count", true, 130, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "안전재고수량", "product_safety_count", true, 130, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "사용여부", "product_yn", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "담당자", "product_admin", true, 100);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "입고창고", "product_in_sector", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "출고창고", "product_out", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "납품업체", "product_supply_com", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "발주업체", "product_demand_com", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "측정방식", "product_meastype", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "LeadTime", "product_leadtime", true, 100, DataGridViewContentAlignment.MiddleRight);
#region visible_false
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "최솟값", "product_lsl", false, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "최댓값", "product_usl", false, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "아이템코드", "product_itemcode", false, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "품번", "product_id", false, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "품명코드", "product_code", false, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "수정일", "product_udate", false, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvProductList, "비고", "product_comment", false, 130);
#endregion
//dgvProductList.Columns[0].SortMode = DataGridViewColumnSortMode.Automatic;
GridViewUtil.SetDataGridView(dgvProductList);
dgvProductList.AutoGenerateColumns = false;
dgvProductList.DataSource = list;
}
private void dgvColumnSet()
{
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "ID", "bor_id", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "bom_id", "bom_id", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품명", "product_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목", "product_codename", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "공정", "common_type", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "공정명", "common_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비", "m_code", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비명", "m_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "Tack Time", "bor_tacktime", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "공정선행시간", "bor_readytime", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "사용유무", "bor_yn", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "비고", "bor_comment", true);
}
private void SetDataGrid()
{
dataGridView1.Columns.Clear();
GridViewUtil.SetDataGridView(dataGridView1);
dataGridView1.AutoGenerateColumns = false;
//GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "No.", "count", true, 100);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "창고코드", "factory_code", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "창고", "factory_name", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목", "product_codename", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품명", "product_name", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목유형", "product_type", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "재고량", "w_count_present", true, 150);
GridViewUtil.SetDoNotSort(dataGridView1);
}
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 SetDataGrid()
{
dataGridView1.Columns.Clear();
GridViewUtil.SetDataGridView(dataGridView1);
dataGridView1.AutoGenerateColumns = false;
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "HISTORY 번호", "wh_id", false, 110);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "창고번호", "w_id", false, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "제품번호", "product_id", false, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "Plan ID", "plan_id", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품명", "product_name", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목", "product_codename", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "수량", "wh_product_count", true, 150);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "수정일", "wh_udate", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "잔량", "wh_comment", false, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "카테고리", "common_name", true, 150);
}
//데이터그리드뷰 칼럼 세팅
private void SetDataGrid()
{
dataGridView1.Columns.Clear();
dataGridView1.RowsDefaultCellStyle.BackColor = Color.FromArgb(240, 240, 240);
dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.White;
dataGridView1.DefaultCellStyle.SelectionBackColor = Color.Gray; //Color.DimGray;
dataGridView1.DefaultCellStyle.SelectionForeColor = Color.White;
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "planDate", "", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "순번", "", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "WORK_ORDER_ID", "", true, 130);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "업체코드", "", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "납품처", "", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "입고P/NO", "", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품명", "", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "계획수량합계", "", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "납기일", "", true);
}
private void facilityMgt_Load(object sender, EventArgs e)
{
dataGridView1.RowHeadersVisible = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView2.RowHeadersVisible = false;
dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "ID", "mgrade_id", false, 60);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비군 코드", "mgrade_code", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "설비군명", "mgrade_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "사용유무", "mgrade_yn", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "수정자", "mgrade_uadmin", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "수정시간", "mgrade_udate", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "시설설명", "mgrade_comment", false);
GridViewUtil.SetDataGridView(dataGridView1);
dataGridView2.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "ID", "m_id", false, 60);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "설비ID", "mgrade_id", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "설비군코드", "mgrade_code", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "설비코드", "m_code", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "설비명", "m_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "소진창고", "m_use_sector", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "양품창고", "m_ok_sector", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "불량창고", "m_ng_sector", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "외주여부", "m_os_yn", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "특이사항", "m_check", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "비고", "m_comment", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "사용유무", "m_yn", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "수정자", "m_uadmin", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "수정시간", "m_udate", true);
GridViewUtil.SetDataGridView(dataGridView2);
R_service = new ResourceService();
LoadData();
dataGridView1.ClearSelection();
dataGridView2.ClearSelection();
}
private void LoadDGV()
{
BomService service = new BomService();
BOM_list = service.GetBomAll();
dgvBom.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvBom.Columns.Add("Number", "No.");
dgvBom.Columns[0].Width = 53;
dgvBom.Columns[0].Visible = false;
#region DGV바인딩
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "품목유형", "bom_type", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "품목", "bom_codename", true, 150, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "품명", "bom_name", true, 220);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "단위", "bom_unit", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "사용여부", "bom_yn", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "소요계획", "plan_yn", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "시작일", "bom_sdate", true, 130, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "종료일", "bom_edate", true, 130, DataGridViewContentAlignment.MiddleRight);
//GridViewUtil.AddNewColumnToDataGridView(dgvBom, "수정자", "bom_uadmin", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "수정일", "bom_udate", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "비고", "bom_comment", true, 150, DataGridViewContentAlignment.MiddleLeft);
#endregion
#region visible_false
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "품번", "product_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "BOM레벨", "bom_level", false, 80, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "소요량", "bom_use_count", false, 80, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "BomID", "bom_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "상위품목", "bom_parent_id", false, 130);
#endregion
GridViewUtil.SetDataGridView(dgvBom);
dgvBom.AutoGenerateColumns = false;
dgvBom.DataSource = BOM_list;
dgvBom.ClearSelection();
}
private void businessMgt_Load(object sender, EventArgs e)
{
dataGridView2.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업체ID", "company_id", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업체코드", "company_code", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업체명", "company_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업체타입", "common_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업체타입", "company_type", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "대표자명", "company_ceo", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "사업자등록번호", "company_cnum", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업종", "company_btype", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업태", "company_gtype", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "담당자", "user_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "담당자id", "user_id", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "이메일", "company_email", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "전화번호", "company_phone", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "팩스", "company_fax", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "수정자", "company_uadmin", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "수정시간", "company_udate", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업체정보", "company_comment", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "사용유무", "company_yn", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "업체발주코드", "company_order_code", false);
GridViewUtil.SetDataGridView(dataGridView2);
LoadData();
common_service = new CommonCodeService();
common_list = common_service.GetCommonCodeAll();
{
//사용유무
var mCode = (from item in common_list
where item.common_type == "vendor_type"
select item).ToList();
ComboUtil.ComboBinding <CommonVO>(cboTypeCompany, mCode, "common_value", "common_name", "미선택");
}
}
private void dgvBom_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
dgvBomDetail.DataSource = null;
dgvBomDetail.Columns.Clear();
//dgvBom[11, dgvBom.CurrentRow.Index].Value.ToString()
bom_service = new BomService();
List <BomVO> bomDetail = bom_service.GetBomAll(Convert.ToInt32(dgvBom[11, dgvBom.CurrentRow.Index].Value));
dgvBomDetail.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvBomDetail.Columns.Add("Number", "No.");
dgvBomDetail.Columns[0].Width = 53;
dgvBomDetail.Columns[0].Visible = false;
#region DGV바인딩
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "상위품목", "bom_parent_codename", true, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "품목", "bom_codename", true, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "품명", "bom_name", true, 220);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "품목유형", "bom_type", true, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "단위", "bom_unit", true, 78, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "소요량", "bom_use_count", true, 80, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "BOM레벨", "bom_level", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "시작일", "bom_sdate", true, 130, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "종료일", "bom_edate", true, 130, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "사용여부", "bom_yn", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "소요계획", "plan_yn", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "수정자", "bom_uadmin", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "수정일", "bom_udate", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "비고", "bom_comment", true, 130, DataGridViewContentAlignment.MiddleCenter);
#endregion
#region visible_false
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "품번", "product_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "BomID", "bom_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
#endregion
dgvBomDetail.AutoGenerateColumns = false;
dgvBomDetail.DataSource = bomDetail;
dgvBomDetail.ClearSelection();
}
private void BOR_Load(object sender, EventArgs e)
{
this.ImeMode = ImeMode.Hangul;
GridViewUtil.SetDataGridView(dataGridView1);
dgvColumnSet();
LoadData();
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; // 셀 클릭하면 행 전체가 선택
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>(cboProcess, mCode, "common_value", "common_name", "미선택");
}
}
private void SetDataGrid()
{
dataGridView1.Columns.Clear();
GridViewUtil.SetDataGridView(dataGridView1);
dataGridView1.AutoGenerateColumns = false;
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "입출고일", "wh_udate", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "번호", "wh_id", true, 100);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "카테고리", "wh_category", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "창고", "factory_name", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목", "product_codename", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품명", "product_name", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목형태", "product_type", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "발주시리얼", "order_id", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "수량", "wh_product_count", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "단가", "price_present", true, 150, DataGridViewContentAlignment.MiddleRight, true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "금액", "totalprice", true, 150, DataGridViewContentAlignment.MiddleRight, true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "비고", "wh_comment", true, 150);
GridViewUtil.SetDoNotSort(dataGridView1);
}
private void SetDataGrid()
{
dataGridView1.Columns.Clear();
GridViewUtil.SetDataGridView(dataGridView1);
dataGridView1.AutoGenerateColumns = false;
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "고객WO", "so_wo_id", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "고객사코드", "company_code", true, 130);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "고객사명", "company_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "도착지코드", "company_code", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "도착지명", "company_name", true);
//GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "고객주문유형", "", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목", "product_codename", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품명", "product_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "등록일", "so_sdate", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "생산납기일", "so_edate", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "주문수량", "so_pcount", true);
//GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "발주구분", "", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "so_id", "so_id", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "plan_id", "plan_id", false);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "company_type", "company_type", false);
}
private void SetDataGrid()
{
dataGridView1.Columns.Clear();
GridViewUtil.SetDataGridView(dataGridView1);
dataGridView1.AutoGenerateColumns = false;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "선택";
chk.Name = "chk";
chk.Width = 45;
dataGridView1.Columns.Add(chk);
//Point headerLocation = dataGridView1.GetCellDisplayRectangle(0, -1, true).Location;
//headerCheckBox.Location = new Point(headerLocation.X + 8, headerLocation.Y + 2); //그냥 이렇게 주면 위치가 썩 이쁘지않아서 숫자 좀 더 플러스함
//headerCheckBox.BackColor = Color.White;
//headerCheckBox.Size = new Size(18, 18);
//headerCheckBox.Click += new EventHandler(HeaderCheckbox_Click);
//dataGridView1.Controls.Add(headerCheckBox);
//GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "No.", "count", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "발주시리얼", "order_serial", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "PlanID", "plan_id", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "납품업체", "company_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "주문상태", "common_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목", "product_codename", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품명", "product_name", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "납기일", "order_pdate", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "발주량", "order_count", true);
//GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "입고량", "", true);
//GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "출발량", "company_order_code", true);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "취소량", "", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "취소가능량", "order_count", true);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "발주일", "order_ddate", true);
}
private void SetDataGrid()
{
dataGridView1.Columns.Clear();
GridViewUtil.SetDataGridView(dataGridView1);
dataGridView1.AutoGenerateColumns = false;
DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
chk.HeaderText = "선택";
chk.Name = "chk";
chk.Width = 40;
dataGridView1.Columns.Add(chk);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "발주시리얼", "order_serial", true, 110);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "입고일", "order_pdate", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "입고창고", "factory_name", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품목", "product_codename", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "품명", "product_name", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "입고량", "order_qcount", true, 150);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView1, "취소량", "", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "잔량", "order_qcount", true, 150);
GridViewUtil.AddNewColumnToDataGridView(dataGridView1, "업체", "company_name", true, 150);
}
private void dgvResult_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
GridViewUtil.SetDgvTextBoxColor(dgvResult, 7);
GridViewUtil.SetDgvTextBoxColor(dgvResult, 8);
}
private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
GridViewUtil.SetDgvTextBoxColor(dataGridView1, 7);
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
dataGridView2.DataSource = null;
dataGridView2.Columns.Clear();
dataGridView2.DataSource = null;
ndt = null;
List <DMRVO> lst = new List <DMRVO>();
ProcessService P_service = new ProcessService();
DMRVO vo = new DMRVO();
try
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (Convert.ToBoolean(dataGridView1.Rows[i].Cells[0].Value) == true) //체크박스가 true?
{
vo.product_codename = dataGridView1.Rows[i].Cells[9].Value.ToString(); //제품코드네임
vo.factory_name = dataGridView1.Rows[i].Cells[11].Value.ToString(); //창고명
vo.pro_id = Convert.ToInt32(dataGridView1.Rows[i].Cells[1].Value.ToString()); //pro_id
vo.plan_id = dataGridView1.Rows[i].Cells[2].Value.ToString(); //plan_id
if (P_service.GetDMRMgt(vo).Count >= 5)
{
lst = (P_service.GetDMRMgt(vo));
}
}
}
for (int i = 0; i < lst.Count; i++)
{
lst[i].req_date = DateTime.Now.ToShortDateString();
}
// lst = P_service.GetDMRMgt(vo);
//dt = P_service.GetProductionPlanCheckHis(dateTimePicker1.Value.ToShortDateString(), dateTimePicker2.Value.ToShortDateString());
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "pro_id", "pro_id", false, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "플랜id", "plan_id", false, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "product_id", "product_id", false, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "제품코드명", "product_codename", true, 100, DataGridViewContentAlignment.MiddleLeft); //f
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "제품명", "product_name", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "", "factory_id", false, 100, DataGridViewContentAlignment.MiddleLeft); //
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "창고명", "factory_name", true, 100, DataGridViewContentAlignment.MiddleLeft); //ff
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "계획수량", "pro_count", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "소요량", "bom_use_count", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "소요수량", "plan_count", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "자재창고 재고", "w_count_present", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "이전재고", "w_count_past", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "요청창고id", "req_factory_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "요청창고", "req_factory", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "요청창고 재고", "nam", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "요청량", "req_count", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToTextBoxGridView(dataGridView2, "사유", "reason", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "요청일", "req_date", true, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "w_id", "w_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
GridViewUtil.AddNewColumnToDataGridView(dataGridView2, "", "order_id", false, 100, DataGridViewContentAlignment.MiddleLeft);
dataGridView2.RowsDefaultCellStyle.BackColor = Color.FromArgb(240, 240, 240);
dataGridView2.AlternatingRowsDefaultCellStyle.BackColor = Color.White;
dataGridView2.DefaultCellStyle.SelectionBackColor = Color.Gray; //Color.DimGray;
dataGridView2.DefaultCellStyle.SelectionForeColor = Color.White;
dataGridView2.DataSource = lst;
}
catch (Exception err)
{
string st = err.Message;
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void dgvBomDetail_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
foreach (DataGridViewRow row in this.dgvBomDetail.SelectedRows)
{
BomVO vo = new BomVO();
vo = row.DataBoundItem as BomVO;
if (vo.bom_typevalue == "RM")
{
BomPop frm = new BomPop(BomPop.EditMode.Update, vo);
if (frm.ShowDialog() == DialogResult.OK)
{
bom_service = new BomService();
List <BomVO> newBOMlist = bom_service.GetBomAll(); //등록후 다시 조회
dgvBom.DataSource = newBOMlist;
dgvBom.ClearSelection();
SetBottomStatusLabel("BOM 수정이 완료되었습니다.");
}
SetBottomStatusLabel("원자재는 선택할 수 없습니다.");
return;
}
}
int product_id = Convert.ToInt32(dgvBomDetail[15, dgvBomDetail.CurrentRow.Index].Value);
bom_service = new BomService();
List <BomVO> newBom = bom_service.GetBomAll(0, product_id);
dgvBom.DataSource = null;
dgvBom.Columns.Clear();
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "품목유형", "bom_type", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "품목", "bom_codename", true, 150, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "품명", "bom_parent_name", true, 220);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "단위", "bom_unit", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "사용여부", "bom_yn", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "소요계획", "plan_yn", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "시작일", "bom_sdate", true, 130, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "종료일", "bom_edate", true, 130, DataGridViewContentAlignment.MiddleRight);
//GridViewUtil.AddNewColumnToDataGridView(dgvBom, "수정자", "bom_uadmin", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "수정일", "bom_udate", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "비고", "bom_comment", true, 150, DataGridViewContentAlignment.MiddleLeft);
#region visible_false
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "품번", "product_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "BOM레벨", "bom_level", false, 80, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "소요량", "bom_use_count", false, 80, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "BomID", "bom_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBom, "상위품목", "bom_parent_id", false, 130);
#endregion
dgvBom.AutoGenerateColumns = false;
dgvBom.DataSource = newBom;
dgvBom.ClearSelection();
int bom_id = Convert.ToInt32(dgvBomDetail[15, dgvBomDetail.CurrentRow.Index].Value);
List <BomVO> newBomDetail = bom_service.GetBomAll(0, bom_id);
dgvBomDetail.DataSource = null;
dgvBomDetail.Columns.Clear();
dgvBomDetail.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dgvBomDetail.Columns.Add("Number", "No.");
dgvBomDetail.Columns[0].Width = 53;
dgvBomDetail.Columns[0].Visible = false;
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "상위품목", "bom_parent_name", true, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "품목", "bom_codename", true, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "품명", "bom_name", true, 220);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "품목유형", "bom_type", true, 130);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "단위", "bom_unit", true, 78, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "소요량", "bom_use_count", true, 80, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "BOM레벨", "bom_level", true, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "시작일", "bom_sdate", true, 130, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "종료일", "bom_edate", true, 130, DataGridViewContentAlignment.MiddleRight);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "사용여부", "bom_yn", true, 120, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "소요계획", "plan_yn", true, 120, DataGridViewContentAlignment.MiddleCenter);
//GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "수정자", "bom_uadmin", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "수정일", "bom_udate", true, 130, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "비고", "bom_comment", true, 130, DataGridViewContentAlignment.MiddleCenter);
#region visible_false
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "품번", "product_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
GridViewUtil.AddNewColumnToDataGridView(dgvBomDetail, "BomID", "bom_id", false, 100, DataGridViewContentAlignment.MiddleCenter);
#endregion
dgvBomDetail.AutoGenerateColumns = false;
dgvBomDetail.DataSource = newBomDetail;
dgvBomDetail.ClearSelection();
SetBottomStatusLabel("BOM을 선택하세요");
}
