/// <summary>
/// 폼 우측 상단의 공용 버튼의 Visible 속성을 제어하고
/// 거래처명, 거래처분류 콤보박스 바인딩
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
public frmCompany(bool Authority)
{
InitializeComponent();
newBtns1.btnBarCode.Visible = newBtns1.btnDocument.Visible = newBtns1.btnExcel.Visible = newBtns1.btnPrint.Visible = newBtns1.btnSearch.Visible = newBtns1.btnShipment.Visible = newBtns1.btnWait.Visible = false;
if (Authority == false)
{
newBtns1.btnCreate.Visible = false;
newBtns1.btnUpdate.Visible = false;
newBtns1.btnDelete.Visible = false;
}
try
{
Ctype = service.GetCompanyType();
CommonUtil.CompanyTypeBinding(cbCompanyType, Ctype);
ProdStatusService Pservice = new ProdStatusService();
companyName = Pservice.GetCompanyName();
CommonUtil.ProdStatus_CompanyNameBinding(cbCompanyName, companyName);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
/// <summary>
/// 컬럼 헤더 텍스트 바인딩
/// 데이터 조회해서 바인딩
/// 품목명, 창고명, 품목분류 콤보박스바인딩
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmPDStock_Load(object sender, EventArgs e)
{
try
{
CommonUtil.SetInitGridView(dgv_PDStock);
//CommonUtil.AddGridTextColumn(dgv_PDStock, "번호", "ps_id", 80);
CommonUtil.AddGridTextColumn(dgv_PDStock, "품목코드", "product_id", 220);
CommonUtil.AddGridTextColumn(dgv_PDStock, "품목명", "product_name", 220);
CommonUtil.AddGridTextColumn(dgv_PDStock, "분류", "product_type", 220);
CommonUtil.AddGridTextColumn(dgv_PDStock, "창고명", "w_name", 170);
CommonUtil.AddGridTextColumn(dgv_PDStock, "회사명", "company_name", 150);
CommonUtil.AddGridTextColumn(dgv_PDStock, "재고량", "ps_stock", 150);
DGVBinding();
ProdStatusService service = new ProdStatusService();
prodName = service.GetProdName();
CommonUtil.ProdStatus_ProdNameBinding(cbProdName, prodName);
whName = service.GetWHName();
CommonUtil.ProdStatus_WHNameBinding(cbWHName, whName);
pdType = service.GetProdType();
CommonUtil.ProdTypeBinding(cbProdType, pdType);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
/// <summary>
/// 삭제확인 메세지 출력 후 확인시 삭제 진행
/// 결과를 True/False로 받아서 확인/오류 메세지 출력
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void newBtns_btnDelete_Event(object sender, EventArgs e)
{
try
{
if (MessageBox.Show(Properties.Resources.msgDelete, "삭제확인 ", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
service = new ProdStatusService();
bool result = service.Delete(product_id);
if (result)
{
MessageBox.Show(Properties.Resources.msgOK);
DGV_Binding();
}
else
{
MessageBox.Show(Properties.Resources.msgError);
}
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
/// <summary>
/// 전역에 선언한 변수들을 string.Empty로 줌으로써 초기값설정
/// 각 콤보박스의 선택된 Index가 0이상일 경우 변수에 담는다
/// DAC단의 파라미터로 변수들을 담아 데이터소스로 호출
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
cbpName = cbpType = cbpCompany = cbpWH = cbpExam = string.Empty;
if (cbProdName.SelectedIndex > 0)
{
cbpName = cbProdName.Text;
}
if (cbProdType.SelectedIndex > 0)
{
cbpType = cbProdType.Text;
}
if (cbCompanyName.SelectedIndex > 0)
{
cbpCompany = cbCompanyName.Text;
}
if (cbWHName.SelectedIndex > 0)
{
cbpWH = cbWHName.Text;
}
if (cbExamYN.SelectedIndex > 0)
{
cbpExam = cbExamYN.Text;
}
service = new ProdStatusService();
allList = service.GetWhereInfo(cbpName, cbpType, cbpCompany, cbpWH, cbpExam);
dgvProduct.DataSource = allList;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void DGV_Binding()
{
try
{
service = new ProdStatusService();
allList = service.GetProdInfo();
dgvProduct.DataSource = allList;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
/// <summary>
/// 폼 로드이벤트
/// 컬럼헤더를 바인딩하고 DB에서 0레벨 BOM을 우선 조회한다.
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmBOM_Load(object sender, EventArgs e)
{
try
{
#region 0레벨 BOM GridView
CommonUtil.SetInitGridView(dgvBOM_Lv0);
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "번호", "bom_id", 40); //0
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "상위BOMID", "bom_parent_id", 10, false); //1
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "상위품목ID", "prod_parent_id", 10, false); //2
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "상위품목명", "prod_parent_name", 10, false); //3
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "품목코드", "product_id", 80); //4
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "품목명", "product_name", 90); //5
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "분류", "product_type", 60); //6
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "단위", "product_unit", 60); //7
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "소요량", "bom_use_count", 70); //8
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "레벨", "bom_level", 40); //9
CommonUtil.AddGridTextColumn(dgvBOM_Lv0, "비고", "bom_comment", 140, false); //10
#endregion
#region BOMAll GridView
CommonUtil.SetInitGridView(dgvBOMAll);
CommonUtil.AddGridTextColumn(dgvBOMAll, "번호", "bom_id", 80); //0
CommonUtil.AddGridTextColumn(dgvBOMAll, "품목코드", "product_id", 140); //1
CommonUtil.AddGridTextColumn(dgvBOMAll, "품목명", "product_name", 160); //2
CommonUtil.AddGridTextColumn(dgvBOMAll, "분류", "product_type", 160); //3
CommonUtil.AddGridTextColumn(dgvBOMAll, "단위", "product_unit", 140); //4
CommonUtil.AddGridTextColumn(dgvBOMAll, "소요량", "bom_use_count", 150); //5
CommonUtil.AddGridTextColumn(dgvBOMAll, "레벨", "bom_level", 140); //6
#endregion
gbBOM.Visible = false;
allList = service.GetBOMCBProdName();
CommonUtil.BOMProdName(cbProdName, allList);
ProdStatusService service2 = new ProdStatusService();
GetProdType = service2.GetProdType();
CommonUtil.ProdTypeBinding(cbProdType, GetProdType);
DGV_Binding_Lv0();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void CBBinding()
{
try
{
ProdStatusService service = new ProdStatusService();
prodName = service.GetProdName();
CommonUtil.ProdStatus_ProdNameBinding(cbProdName, prodName);
companyName = service.GetCompanyName();
CommonUtil.ProdStatus_CompanyNameBinding(cbCompany, companyName);
whName = service.GetWHName();
CommonUtil.ProdStatus_WHNameBinding(cbWHouse, whName);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
try
{
ProdStatusService service = new ProdStatusService();
if (label1.Text == "품목 등록")
{
ProdStatusVO vo = new ProdStatusVO
{
product_id = txtProdID.Text,
product_type = cbProdType.Text,
product_unit = cbUnit.Text,
product_lorder_count = int.Parse(nuMinOrder.Value.ToString()),
product_safety_count = int.Parse(nuSafeCount.Value.ToString()),
product_name = cbProdName.Text,
company_name = cbCompany.Text,
w_name = cbWHouse.Text,
product_exam = cbExamYN.Text,
product_stnd = txtStnd.Text,
product_comment = txtComment.Text,
product_deleted = cbDeleted.Text
};
bool result = service.Insert(vo);
if (result)
{
MessageBox.Show(Properties.Resources.msgOK);
}
else
{
MessageBox.Show(Properties.Resources.msgError);
}
}
else if (label1.Text == "품목 수정")
{
ProdStatusVO vo = new ProdStatusVO
{
product_id = txtProdID.Text,
product_type = cbProdType.Text,
product_unit = cbUnit.Text,
product_lorder_count = int.Parse(nuMinOrder.Value.ToString()),
product_safety_count = int.Parse(nuSafeCount.Value.ToString()),
product_name = cbProdName.Text,
company_name = cbCompany.Text,
w_name = cbWHouse.Text,
product_exam = cbExamYN.Text,
product_stnd = txtStnd.Text,
product_comment = txtComment.Text,
product_deleted = cbDeleted.Text
};
bool result = service.Update(vo);
if (result)
{
MessageBox.Show(Properties.Resources.msgOK);
}
else
{
MessageBox.Show(Properties.Resources.msgError);
}
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
