private void btnSearch_Click(object sender, EventArgs e)
{
//조회버튼
try
{
MaterialStockVO vo = new MaterialStockVO();
if (txtProductCode.Text != "")
{
vo.product_codename = txtProductCode.Text;
}
if (cboProductType.Text != "선택")
{
vo.product_type = cboProductType.Text;
}
if (cboFactory.Text != "선택")
{
vo.factory_code = cboFactory.SelectedValue.ToString();
}
StockService service = new StockService();
DataTable dt = service.GetMaterialStockList(vo);
SetDataGrid();
dataGridView1.DataSource = dt;
// SetRowNumber();
//dataGridView1.Columns[6].DefaultCellStyle.BackColor = Color.Red;
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void MaterialReceiving_Load(object sender, EventArgs e)
{
dtpStartDate.Value = DateTime.Now;
dtpEndDate.Value = DateTime.Now.AddMonths(+1);
//발주업체, 주문상태 콤보박스 바인딩
OrderService oService = new OrderService();
MaterialLedgerService mService = new MaterialLedgerService();
CompanyList = new List <CompanyVO>();
orderStateList = new List <OrderStateVO>();
try
{
CompanyList = oService.GetCompanyAll("customer");
ComboUtil.ComboBinding(cboCompany, CompanyList, "company_code", "company_name", "선택");
orderStateList = mService.GetOrderState();
ComboUtil.ComboBinding(cboOrderState, orderStateList, "state_code", "state_name", "선택");
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
SetDataGridWatingReceiving();
SetDataGridResult();
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex > 0)
{
return;
}
try
{
int p_id = Convert.ToInt32(dataGridView1.CurrentRow.Cells[1].Value);
bool bresult = !Convert.ToBoolean(dataGridView1.CurrentRow.Cells[0].EditedFormattedValue);
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (Convert.ToInt32(dataGridView1.Rows[i].Cells[1].Value) == p_id)
{
dataGridView1.Rows[i].Cells[0].Value = bresult;
}
else
{
if (bresult)
{
dataGridView1.Rows[i].Cells[0].Value = !bresult;
}
}
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
//조회 버튼
try
{
SupplierVO vo = new SupplierVO();
vo.order_state = "O_COMPLETE";
vo.start_date = dtpStartDate.Value.ToShortDateString();
vo.end_date = dtpEndDate.Value.ToShortDateString();
if (cboCompany.Text != "선택")
{
vo.company_name = cboCompany.Text;
}
if (txtOrderID.Text != "")
{
vo.order_id = txtOrderID.Text;
}
SetDataGridWatingReceiving();
SetDataGridResult();
SupplierService service = new SupplierService();
dt = service.GetAlreadyOrderList(vo);
dgvWatingReceive.DataSource = dt;
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void btnG_Update_Click(object sender, EventArgs e)
{
try
{
MachineGradeVO VO = new MachineGradeVO();
VO.mgrade_id = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value);
VO.mgrade_code = dataGridView1.CurrentRow.Cells[1].Value.ToString();
VO.mgrade_name = dataGridView1.CurrentRow.Cells[2].Value.ToString();
VO.mgrade_yn = dataGridView1.CurrentRow.Cells[3].Value.ToString();
VO.mgrade_uadmin = dataGridView1.CurrentRow.Cells[4].Value.ToString();
VO.mgrade_udate = dataGridView1.CurrentRow.Cells[5].Value.ToString();
VO.mgrade_comment = dataGridView1.CurrentRow.Cells[6].Value.ToString();
FacilitiesPop frm = new FacilitiesPop(FacilitiesPop.EditMode.Update, VO);
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
SetBottomStatusLabel("설비군 수정 성공");
}
txtCode.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString();
txtName.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString();
txtAdmin.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString();
txtDate.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString();
txtComment.Text = dataGridView1.CurrentRow.Cells[6].Value.ToString();
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
DialogResult dr = MessageBox.Show(dataGridView2.CurrentRow.Cells[4].Value.ToString() + " 를(을) 삭제하시겠습니까?", "알림", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (dr == DialogResult.OK)
{
bool bResult = R_service.DeleteMachin(Convert.ToInt32(lblID2.Text));
if (bResult)
{
MessageBox.Show("삭제완료");
SetBottomStatusLabel("삭제 성공");
LoadData();
}
else if (!bResult)
{
MessageBox.Show("삭제 실패");
SetBottomStatusLabel("삭제 실패");
return;
}
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void btnWork_Click(object sender, EventArgs e)
{
try
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (Convert.ToBoolean(dataGridView1.Rows[i].Cells[0].Value) == true) //체크박스가 true?
{
lst.Add(Convert.ToInt32(dataGridView1.Rows[i].Cells[12].Value.ToString())); //true인 행의 아이디를 가져옴
strlist.Add(dataGridView1.Rows[i].Cells[10].Value.ToString());
}
}
int k = lst.Count;
lst = lst.Distinct().ToList(); //중복제거
int t = lst.Count;
strlist = strlist.Distinct().ToList();
//bool bResult = false;
for (int i = 0; i < strlist.Count; i++)
{
/* bResult =*/
P_service.UpdateCommand(Convert.ToInt32(lst[i].ToString()), strlist[i].ToString());
}
//if (bResult)
LoadData();
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//변경버튼
if (MessageBox.Show($"\"{dtpTobeDate.Value.ToShortDateString()}\"으로 변경하시겠습니까?", "날짜변경", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
vo.order_pdate = dtpTobeDate.Value.ToShortDateString();
try
{
PurchasingService service = new PurchasingService();
bool result = service.UpdateOrderDate(vo);
if (result)
{
MessageBox.Show("납기일이 성공적으로 변경되었습니다.", "날짜변경", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("납기일 변경에 실패하였습니다.", "날짜변경", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
else
{
return;
}
}
private void ExcelDown()
{
try
{
Excel.Application excel = new Excel.Application
{
Visible = true
};
string filename = "test" + ".xlsx";
string tempPath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Desktop), filename);
//byte[] temp = Properties.Resources.order;
//System.IO.File.WriteAllBytes(tempPath, temp);
Excel._Workbook workbook;
workbook = excel.Workbooks.Add(System.Reflection.Missing.Value);//tempPath
Excel.Worksheet sheet1 = (Excel.Worksheet)workbook.Sheets[1];
int StartCol = 1;
int StartRow = 1;
int j = 0, i = 0;
//Write Headers
for (j = 0; j < dataGridView1.Columns.Count - 3; j++)
{
Excel.Range myRange = (Excel.Range)sheet1.Cells[StartRow, StartCol + j];
myRange.Value2 = dataGridView1.Columns[j].HeaderText;
}
StartRow++;
//Write datagridview content
for (i = 0; i < dataGridView1.Rows.Count; i++)
{
for (j = 0; j < dataGridView1.Columns.Count - 3; j++)
{
try
{
Excel.Range myRange = (Excel.Range)sheet1.Cells[StartRow + i, StartCol + j];
myRange.Value2 = dataGridView1[j, i].Value == null ? "" : dataGridView1[j, i].Value;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
}
SetBottomStatusLabel("다운로드가 완료되었습니다.");
}
catch (Exception ex)
{
LoggingUtility.GetLoggingUtility(ex.Message, Level.Error);
SetBottomStatusLabel("다운로드에 실패하였습니다.");
}
}
private void BtnSearch_Click(object sender, EventArgs e)
{
try
{
MaterialSearchVO vo = new MaterialSearchVO();
vo.startDate = dtpStartDate.Value.ToShortDateString();
vo.endDate = dtpEndDate.Value.ToShortDateString();
if (cboFactory.Text != "선택")
{
vo.factory_name = cboFactory.Text;
}
if (cboProductType.Text != "선택")
{
vo.product_type = cboProductType.Text;
}
if (txtProduct.Text != "")
{
vo.product_name = txtProduct.Text;
}
StockService service = new StockService();
DataTable dt = service.GetInOutHistory(vo);
SetDataGrid();
dataGridView1.DataSource = dt;
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void btnDel_Click(object sender, EventArgs e)
{
ResourceService R_service = new ResourceService();
try
{
DialogResult dr = MessageBox.Show(dataGridView1.CurrentRow.Cells[2].Value.ToString() + " 를(을) 삭제하시겠습니까?", "알림", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (dr == DialogResult.OK)
{
R_service = new ResourceService();
bool bResult = R_service.DeleteBOR(Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value));
if (bResult)
{
LoadData();
SetBottomStatusLabel("삭제완료");
MessageBox.Show("삭제완료");
}
else if (!bResult)
{
SetBottomStatusLabel("삭제실패");
MessageBox.Show("삭제 실패");
return;
}
}
}
catch (Exception err)
{
string str = err.Message;
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void OrderList_Load(object sender, EventArgs e)
{
dtpStartDate.Value = DateTime.Now;
dtpEndDate.Value = DateTime.Now.AddMonths(+1);
OrderService service = new OrderService();
//발주업체 콤보박스 바인딩
CompanyList = new List <CompanyVO>();
try
{
CompanyList = service.GetCompanyAll("customer");
ComboUtil.ComboBinding(cboCompany, CompanyList, "company_code", "company_name", "선택");
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
//PurchasingService service = new PurchasingService();
//dt = service.GetOrderList();
SetDataGrid();
//SetRowNumber();
}
private void btnSearch_Click(object sender, EventArgs e)
{
//조회 버튼
WhereSoVO vo = new WhereSoVO();
vo.startDate = dtpStartDate.Value.ToShortDateString();
vo.endDate = dtpEndDate.Value.ToShortDateString();
vo.RegStartDate = dtpRegFirstDate.Value.ToShortDateString();
vo.RegEndDate = dtpRegLastDate.Value.ToShortDateString();
if (cboCompany.Text != "선택")
{
vo.CompanyName = cboCompany.Text;
}
OrderService service = new OrderService();
try
{
List <SOMasterVO> list = service.GetSOMasterAll(vo);
dataGridView1.DataSource = list;
SetBottomStatusLabel("조회가 완료되었습니다.");
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
SetBottomStatusLabel("조회에 실패하였습니다. 다시 시도하여 주십시오.");
}
}
private void BtnSearch_Click(object sender, EventArgs e)
{
dataGridView1.Columns.Clear();
string planID = cboPlanID.Text;
try
{
OrderService service = new OrderService();
DataTable dt = service.GetMRP(planID, dtpStartDate.Value.ToShortDateString(), dtpEndDate.Value.ToShortDateString());
dt.Columns[0].ColumnName = "품목";
dt.Columns[1].ColumnName = "품명";
dt.Columns[2].ColumnName = "Plan ID";
dt.Columns[3].ColumnName = "카테고리";
dt.Columns[4].ColumnMapping = MappingType.Hidden;
dt.Columns[5].ColumnMapping = MappingType.Hidden;
dataGridView1.DataSource = dt;
//GridViewUtil.SetDataGridView(dataGridView1);
SetBottomStatusLabel("조회가 완료되었습니다.");
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void MRP_Load(object sender, EventArgs e)
{
try
{
OrderService service = new OrderService();
List <string> planIDlist = service.GetPlanID();
cboPlanID.DataSource = planIDlist;
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
//string planID = cboPlanID.Text;
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;
dtpStartDate.Value = DateTime.Now;
dtpEndDate.Value = DateTime.Now.AddMonths(+1).AddDays(-1);
//dataGridView1.DataSource = service.GetMRP(planID, dtpStartDate.Value.ToShortDateString(), dtpEndDate.Value.ToShortDateString());
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (lblID.Text != "")
{
BORPop frm = new BORPop(BORPop.EditMode.Update, lblID.Text, lblRoute.Text);
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
SetBottomStatusLabel("수정 성공");
MessageBox.Show("수정 성공");
}
}
else
{
SetBottomStatusLabel("선택된 BOR이 없습니다");
MessageBox.Show("선택된 BOR이 없습니다.");
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (lblID1.Text != "")
{
FacilitieInfoPop frm = new FacilitieInfoPop
(FacilitieInfoPop.EditMode.Input, dataGridView1.CurrentRow.Cells[1].Value.ToString(), lblID1.Text);
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
SetBottomStatusLabel("신규 설비 등록 성공");
}
}
else if (lblID1.Text == "")
{
MessageBox.Show("설비군을 선택해주세요");
}
SetBottomStatusLabel("선택된 설비군이 없습니다");
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
//조회 버튼
try
{
SupplierVO vo = new SupplierVO();
vo.start_date = dtpStartDate.Value.ToShortDateString();
vo.end_date = dtpEndDate.Value.ToShortDateString();
if (cboCompany.Text != "선택")
{
vo.company_name = cboCompany.Text;
}
if (cboOrderState.Text != "선택")
{
vo.order_state = cboOrderState.SelectedValue.ToString();
}
MaterialLedgerService service = new MaterialLedgerService();
dt = service.GetWatingReceivingList(vo);
dgvWatingList.DataSource = dt;
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void SalesMaster_Load(object sender, EventArgs e)
{
//납기일 초기화
dtpStartDate.Value = DateTime.Now;
dtpEndDate.Value = DateTime.Now.AddMonths(+1).AddDays(-1);
//등록일 초기화
dtpRegFirstDate.Value = DateTime.Now.AddMonths(-1);
dtpRegLastDate.Value = DateTime.Now;
OrderService service = new OrderService();
//List<SOMasterVO> list = service.GetSOMasterAll();
//고객사, 도착지 콤보박스 바인딩
CompanyList = new List <CompanyVO>();
try
{
//datagridview
SetDataGrid();
CompanyList = service.GetCompanyAll("cooperative");
ComboUtil.ComboBinding(cboCompany, CompanyList, "company_code", "company_name", "선택");
//DestinationList = new List<CompanyVO>();
//DestinationList = service.GetCompanyAll("cooperative");
//ComboUtil.ComboBinding(cboDestination, DestinationList, "company_code", "company_name", "선택");
//조회 버튼
WhereSoVO vo = new WhereSoVO();
vo.startDate = dtpStartDate.Value.ToShortDateString();
vo.endDate = dtpEndDate.Value.ToShortDateString();
vo.RegStartDate = dtpRegFirstDate.Value.ToShortDateString();
vo.RegEndDate = dtpRegLastDate.Value.ToShortDateString();
if (cboCompany.Text != "선택")
{
vo.CompanyName = cboCompany.Text;
}
try
{
List <SOMasterVO> list = service.GetSOMasterAll(vo);
dataGridView1.DataSource = list;
SetBottomStatusLabel("조회가 완료되었습니다.");
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
SetBottomStatusLabel("조회에 실패하였습니다. 다시 시도하여 주십시오.");
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count == 0)
{
MessageBox.Show("조회 버튼을 먼저 눌러주십시오.", "조회", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
OrderService service = new OrderService();
if (MessageBox.Show("수요계획을 생성하시겠습니까?", "수요계획생성", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
int resultRow = service.SearchPlanIDInDemand(cbOrderGubun.Text);
if (resultRow > 0)
{
MessageBox.Show("이미 생성된 수요계획이 있습니다.", "수요계획", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
List <DemandPlanVO> list = new List <DemandPlanVO>();
for (int i = 0; i < somasterList.Count; i++)
{
DemandPlanVO vo = new DemandPlanVO();
vo.plan_id = cbOrderGubun.Text;
vo.d_count = somasterList[i].so_pcount;
vo.d_date = somasterList[i].so_edate;
vo.so_id = somasterList[i].so_id;
list.Add(vo);
}
bool result = service.AddDemandPlan(list);
if (result)
{
MessageBox.Show("성공적으로 수요계획을 생성하였습니다.", "수요계획생성", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show("수요계획 생성에 실패하였습니다.", "수요계획생성실패", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
else
{
return;
}
}
//영업마스터 생성
private void btnCreatePO_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count < 1)
{
MessageBox.Show("파일 업로드는 필수입니다.", "파일 업로드", MessageBoxButtons.OK, MessageBoxIcon.Information);
SetBottomStatusLabel("파일 업로드는 필수입니다.");
}
else
{
if (MessageBox.Show("영업마스터를 생성하시겠습니까?", "영업마스터생성", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
List <SOMasterVO> list = new List <SOMasterVO>();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
SOMasterVO vo = new SOMasterVO();
vo.plan_id = versionName;
vo.so_wo_id = dataGridView1.Rows[i].Cells[2].Value.ToString();
vo.so_pcount = Convert.ToInt32(dataGridView1.Rows[i].Cells[7].Value);
vo.company_code = dataGridView1.Rows[i].Cells[3].Value.ToString();
vo.so_edate = dataGridView1.Rows[i].Cells[8].Value.ToString();
vo.so_sdate = dataGridView1.Rows[i].Cells[0].Value.ToString();
vo.product_name = dataGridView1.Rows[i].Cells[6].Value.ToString();
list.Add(vo);
}
//DB
OrderService service = new OrderService();
bool result = service.AddSOMaster(list);
if (result)
{
Form fc = Application.OpenForms["Main"];
Main frm = (Main)fc;
frm.CloseandOpenTab("영업마스터");
}
else
{
MessageBox.Show("영업마스터 생성에 실패하였습니다. 다시 시도하여주십시오.", "영업마스터 생성 실패", MessageBoxButtons.OK, MessageBoxIcon.Error);
SetBottomStatusLabel("영업마스터 생성에 실패하였습니다. 다시 시도하여주십시오.");
return;
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
else
{
return;
}
}
}
private void MaterialStockList_Load(object sender, EventArgs e)
{
StockService service = new StockService();
try
{
//품목유형 콤보박스 바인딩
List <CommonVO> productTypeList = new List <CommonVO>();
productTypeList = service.GetProductType("item_type");
ComboUtil.ComboBinding(cboProductType, productTypeList, "common_value", "common_name", "선택");
List <FactoryComboVO> factoryList = new List <FactoryComboVO>();
factoryList = service.GetFactory();
ComboUtil.ComboBinding(cboFactory, factoryList, "factory_code", "factory_name", "선택");
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
SetLoad();
SetDataGrid();
//조회버튼
try
{
MaterialStockVO vo = new MaterialStockVO();
if (txtProductCode.Text != "")
{
vo.product_codename = txtProductCode.Text;
}
if (cboProductType.Text != "선택")
{
vo.product_type = cboProductType.Text;
}
if (cboFactory.Text != "선택")
{
vo.factory_code = cboFactory.SelectedValue.ToString();
}
DataTable dt = service.GetMaterialStockList(vo);
SetDataGrid();
dataGridView1.DataSource = dt;
// SetRowNumber();
//dataGridView1.Columns[6].DefaultCellStyle.BackColor = Color.Red;
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void button5_Click(object sender, EventArgs e)
{
try
{
ExcelEX(dataGridView1);
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
lblID.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString();
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
//입고처리 버튼
//order_state = P_COMPLETE 로 바꾸고
//warehouse에 insert
//
List <MaterialReceivingVO> list = new List <MaterialReceivingVO>();
foreach (DataGridViewRow row in dgvMaterialReceiving.Rows)
{
bool isCellChecked = Convert.ToBoolean(row.Cells["chk"].EditedFormattedValue);
if (isCellChecked)
{
MaterialReceivingVO vo = new MaterialReceivingVO();
vo.order_serial = row.Cells[1].Value.ToString();
vo.product_codename = row.Cells[4].Value.ToString();
vo.order_count = Convert.ToInt32(row.Cells[7].Value);
vo.order_pdate = row.Cells[8].Value.ToString().Trim();
vo.product_name = row.Cells[5].Value.ToString().Trim();
vo.order_sdate = row.Cells[8].Value.ToString().Trim();
list.Add(vo);
}
}
if (MessageBox.Show("입고처리하시겠습니까?", "입고처리", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
MaterialLedgerService service = new MaterialLedgerService();
bool result = service.AddMaterialQauntity(list);
if (result)
{
MessageBox.Show("성공적으로 입고처리가 완료되었습니다.", "입고처리", MessageBoxButtons.OK, MessageBoxIcon.Information);
dgvMaterialReceiving.Rows.Clear();
}
else
{
MessageBox.Show("입고처리 실패하였습니다. 다시 시도하여 주십시오.", "입고처리", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
else
{
return;
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
//콤보박스 미선택
if (cboSearchFacilityGroup.SelectedIndex == 0)
{
var fine = (from findCode in list
where findCode.factory_code.Contains(txtSearchFacility.Text) || findCode.factory_name.Contains(txtSearchFacility.Text)
select findCode).ToList();
dataGridView1.DataSource = fine;
}
//콤보박스 선택 텍스트 미입력
else if (cboSearchFacilityGroup.SelectedIndex != 0 && txtSearchFacility.Text == "")
{
var fine = (from findCode in list
where findCode.facility_class.Contains(cboSearchFacilityGroup.Text)
select findCode).ToList();
dataGridView1.DataSource = fine;
}
//콤보박스 텍스트 모두입력
else
{
var fine = (from findCode in list
where (findCode.factory_code.Contains(txtSearchFacility.Text) ||
findCode.factory_name.Contains(txtSearchFacility.Text)) &&
findCode.facility_class.Contains(cboSearchFacilityGroup.Text)
select findCode).ToList();
dataGridView1.DataSource = fine;
}
if (dataGridView1.Rows.Count < 1)
{
SetBottomStatusLabel("검색 결과가 없습니다");
}
dataGridView1.CurrentCell = null;
if (dataGridView1.Rows.Count <= 0)
{
SetBottomStatusLabel("조회에 실패하였습니다. 다시 시도하여 주십시오.");
}
else
{
SetBottomStatusLabel("조회가 완료되었습니다.");
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void DataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
uphCount = 0;
try
{
string planID = cbOrderGubun.Text;
OrderService service = new OrderService();
uphCount = service.GetMaxUPHCount(planID);
//수량 입력하면 하루생산량 체크
if (Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value) > uphCount)
{
MessageBox.Show("일 최대 생산량을 초과하였습니다. 다시 입력하여 주십시오.", "생산계획", MessageBoxButtons.OK, MessageBoxIcon.Information);
dataGridView1.Rows[e.RowIndex].Cells[0].Value = null;
return;
}
//else
//{
//if (Convert.ToInt32(lblCount.Text) == 0)
//{
// dataGridView1.Rows[e.RowIndex].Cells[0].Value = null;
// return;
//}
//else
//{
// TotalCount -= Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value);
// if (TotalCount < 0)
// {
// MessageBox.Show("계획수량을 초과하였습니다. 다시 입력하여 주십시오.");
// TotalCount += Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value);
// dataGridView1.Rows[e.RowIndex].Cells[0].Value = null;
// return;
// }
// else
// {
// lblCount.Text = TotalCount.ToString();
// }
//}
//}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void BtnCancel_Click(object sender, EventArgs e)
{
//입고취소 버튼
List <MaterialReceivingVO> list = new List <MaterialReceivingVO>();
foreach (DataGridViewRow row in dataGridView1.Rows)
{
bool isCellChecked = Convert.ToBoolean(row.Cells["chk"].EditedFormattedValue);
if (isCellChecked)
{
MaterialReceivingVO vo = new MaterialReceivingVO();
vo.order_serial = row.Cells[1].Value.ToString();
vo.product_codename = row.Cells[4].Value.ToString();
vo.order_count = Convert.ToInt32(row.Cells[7].Value);
vo.product_name = row.Cells[5].Value.ToString();
list.Add(vo);
}
}
MaterialLedgerService service = new MaterialLedgerService();
if (MessageBox.Show("입고 취소하시겠습니까?", "입고취소", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
bool result = service.CancelMaterial(list);
if (result)
{
MessageBox.Show("성공적으로 입고취소가 완료되었습니다.", "입고취소", MessageBoxButtons.OK, MessageBoxIcon.Information);
SetBottomStatusLabel("성공적으로 입고취소가 완료되었습니다.");
btnSearch.PerformClick();
}
else
{
MessageBox.Show("입고취소 실패하였습니다. 다시 시도하여 주십시오.", "입고취소", MessageBoxButtons.OK, MessageBoxIcon.Error);
SetBottomStatusLabel("입고취소 실패하였습니다. 다시 시도하여 주십시오.");
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
else
{
return;
}
}
private void InOutList_Load(object sender, EventArgs e)
{
try
{
//창고 콤보박스 바인딩
StockService service = new StockService();
List <FactoryComboVO> fList = new List <FactoryComboVO>();
fList = service.GetFactory();
ComboUtil.ComboBinding(cboFactory, fList, "factory_code", "factory_name", "선택");
//품목유형 콤보박스 바인딩
List <CommonVO> productTypeList = new List <CommonVO>();
productTypeList = service.GetProductType("item_type");
ComboUtil.ComboBinding(cboProductType, productTypeList, "common_value", "common_name", "선택");
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
SetLoad();
try
{
MaterialSearchVO vo = new MaterialSearchVO();
vo.startDate = dtpStartDate.Value.ToShortDateString();
vo.endDate = dtpEndDate.Value.ToShortDateString();
if (cboFactory.Text != "선택")
{
vo.factory_name = cboFactory.Text;
}
if (cboProductType.Text != "선택")
{
vo.product_type = cboProductType.Text;
}
if (txtProduct.Text != "")
{
vo.product_name = txtProduct.Text;
}
StockService service = new StockService();
DataTable dt = service.GetInOutHistory(vo);
SetDataGrid();
dataGridView1.DataSource = dt;
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
private void BtnCancel_Click(object sender, EventArgs e)
{
List <OrderVO> list = new List <OrderVO>();
foreach (DataGridViewRow row in dataGridView1.Rows)
{
bool isCellChecked = Convert.ToBoolean(row.Cells["chk"].EditedFormattedValue);
if (isCellChecked)
{
OrderVO vo = new OrderVO();
vo.order_id = row.Cells[1].Value.ToString();
vo.plan_id = row.Cells[2].Value.ToString();
vo.order_count = Convert.ToInt32(row.Cells[9].Value);
list.Add(vo);
}
}
//발주취소 버튼 (발주번호, PlanID 값)
PurchasingService service = new PurchasingService();
if (MessageBox.Show("발주 취소하시겠습니까?", "발주취소", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
bool result = service.UpdateOrder(list);
if (result)
{
MessageBox.Show("성공적으로 발주취소가 완료되었습니다.", "발주취소", MessageBoxButtons.OK, MessageBoxIcon.Information);
SetBottomStatusLabel("성공적으로 발주취소가 완료되었습니다.");
btnSearch.PerformClick();
}
else
{
MessageBox.Show("발주취소 실패하였습니다. 다시 시도하여 주십시오.", "발주취소", MessageBoxButtons.OK, MessageBoxIcon.Error);
SetBottomStatusLabel("발주취소 실패하였습니다. 다시 시도하여 주십시오.");
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
else
{
return;
}
}