private void btnCreate_Click(object sender, EventArgs e)
{
if (txtdefname.Text.Trim().Length < 1 || txtdefcomment.Text.Trim().Length < 1)
{
MessageBox.Show("필수항목을 채워주세요");
return;
}
try
{
if (headName == "불량유형추가")
{
ComboItemVO def = new ComboItemVO
{
common_name = txtdefname.Text,
common_value = txtdefcomment.Text
};
DefService service = new DefService();
bool bResult = service.DefInsert(def);
if (bResult)
{
MessageBox.Show("새로운 불량유형 등록하였습니다");
this.Close();
}
else
{
MessageBox.Show("등록에 실패하셨습니다");
}
}
else if (headName == "불량유형수정")
{
ComboItemVO def = new ComboItemVO
{
common_id = common_id,
common_name = txtdefname.Text,
common_value = txtdefcomment.Text
};
DefService service = new DefService();
bool bResult = service.DefUpdate(def);
if (bResult)
{
MessageBox.Show("불량유형을 수정하였습니다");
this.Close();
}
else
{
MessageBox.Show("수정에 실패하셨습니다");
}
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
public bool DefInsert(ComboItemVO def)
{
string sql = @"insert into TBL_COMMON_CODE(common_type, common_name, common_value)
values('불량유형', @common_name, @common_value)";
int iRowAffect = 0;
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@common_name", def.common_name);
cmd.Parameters.AddWithValue("@common_value", def.common_value);
iRowAffect = cmd.ExecuteNonQuery();
Dispose();
}
return(iRowAffect > 0);
}
public static void ComboBinding(ComboBox cbo, List <ComboItemVO> list, string gubun, bool blankItem = true, string blankText = "")
{
var codeList = (from item in list
where item.Gubun.Equals(gubun)
select item).ToList();
if (blankItem)
{
ComboItemVO blank = new ComboItemVO
{
Code = "", CodeName = blankText
};
codeList.Insert(0, blank);
}
cbo.DisplayMember = "CodeName";
cbo.ValueMember = "Code";
cbo.DataSource = codeList;
}
public bool DefUpdate(ComboItemVO def)
{
string sql = @"update TBL_COMMON_CODE
set common_name = @common_name, common_value = @common_value
where common_id = @common_id";
int iRowAffect = 0;
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@common_id", def.common_id);
cmd.Parameters.AddWithValue("@common_name", def.common_name);
cmd.Parameters.AddWithValue("@common_value", def.common_value);
iRowAffect = cmd.ExecuteNonQuery();
Dispose();
}
return(iRowAffect > 0);
}
/// <summary>
/// 콤보박스 바인딩
/// </summary>
/// <param name="cbo"></param>
/// <param name="list"></param>
/// <param name="gubun"></param>
/// <param name="blankItem"></param>
/// <param name="blankText"></param>
public static void ComboBinding(ComboBox cbo, List <ComboItemVO> list, string gubun, bool blankItem = true, string blankText = "")
{
//common_id, common_type, common_name, common_value
var codeList = (from item in list
where item.common_type.Equals(gubun)
select item).ToList();
if (blankItem)
{
ComboItemVO blank = new ComboItemVO
{
common_id = null, common_name = blankText
};
codeList.Insert(0, blank);
}
cbo.DisplayMember = "common_name";
cbo.ValueMember = "common_id";
cbo.DataSource = codeList;
}
public bool DefUpdate(ComboItemVO def)
{
WorkOrderDAC dac = new WorkOrderDAC();
return(dac.DefUpdate(def));
}
public bool DefInsert(ComboItemVO def)
{
WorkOrderDAC dac = new WorkOrderDAC();
return(dac.DefInsert(def));
}
