public DowntimeTypeAdd(EditMode mode, DowntimeTypeVO item)
{
InitializeComponent();
switch (mode)
{
case EditMode.Insert:
currentMode = mode;
lblName.Text = "비가동유형등록";
btnOK.Text = "등록";
panel_Modi.Visible = false;
txtID.Text = "0";
pbxTitle.Image = Properties.Resources.AddFile_32x32;
break;
case EditMode.Update:
currentMode = mode;
lblName.Text = "비가동유형수정";
btnOK.Text = "수정";
panel_Modi.Visible = true;
txtExplain.Text = item.DownExplain;
txtID.Text = item.DownID;
txtName.Text = item.DownName;
pbxTitle.Image = Properties.Resources.Edit_32x32;
break;
default:
break;
}
this.ActiveControl = txtName;
}
public bool SaveDowntimeType(DowntimeTypeVO vo)
{
try
{
using (SqlConnection conn = new SqlConnection(this.ConnectionString))
{
conn.Open();
string sql = "SP_SAVE_DOWNTIMETYPE";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_downtime_type_id", vo.downtime_type_id);
cmd.Parameters.AddWithValue("@P_downtime_type_name", vo.downtime_type_name);
cmd.Parameters.AddWithValue("@P_downtime_type_calculation", vo.downtime_type_calculation);
cmd.Parameters.AddWithValue("@P_downtime_type_seq", vo.downtime_type_seq);
cmd.Parameters.AddWithValue("@P_downtime_type_use", vo.downtime_type_use);
cmd.Parameters.AddWithValue("@P_first_regist_employee", vo.first_regist_employee);
cmd.Parameters.AddWithValue("@P_final_regist_employee", vo.final_regist_employee);
cmd.ExecuteNonQuery();
}
return(true);
}
}
catch (Exception err)
{
throw err;
}
}
public DowntimeTypePopupForm(string employeeName, bool IsUpdate, DowntimeTypeVO vo)
{
InitializeComponent();
this.IsUpdate = IsUpdate;
this.employeeName = employeeName;
if (IsUpdate == true)
{
this.vo = vo;
}
}
private void OpenPopup(bool IsUpdate, DowntimeTypeVO vo = null)
{
if (((MainForm)this.MdiParent).ActiveMdiChild == this)
{
DowntimeTypePopupForm frm = new DowntimeTypePopupForm(emp.Employee_name, IsUpdate, vo);
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
public override void Modify(object sender, EventArgs e)
{
if (dgvDowntimeType.SelectedRows.Count > 0)
{
DowntimeTypeVO vo = new DowntimeTypeVO {
DownID = dgvDowntimeType.SelectedRows[0].Cells[0].Value.ToString(), DownName = dgvDowntimeType.SelectedRows[0].Cells[1].Value.ToString(), DownExplain = dgvDowntimeType.SelectedRows[0].Cells[2].Value.ToString()
};
DowntimeTypeAdd dfrm = new DowntimeTypeAdd(DowntimeTypeAdd.EditMode.Update, vo);
if (dfrm.ShowDialog() == DialogResult.OK)
{
RefreshClicked();
}
}
else
{
frm.NoticeMessage = Resources.ModDowntimeTypeError;
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (txtExplain.Text.Trim().Length > 0 && txtName.Text.Trim().Length > 0)
{
try
{
DowntimeTypeVO vo = new DowntimeTypeVO {
DownID = txtID.Text, DownName = txtName.Text.Trim(), DownExplain = txtExplain.Text.Trim()
};
DowntimeTypeService service = new DowntimeTypeService();
if (service.UpdateDowntimeType(vo))
{
if (vo.DownID != "0")
{
MessageBox.Show(Resources.ModDone, Resources.ModDone, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show(Resources.AddDone, Resources.AddDone, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
if (vo.DownID != "0")
{
MessageBox.Show(Resources.ModError, Resources.ModError, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show(Resources.AddError, Resources.AddError, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
}
else
{
MessageBox.Show(Resources.isEssential, Resources.MsgBoxTitleWarn, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void DowntimeTypeSave(string UseCheck, string TimeCheck, string Status, int downtime_type_id)
{
if (MessageBox.Show($"유형을 {Status}하시겠습니까?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
EmployeeVO employee = this.GetEmployee();
DowntimeTypeVO downtimetype = new DowntimeTypeVO
{
downtime_type_id = downtime_type_id,
downtime_type_name = txtName.Text,
downtime_type_calculation = TimeCheck,
downtime_type_seq = Convert.ToInt32((nudDowntimeType_seq.Value.ToString().Length > 0) ? nudDowntimeType_seq.Value.ToString() : "0"),
downtime_type_use = UseCheck,
first_regist_employee = employeeName,
final_regist_employee = employeeName,
};
if (service.SaveDowntimeType(downtimetype))
{
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
/// <summary>
/// 비가동유형 신규 또는 업데이트 하는 메서드
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool UpdateDowntimeType(DowntimeTypeVO item)
{
try
{
string sql = "KJH_UpdateDowntimeType";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DownID", item.DownID);
cmd.Parameters.AddWithValue("@DownName", item.DownName);
cmd.Parameters.AddWithValue("@DownExplain", item.DownExplain);
conn.Open();
int result = cmd.ExecuteNonQuery();
conn.Close();
return(result > 0);
}
}
catch
{
throw;
}
}
private void dgvDowntimeType_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
// 여기 부분은 버튼 사용 부분입니다. 참고용으로 적어놓았고, 실제 작동은 되지 않습니다.!!
// 작동 시키려면 버튼 컬럼의 Visible를 true로 바꾼 후 사용 바랍니다.!!
//if (e.RowIndex < 0 || e.ColumnIndex == 3 || e.ColumnIndex == 6)
// return;
if (e.RowIndex < 0)
{
return;
}
DowntimeTypeVO updatevo = new DowntimeTypeVO
{
downtime_type_id = dgvDowntimeType[1, e.RowIndex].Value.ToInt(),
downtime_type_name = dgvDowntimeType[2, e.RowIndex].Value.ToString(),
downtime_type_calculation = dgvDowntimeType[4, e.RowIndex].Value.ToString(),
downtime_type_seq = dgvDowntimeType[5, e.RowIndex].Value.ToInt(),
downtime_type_use = dgvDowntimeType[7, e.RowIndex].Value.ToString(),
};
OpenPopup(true, updatevo);
}
public bool SaveDowntimeType(DowntimeTypeVO vo)
{
return(dac.SaveDowntimeType(vo));
}
public bool UpdateDowntimeType(DowntimeTypeVO item)
{
DowntimeTypeDAC dac = new DowntimeTypeDAC();
return(dac.UpdateDowntimeType(item));
}
