private void FacilitieInfoPop_Load(object sender, EventArgs e)
{
txtModifyTime.Text = string.Format("{0:yyyy-MM-dd HH:mm:ss}", today);
//콤보박스 바인딩
{
service = new CommonCodeService();
list = service.GetCommonCodeAll();
{
//사용유무
var mCode = (from item in list
where item.common_type == "user_flag"
select item).ToList();
ComboUtil.ComboBinding <CommonVO>(cboIsUsed, mCode, "common_value", "common_name");
}
{
var mCode = (from item in list
where item.common_type == "user_flag"
select item).ToList();
mCode.Reverse();
ComboUtil.ComboBinding <CommonVO>(cboIsOS, mCode, "common_value", "common_name");
}
R_service = new ResourceService();
var Fatory_list = R_service.GetFactoryAll();
var WH1 = (from wh1 in Fatory_list
where wh1.facility_class == "창고"
select wh1).ToList();
ComboUtil.ComboBinding <FactoryDB_VO>(cboUseWH, WH1, "factory_id", "factory_name", "미선택");
var WH2 = (from wh1 in Fatory_list
where wh1.facility_class == "창고"
select wh1).ToList();
ComboUtil.ComboBinding <FactoryDB_VO>(cboOkWH, WH2, "factory_id", "factory_name", "미선택");
var WH3 = (from wh1 in Fatory_list
where wh1.facility_class == "창고"
select wh1).ToList();
ComboUtil.ComboBinding <FactoryDB_VO>(cboNgWH, WH3, "factory_id", "factory_name", "미선택");
}
if (mode == EditMode.Update)
{
MachineVO vo = this.VO;
lblID.Text = VO.m_id.ToString();
lblGrCodeID.Text = VO.mgrade_id.ToString();
txtMgrade_code.Text = VO.mgrade_code;
txtCodeFacility.Text = VO.m_code;
txtNameFacility.Text = VO.m_name;
cboUseWH.Text = VO.m_use_sector;
cboOkWH.Text = VO.m_ok_sector;
cboNgWH.Text = VO.m_ng_sector;
cboIsUsed.Text = VO.m_yn;
cboIsOS.Text = VO.m_os_yn;
txtModifier.Text = VO.m_uadmin;
txtModifyTime.Text = VO.m_udate;
txtCheck.Text = VO.m_check;
txtComment.Text = VO.m_comment;
}
}
/// <summary>
/// MachineVO로 선언한 vo에 각 text의 내용을 담아서 DAC단의 파라미터로 전달
/// 결과를 Bool 타입으로 받아서 True/False시 확인/오류 메세지 출력
/// 작성자: 최현호 / 작성일: 210210
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnEdit_Click(object sender, EventArgs e)
{
#region 등록 및 수정
try
{
if (label1.Text == "설비정보 등록")
{
MachineVO vo = new MachineVO
{
m_info = txtMInfo.Text,
m_name = txtMName.Text,
m_comment = txtComment.Text,
m_yn = cbYN.Text,
};
bool result = service.CHH_MachineInsert(vo);
if (result)
{
MessageBox.Show(Properties.Resources.msgOK);
this.Close();
}
else
{
MessageBox.Show(Properties.Resources.msgError);
}
}
else if (label1.Text == "설비정보 수정")
{
MachineVO vo = new MachineVO
{
m_id = int.Parse(lblID.Text),
m_info = txtMInfo.Text,
m_name = txtMName.Text,
m_comment = txtComment.Text,
m_yn = cbYN.Text,
m_uadmin = LoginVO.user.Name,
m_udate = DateTime.Now.ToShortDateString()
};
bool result = service.CHH_MachineUpdate(vo);
if (result)
{
MessageBox.Show(Properties.Resources.msgOK);
this.Close();
}
else
{
MessageBox.Show(Properties.Resources.msgError);
}
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
#endregion
}
//수정
public FacilitieInfoPop(EditMode editMode, MachineVO VO)
{
InitializeComponent();
if (editMode == EditMode.Update)
{
mode = EditMode.Update;
this.Text = "설비정보 수정";
this.VO = VO;
}
if (editMode == EditMode.Input)
{
mode = EditMode.Input;
this.Text = "설비정보 추가";
}
}
public bool CHH_MachineInsert(MachineVO vo)
{
string sql = @"insert into TBL_MACHINE(m_info, m_name, m_comment, m_yn)
values (@m_info, @m_name, @m_comment, @m_yn)";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@m_info", vo.m_info);
cmd.Parameters.AddWithValue("@m_name", vo.m_name);
cmd.Parameters.AddWithValue("@m_comment", vo.m_comment);
cmd.Parameters.AddWithValue("@m_yn", vo.m_yn);
int iRowAffect = cmd.ExecuteNonQuery();
conn.Close();
return(iRowAffect > 0);
}
}
public static void MachineNameBinding(ComboBox cbo, List <MachineVO> list, bool blankItem = true, string blankText = "")
{
var codeList = (from item in list
select item).ToList();
if (blankItem)
{
MachineVO blank = new MachineVO
{
m_id = null, m_name = blankText
};
codeList.Insert(0, blank);
}
cbo.DisplayMember = "m_name";
cbo.ValueMember = "m_id";
cbo.DataSource = codeList;
}
public bool CHH_MachineUpdate(MachineVO vo)
{
string sql = @"update TBL_MACHINE
set m_info = @m_info, m_name = @m_name, m_comment = @m_comment,
m_yn = @m_yn, m_uadmin = @m_uadmin, m_udate = @m_udate
where m_id = @m_id";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@m_info", vo.m_info);
cmd.Parameters.AddWithValue("@m_name", vo.m_name);
cmd.Parameters.AddWithValue("@m_comment", vo.m_comment);
cmd.Parameters.AddWithValue("@m_yn", vo.m_yn);
cmd.Parameters.AddWithValue("@m_uadmin", vo.m_uadmin);
cmd.Parameters.AddWithValue("@m_udate", vo.m_udate);
cmd.Parameters.AddWithValue("@m_id", vo.m_id);
int iRowAffect = cmd.ExecuteNonQuery();
conn.Close();
return(iRowAffect > 0);
}
}
public bool UpdateMachine(MachineVO VO)
{
using (SqlCommand cmd = new SqlCommand())
{
string sql = "UpdateMachine";
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = sql;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.AddWithValue("@m_id", VO.m_id);
cmd.Parameters.AddWithValue("@mgrade_id", VO.mgrade_id);
cmd.Parameters.AddWithValue("@m_code", VO.m_code);
cmd.Parameters.AddWithValue("@m_name", VO.m_name);
cmd.Parameters.AddWithValue("@m_use_sector", VO.m_use_sector);
cmd.Parameters.AddWithValue("@m_ok_sector", VO.m_ok_sector);
if (VO.m_ng_sector == "")
{
SqlParameter param1 = new SqlParameter("@m_ng_sector", SqlDbType.NVarChar);
param1.Value = DBNull.Value;
cmd.Parameters.Add(param1);
}
else
{
cmd.Parameters.AddWithValue("@m_ng_sector", VO.m_ng_sector);
}
cmd.Parameters.AddWithValue("@m_os_yn", VO.m_os_yn);
cmd.Parameters.AddWithValue("@m_check", VO.m_check);
cmd.Parameters.AddWithValue("@m_comment", VO.m_comment);
cmd.Parameters.AddWithValue("@m_yn", VO.m_yn);
cmd.Parameters.AddWithValue("@m_uadmin", VO.m_uadmin);
cmd.Parameters.AddWithValue("@m_udate", VO.m_udate);
var successRow = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(successRow > 0);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (lblID2.Text == "")
{
SetBottomStatusLabel("선택된 설비가 없습니다");
MessageBox.Show("변경할 설비를 선택해주세요");
return;
}
else
{
if (dataGridView2.Rows.Count > 0)
{
DataGridViewRow rows = dataGridView2.CurrentRow;
MachineVO VO = new MachineVO();
VO.m_id = Convert.ToInt32(rows.Cells[0].Value.ToString());
VO.mgrade_code = rows.Cells[2].Value.ToString();
VO.mgrade_id = Convert.ToInt32(rows.Cells[1].Value);
VO.m_code = rows.Cells[3].Value.ToString();
VO.m_name = rows.Cells[4].Value.ToString();
VO.m_use_sector = rows.Cells[5].Value.ToString();
VO.m_ok_sector = rows.Cells[6].Value.ToString();
if (rows.Cells[7].Value == null)
{
VO.m_ng_sector = "";
}
else
{
VO.m_ng_sector = rows.Cells[7].Value.ToString();
}
VO.m_yn = rows.Cells[11].Value.ToString();
VO.m_os_yn = rows.Cells[8].Value.ToString();
VO.m_uadmin = rows.Cells[12].Value.ToString();
VO.m_udate = string.Format("{0:yyyy-MM-dd HH:mm:ss}", today);
if (rows.Cells[9].Value == null)
{
VO.m_check = "";
}
else
{
VO.m_check = rows.Cells[9].Value.ToString();
}
VO.m_comment = rows.Cells[10].Value.ToString();
FacilitieInfoPop frm = new FacilitieInfoPop(FacilitieInfoPop.EditMode.Update, VO);
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
SetBottomStatusLabel("설비 정보 수정 성공");
MessageBox.Show("설비 정보 수정 성공");
}
}
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
public bool CHH_MachineUpdate(MachineVO vo)
{
MachineDAC dac = new MachineDAC();
return(dac.CHH_MachineUpdate(vo));
}
public bool CHH_MachineInsert(MachineVO vo)
{
MachineDAC dac = new MachineDAC();
return(dac.CHH_MachineInsert(vo));
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
#region
if (txtCodeFacility.Text == "")
{
MessageBox.Show("설비코드을 입력해주세요");
this.DialogResult = DialogResult.None;
return;
}
else if (txtNameFacility.Text == "")
{
MessageBox.Show("설비명을 입력해주세요");
this.DialogResult = DialogResult.None;
return;
}
if (cboUseWH.SelectedIndex == 0)
{
MessageBox.Show("소진창고를 선택해주세요");
this.DialogResult = DialogResult.None;
return;
}
else if (cboOkWH.SelectedIndex == 0)
{
MessageBox.Show("양품창고를 선택해주세요");
this.DialogResult = DialogResult.None;
return;
}
if (cboNgWH.SelectedIndex == 0)
{
cboNgWH.Text = "";
}
#endregion
MachineVO VO = new MachineVO();
VO.mgrade_id = Convert.ToInt32(lblGrCodeID.Text);
VO.mgrade_code = txtMgrade_code.Text;
VO.m_code = txtCodeFacility.Text;
VO.m_name = txtNameFacility.Text;
VO.m_use_sector = cboUseWH.Text;
VO.m_ok_sector = cboOkWH.Text;
VO.m_ng_sector = cboNgWH.Text;
VO.m_yn = cboIsUsed.Text;
VO.m_os_yn = cboIsOS.Text;
VO.m_uadmin = txtModifier.Text;
VO.m_udate = txtModifyTime.Text;
VO.m_check = txtCheck.Text;
VO.m_comment = txtComment.Text;
//등록
if (mode == EditMode.Input)
{
bool bResult = R_service.InsertMachine(VO);
if (bResult)
{
MessageBox.Show("등록성공");
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("등록실패");
this.DialogResult = DialogResult.None;
}
}
else if (mode == EditMode.Update)
{
VO.m_id = Convert.ToInt32(lblID.Text);
bool bResult = R_service.UpdateMachine(VO);
if (bResult)
{
MessageBox.Show("수정성공");
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("수정실패");
this.DialogResult = DialogResult.None;
}
}
}
catch (NullReferenceException err)
{
MessageBox.Show("입력되지 않은값이 있습니다, 다시 확인해주세요", "입력확인", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.DialogResult = DialogResult.None;
return;
}
catch (Exception err)
{
string str = err.Message;
}
}
public bool UpdateMachine(MachineVO VO)
{
return(dac.UpdateMachine(VO));
}
public bool InsertMachine(MachineVO VO)
{
return(dac.InsertMachine(VO));
}
