private void FrmSalesMasterPop_Load(object sender, EventArgs e)
{
//콤보박스 바인딩
BindingComboBox();
//초기값
cboCOM.SelectedIndex = 0;
cboCOM2.SelectedIndex = 0;
cboMarket.SelectedIndex = 0;
cboOrderTyp.SelectedIndex = 0;
cboItem.SelectedIndex = 0;
if (InsertOrUpdate == 2) //수정
{
////서비스 호출
SalesService service = new SalesService();
var vo = service.GetSalesWorkInfo(SalesID);
txtID.Text = vo.SALES_ID.ToString();
txtWO.Text = vo.SALES_Work_Order_ID;
txtPO.Text = vo.SO_PurchaseOrder;
cboCOM.SelectedIndex = cboCOM.FindIndexByValue(vo.COM_CODE);
cboCOM2.SelectedIndex = cboCOM2.FindIndexByValue(vo.SALES_COM_CODE);
dtpDueDate.Value = Convert.ToDateTime(vo.SALES_DUEDATE);
cboItem.SelectedIndex = cboItem.FindIndexByValue(vo.ITEM_CODE);
txtOrderQTY.Text = vo.SALES_QTY.ToString();
txtOutQTY.Text = vo.SALES_Out_QTY.ToString();
txtNoQTY.Text = vo.SALES_NO_QTY.ToString();
cboMarket.SelectedIndex = cboMarket.FindStringExact(vo.SALES_MKT);
cboOrderTyp.SelectedIndex = cboOrderTyp.FindStringExact(vo.SALES_Order_TYPE);
txtRemark.Text = vo.SALES_REMARK;
}
}
private void LoadSalesWorkList()
{
//서비스호출
SalesService service = new SalesService();
AllList = service.GetSalesWorkList();
dgvSales.DataSource = null;
dgvSales.DataSource = AllList;
}
/// <summary>
/// W/O 저장하는 이벤트
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnOK_Click(object sender, EventArgs e)
{
//유효값 확인
bool bQTY = txtOrderQTY.Text.Length > 0;
bool bWO = txtWO.Text.Trim().Length > 0;
if (!(bQTY || bWO))
{
MessageBox.Show("필수값을 입력해주세요.", "필수값 입력 확인", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//전달 vo 생성
SALES_WORK_VO vo = new SALES_WORK_VO();
vo.SALES_ID = 0; //등록
if (InsertOrUpdate == 2)
{
vo.SALES_ID = int.Parse(txtID.Text); //수정
}
vo.SALES_Work_Order_ID = txtWO.Text.Trim();
vo.SO_PurchaseOrder = txtPO.Text.Trim();
vo.COM_CODE = cboCOM.SelectedValue.ToString();
vo.SALES_COM_CODE = cboCOM2.SelectedValue.ToString();
vo.SALES_DUEDATE = dtpDueDate.Value.ToShortDateString();
vo.ITEM_CODE = cboItem.SelectedValue.ToString();
vo.SALES_QTY = int.Parse(txtOrderQTY.Text);
if (txtOutQTY.Text.Trim().Length < 1)
{
txtOutQTY.Text = "0";
}
vo.SALES_Out_QTY = int.Parse(txtOutQTY.Text);
if (txtNoQTY.Text.Trim().Length < 1)
{
txtNoQTY.Text = "0";
}
vo.SALES_NO_QTY = int.Parse(txtNoQTY.Text);
vo.SALES_MKT = cboMarket.Text;
vo.SALES_Order_TYPE = cboOrderTyp.Text;
vo.SALES_REMARK = txtRemark.Text;
//서비스호출
SalesService service = new SalesService();
Message msg = service.InsertOrUpdateSalesWork(vo);
if (msg.IsSuccess)
{
MessageBox.Show(msg.ResultMessage);
this.Close();
}
else
{
MessageBox.Show(msg.ResultMessage);
return;
}
}
private void btnBarcode_Click(object sender, EventArgs e)
{
SalesService service = new SalesService();
XtraWorkOrder rpt = new XtraWorkOrder();
DataTable dt = service.GetBaCodeWorkOrderList();
rpt.Parameters["uName"].Value = LoginInfo.UserInfo.LI_NAME;
rpt.DataSource = dt;
rpt.CreateDocument();
using (ReportPrintTool printTool = new ReportPrintTool(rpt))
{
printTool.ShowRibbonPreviewDialog();
}
}
/// <summary>
/// 수요계획 생성
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDemandPlan_Click(object sender, EventArgs e)
{
List <DEMAND_PLANNING_VO> list = new List <DEMAND_PLANNING_VO>();
if (dgvSales.RowCount > 0)
{
foreach (DataGridViewRow item in dgvSales.Rows)
{
if (item.Cells[15].Value.ToString().Equals("주문대기"))
{
DEMAND_PLANNING_VO vo = new DEMAND_PLANNING_VO();
vo.PLAN_ID = DateTime.Now.ToString("yyyy-MM-dd").Replace("-", "") + "_P";
vo.PLAN_Date = DateTime.Now.ToString("yyyy-MM-dd");
vo.PLAN_Work_Order_ID = item.Cells[2].Value.ToString();
vo.SO_PurchaseOrder = "";
if (item.Cells[3].Value != null)
{
vo.SO_PurchaseOrder = item.Cells[3].Value.ToString();
}
list.Add(vo);
}
}
if (list.Count > 0)
{
//서비스호출
SalesService service = new SalesService();
if (service.InsertDemandPlan(list))
{
service.UpdateSalesWork(list);
MessageBox.Show("수요계획이 생성되었습니다.", "계획 생성", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("계획생성에 실패하였습니다.", "생성 실패", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("생성할 계획이 없습니다..", "계획 없음", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
Reset(null, null);
}
//영업마스터 생성
private void btnMaster_Click(object sender, EventArgs e)
{
if (dgvSalesMaster.Rows.Count > 0)
{
Message msg = new TEAM3FINALVO.Message();
//DB에 저장
for (int i = 0; i < RList.Count; i++)
{
//전달 vo 생성
SALES_WORK_VO vo1 = new SALES_WORK_VO();
vo1.SALES_ID = 0; //등록
vo1.SALES_Work_Order_ID = RList[i].SALES_Work_Order_ID;
vo1.SO_PurchaseOrder = "";
vo1.COM_CODE = RList[i].COM_CODE;
vo1.SALES_COM_CODE = RList[i].SALES_COM_CODE;
vo1.SALES_DUEDATE = RList[i].SALES_DUEDATE;
vo1.ITEM_CODE = RList[i].ITEM_CODE;
vo1.SALES_QTY = RList[i].SALES_QTY;
vo1.SALES_Out_QTY = 0;
vo1.SALES_NO_QTY = 0;
vo1.SALES_MKT = RList[i].SALES_MKT;
vo1.SALES_Order_TYPE = RList[i].SALES_Order_TYPE;
vo1.SALES_REMARK = "";
//서비스호출
SalesService service = new SalesService();
msg = service.InsertOrUpdateSalesWork(vo1);
}
if (msg.IsSuccess)
{
MessageBox.Show("생성되었습니다.", "생성 확인", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("생성에 실패하였습니다.", "생성 실패", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("생성할 영업마스터가 존재하지않습니다.", "영업마스터 확인", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void Delete(object sender, EventArgs e)
{
if (((FrmMAIN)this.MdiParent).ActiveMdiChild == this)
{
string lists = CheckedList();
if (lists.Length > 0)
{
if (MessageBox.Show("정말로 삭제하시겠습니까?", "삭제확인", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//서비스 호출
SalesService service = new SalesService();
if (service.DeleteSalesWorkList(lists, "@"))
{
MessageBox.Show("삭제되었습니다.", "삭제 성공", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("삭제 중 오류가 발생하였습니다. 다시 시도하여 주십시오.", "삭제 실패", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
Reset(null, null);
}
}
