public bool UpdateFactory(FactoryVO item)
{
string sql = "Update Factory set Factory_Name = @Factory_Name, Factory_AddrNumber = @Factory_AddrNumber, Factory_Address1 = @Factory_Address1, Factory_Address2 = @Factory_Address2, Factory_Division = @Factory_Division, Factory_Number = @Factory_Number, Factory_Fax = @Factory_Fax where Factory_ID = @Factory_ID ";
string[] str = item.Factory_Address.Split(' ');
try
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@Factory_Name", item.Factory_Name);
cmd.Parameters.AddWithValue("@Factory_AddrNumber", item.Factory_AddrNumber);
cmd.Parameters.AddWithValue("@Factory_Address1", str[0]);
cmd.Parameters.AddWithValue("@Factory_Address2", str[1]);
cmd.Parameters.AddWithValue("@Factory_Number", item.Factory_Number);
cmd.Parameters.AddWithValue("@Factory_Fax", item.Factory_Fax);
cmd.Parameters.AddWithValue("@Factory_Division", item.Factory_Division);
cmd.Parameters.AddWithValue("@Factory_ID", item.Factory_ID);
conn.Open();
var rowsAffected = cmd.ExecuteNonQuery();
return(rowsAffected > 0);
}
}
catch
{
throw;
}
finally
{
conn.Close();
}
}
private void FactorySave(string UseCheck, string Status, int factory_id)
{
if (MessageBox.Show($"공장을 {Status}하시겠습니까?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
EmployeeVO employee = this.GetEmployee();
FactoryVO factory = new FactoryVO
{
factory_id = factory_id,
corporation_id = cboName.SelectedValue.ToInt(),
factory_name = txtName.Text,
factory_seq = Convert.ToInt32((nudFactory_seq.Value.ToString().Length > 0) ? nudFactory_seq.Value.ToString() : "0"),
factory_use = UseCheck,
first_regist_employee = employeeName,
final_regist_employee = employeeName,
factory_note1 = txtNote1.Text,
factory_note2 = txtNote2.Text
};
if (service.SaveFactory(factory))
{
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
public DataTable SearchName(FactoryVO vo)
{
DataTable dt = new DataTable();
try
{
using (SqlConnection conn = new SqlConnection(this.ConnectionString))
{
string sql = @"select c.corporation_name, factory_id,factory_name, factory_note1, factory_note2, factory_seq, factory_use, f.first_regist_time, f.first_regist_employee, f.final_regist_time, f.final_regist_employee
From TBL_CORPORATION c, TBL_FACTORY f
where c.corporation_id = f.corporation_id
and (@corporation_id = 0 or c.corporation_id = @corporation_id)
Order by factory_seq asc;"; // and (@factory_name = '' or f.factory_name = @factory_name)
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@corporation_id", vo.corporation_id);
//cmd.Parameters.AddWithValue("@factory_name", vo.factory_name);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.Connection.Open();
da.Fill(dt);
cmd.Connection.Close();
}
}
}
catch (Exception err)
{
throw err;
}
return(dt);
}
private void InsertFactory()
{
if (cboFactoryDivision.SelectedIndex != 0)
{
FactoryVO item = new FactoryVO
{
Factory_Name = txtFactoryName.Text,
Factory_Division = Convert.ToInt32(cboFactoryDivision.SelectedValue),
Factory_Number = maskedFactoryNumber.Text,
Factory_Fax = maskedFactoryFaxNumber.Text,
Factory_Address = addrFactory.Address1 + " " + addrFactory.Address2,
Factory_AddrNumber = addrFactory.Zipcode
};
if (item.Factory_Fax.Replace("-", "").Trim().Length < 10)
{
item.Factory_Fax = null;
}
try
{
StandardService service = new StandardService();
service.InsertFactory(item);
}
catch (Exception err)
{
Log.WriteError(err.Message, err);
}
}
}
private void Search(object sender, EventArgs e)
{
if (((MainForm)this.MdiParent).ActiveMdiChild == this)
{
string fname = txtFactoryName.Text.Trim();
FactoryVO vo = new FactoryVO()
{
corporation_id = cboCorporationName.SelectedValue.ToInt()
};
dtDgv = service.SearchName(vo);
DataView dv = dtDgv.DefaultView;
if (fname.Length > 0)
{
dv.RowFilter = $"factory_name like '%{fname}%'";
}
dgvFactorylist.DataSource = dv;
DataTable dt = dv.ToTable();
List <FactoryVO> sortedData = SqlHelper.ConvertDataTableToList <FactoryVO>(dt);
dgvFactorylist.DataSource = sortedData;
}
}
private void dgvFactory_CellClick(object sender, DataGridViewCellEventArgs e)
{
dgvLine.CurrentCell = null;
if (e.RowIndex < dgvFactory.Rows.Count && e.RowIndex > -1)
{
if (dgvFactory.Rows[e.RowIndex].Cells[5].Value == null)
{
factoryItem = new FactoryVO()
{
Factory_ID = Convert.ToInt32(dgvFactory.Rows[e.RowIndex].Cells[0].Value),
Factory_Name = dgvFactory.Rows[e.RowIndex].Cells[1].Value.ToString(),
Factory_Division = Convert.ToInt32(dgvFactory.Rows[e.RowIndex].Cells[2].Value),
Factory_Number = dgvFactory.Rows[e.RowIndex].Cells[4].Value.ToString(),
Factory_AddrNumber = dgvFactory.Rows[e.RowIndex].Cells[6].Value.ToString(),
Factory_Address = dgvFactory.Rows[e.RowIndex].Cells[7].Value.ToString()
};
}
else
{
factoryItem = new FactoryVO()
{
Factory_ID = Convert.ToInt32(dgvFactory.Rows[e.RowIndex].Cells[0].Value),
Factory_Name = dgvFactory.Rows[e.RowIndex].Cells[1].Value.ToString(),
Factory_Division = Convert.ToInt32(dgvFactory.Rows[e.RowIndex].Cells[2].Value),
Factory_Number = dgvFactory.Rows[e.RowIndex].Cells[4].Value.ToString(),
Factory_Fax = dgvFactory.Rows[e.RowIndex].Cells[5].Value.ToString(),
Factory_AddrNumber = dgvFactory.Rows[e.RowIndex].Cells[6].Value.ToString(),
Factory_Address = dgvFactory.Rows[e.RowIndex].Cells[7].Value.ToString()
};
}
}
}
private void OpenPopup(bool IsUpdate, FactoryVO vo = null)
{
if (((MainForm)this.MdiParent).ActiveMdiChild == this)
{
FactoryPopupForm frm = new FactoryPopupForm(emp.Employee_name, IsUpdate, vo);
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
}
public FactoryPopupForm(string employeeName, bool IsUpdate, FactoryVO vo)
{
InitializeComponent();
this.IsUpdate = IsUpdate;
this.employeeName = employeeName;
if (IsUpdate == true)
{
this.vo = vo;
}
}
private void UpdateInfo(FactoryVO item)
{
code = item.Factory_ID;
txtFactoryName.Text = item.Factory_Name;
maskedFactoryNumber.Text = item.Factory_Number;
maskedFactoryFaxNumber.Text = item.Factory_Fax;
string[] str = item.Factory_Address.Split(' ');
addrFactory.Address1 = str[0];
addrFactory.Address2 = str[1];
addrFactory.Zipcode = item.Factory_AddrNumber;
division = item.Factory_Division;
}
public bool UpdateFactory(FactoryVO VO)
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = "UpdateFactory";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", VO.factory_id);
cmd.Parameters.AddWithValue("@factory_grade", VO.factory_grade);
cmd.Parameters.AddWithValue("@factory_uadmin", VO.factory_uadmin);
if (VO.factory_parent == null)
{
SqlParameter param1 = new SqlParameter("@factory_parent", SqlDbType.NVarChar);
param1.Value = DBNull.Value;
cmd.Parameters.Add(param1);
}
else
{
cmd.Parameters.AddWithValue("@factory_parent", VO.factory_parent);
}
cmd.Parameters.AddWithValue("@factory_name", VO.factory_name);
cmd.Parameters.AddWithValue("@factory_code", VO.factory_code);
cmd.Parameters.AddWithValue("@factory_type", VO.factory_type);
cmd.Parameters.AddWithValue("@factory_yn", VO.factory_yn);
cmd.Parameters.AddWithValue("@factory_udate", VO.factory_udate);
cmd.Parameters.AddWithValue("@factory_comment", VO.factory_comment);
if (VO.company_id == 0)
{
SqlParameter param2 = new SqlParameter("@company_id", SqlDbType.Int);
param2.Value = DBNull.Value;
cmd.Parameters.Add(param2);
}
else
{
cmd.Parameters.AddWithValue("@company_id", VO.company_id);
}
cmd.Connection.Open();
var successRow = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(successRow > 0);
}
}
catch (Exception err)
{
string st = err.Message;
return(false);
}
}
public FactoryInsUp(EditMode editMode, FactoryVO item)
{
InitializeComponent();
if (editMode == EditMode.Insert)
{
mode = "Insert";
lblName.Text = "공장등록";
pbxTitle.Image = Resources.AddFile_32x32;
}
else
{
mode = "Update";
lblName.Text = "공장수정";
pbxTitle.Image = Resources.Edit_32x32;
UpdateInfo(item);
}
}
public bool InsertFactory(FactoryVO VO)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = "InsertFactory";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FACTORY_GRADE", VO.factory_grade);
cmd.Parameters.AddWithValue("@FACTORY_UADMIN", VO.factory_uadmin);
if (VO.factory_parent == null)
{
SqlParameter param1 = new SqlParameter("@FACTORY_PARENT", SqlDbType.NVarChar);
param1.Value = DBNull.Value;
cmd.Parameters.Add(param1);
}
else
{
cmd.Parameters.AddWithValue("@FACTORY_PARENT", VO.factory_parent);
}
cmd.Parameters.AddWithValue("@FACTORY_NAME", VO.factory_name);
cmd.Parameters.AddWithValue("@FACTORY_CODE", VO.factory_code);
cmd.Parameters.AddWithValue("@FACTORY_TYPE", VO.factory_type);
cmd.Parameters.AddWithValue("@FACTORY_YN", VO.factory_yn);
cmd.Parameters.AddWithValue("@FACTORY_UDATE", VO.factory_udate);
cmd.Parameters.AddWithValue("@FACTORY_COMMENT", VO.factory_comment);
if (VO.company_id == 0)
{
SqlParameter param2 = new SqlParameter("@COMPANY_ID", SqlDbType.Int);
param2.Value = DBNull.Value;
cmd.Parameters.Add(param2);
}
else
{
cmd.Parameters.AddWithValue("COMPANY_ID", VO.company_id);
}
cmd.Connection.Open();
var successRow = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(successRow > 0);
}
}
private void FactoryPop_Load(object sender, EventArgs e)
{
{
//콤보박스 업체 바인딩
R_service = new ResourceService();
Company_list = R_service.GetCompanyAll();
var C_Code = (from R_Item in Company_list
select R_Item).ToList();
ComboUtil.ComboBinding <CompanyDB_VO>(cboCompany, C_Code, "company_id", "company_name", "미선택");
}
service = new CommonCodeService();
Common_list = service.GetCommonCodeAll();
ComboUtil.ComboBinding <CommonVO>(cboFactoryGrade, Combo("facility_class_id"), "common_value", "common_name", "미선택");
ComboUtil.ComboBinding <CommonVO>(cboTypeFactory, Combo("facility_type"), "common_value", "common_name", "미선택");
ComboUtil.ComboBinding <CommonVO>(cboYN, Combo("user_flag2"), "common_value", "common_name");
{
if (mode == EditMode.Update)
{
VO = R_service.GetFactoryByID(Convert.ToInt32(lblID.Text));
string Comapany_Name = (VO.company_name == null) ? "" : VO.company_name.ToString();
txtCodeFactory.Text = VO.factory_code;
txtComment.Text = VO.factory_comment;
txtUadmin.Text = VO.factory_uadmin;
txtUdate.Text = string.Format("{0:yyyy-MM-dd HH:mm:ss}", today);
txtNameFactory.Text = VO.factory_name;
cboCompany.Text = Comapany_Name;
cboTypeFactory.Text = VO.factory_type;
txtpr.Text = VO.factory_parent;
cboYN.Text = VO.factory_yn;
cboFactoryGrade.Text = VO.factory_grade;
}
else if (mode == EditMode.Input)
{
txtUdate.Text = string.Format("{0:yyyy-MM-dd HH:mm:ss}", today);
}
}
}
private void dgvFactorylist_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0 || e.ColumnIndex == 7)
{
return;
}
FactoryVO updatevo = new FactoryVO
{
factory_id = dgvFactorylist[2, e.RowIndex].Value.ToInt(),
corporation_name = dgvFactorylist[1, e.RowIndex].Value.ToString(),
factory_name = dgvFactorylist[3, e.RowIndex].Value.ToString(),
factory_seq = dgvFactorylist[4, e.RowIndex].Value.ToInt(),
factory_use = dgvFactorylist[8, e.RowIndex].Value.ToString(),
factory_note1 = dgvFactorylist[5, e.RowIndex].Value.ToString(),
factory_note2 = dgvFactorylist[6, e.RowIndex].Value.ToString()
};
OpenPopup(true, updatevo);
}
public bool InsertFactory(FactoryVO item)
{
string sql = "insert into Factory(Factory_Name, Factory_Division, Factory_Number, Factory_Fax, Factory_AddrNumber, Factory_Address1, Factory_Address2) values (@Factory_Name, @Factory_Division, @Factory_Number, @Factory_Fax, @Factory_AddrNumber, @Factory_Address1, @Factory_Address2) ";
string[] str = item.Factory_Address.Split(' ');
try
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@Factory_Name", item.Factory_Name);
cmd.Parameters.AddWithValue("@Factory_AddrNumber", item.Factory_AddrNumber);
cmd.Parameters.AddWithValue("@Factory_Address1", str[0]);
cmd.Parameters.AddWithValue("@Factory_Address2", str[1]);
cmd.Parameters.AddWithValue("@Factory_Division", item.Factory_Division);
cmd.Parameters.AddWithValue("@Factory_Number", item.Factory_Number);
if (item.Factory_Fax == null)
{
cmd.Parameters.AddWithValue("@Factory_Fax", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Factory_Fax", item.Factory_Fax);
}
conn.Open();
var rowsAffected = cmd.ExecuteNonQuery();
return(rowsAffected > 0);
}
}
catch
{
throw;
}
finally
{
conn.Close();
}
}
public bool SaveFactory(FactoryVO vo)
{
try
{
using (SqlConnection conn = new SqlConnection(this.ConnectionString))
{
conn.Open();
string sql = "SP_SAVE_FACTORY";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_factory_id", vo.factory_id);
cmd.Parameters.AddWithValue("@P_factory_name", vo.factory_name);
cmd.Parameters.AddWithValue("@P_corporation_id", vo.corporation_id);
cmd.Parameters.AddWithValue("@P_factory_seq", vo.factory_seq);
cmd.Parameters.AddWithValue("@P_factory_use", vo.factory_use);
cmd.Parameters.AddWithValue("@P_factory_note1", vo.factory_note1);
cmd.Parameters.AddWithValue("@P_factory_note2", vo.factory_note2);
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)
{
return(false);
throw err;
}
}
public bool InsertFactory(FactoryVO VO)
{
return(dac.InsertFactory(VO));
}
public bool SaveFactory(FactoryVO vo)
{
return(dac.SaveFactory(vo));
}
public DataTable SearchName(FactoryVO vo)
{
return(dac.SearchName(vo));
}
public bool UpdateFactory(FactoryVO item)
{
FactoryDAC dac = new FactoryDAC();
return(dac.UpdateFactory(item));
}
public bool InsertFactory(FactoryVO item)
{
FactoryDAC dac = new FactoryDAC();
return(dac.InsertFactory(item));
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
bool bResult = false;
FactoryVO VO = new FactoryVO();
if (cboFactoryGrade.Text != "")
{
VO.factory_grade = cboFactoryGrade.SelectedValue.ToString();
}
if (cboParent.Text == "미선택" || cboParent.Text == "")
{
VO.factory_parent = "";
}
else
{
VO.factory_parent = cboParent.SelectedValue.ToString();
}
VO.factory_name = txtNameFactory.Text;
VO.factory_type = cboTypeFactory.SelectedValue.ToString();
if (cboCompany.SelectedIndex == 0)
{
VO.company_id = 0;
}
else
{
VO.company_id = (int)cboCompany.SelectedValue;
}
VO.factory_yn = cboYN.SelectedValue.ToString();
VO.factory_udate = string.Format("{0:yyyy-MM-dd HH:mm:ss}", today);
VO.factory_uadmin = txtUadmin.Text;
VO.factory_code = txtCodeFactory.Text;
if (txtComment.Text.Trim() == "")
{
VO.factory_comment = "";
}
else
{
VO.factory_comment = txtComment.Text;
}
if (mode == EditMode.Input)
{
bResult = Fac_service.InsertFactory(VO);
if (bResult)
{
MessageBox.Show("등록성공");
this.DialogResult = DialogResult.OK;
}
else if (!bResult)
{
MessageBox.Show("등록실패");
this.DialogResult = DialogResult.None;
return;
}
}
if (mode == EditMode.Update)
{
VO.factory_id = Convert.ToInt32(lblID.Text);
bResult = Fac_service.UpdateFactory(VO);
if (bResult)
{
MessageBox.Show("수정성공");
this.DialogResult = DialogResult.OK;
}
else if (!bResult)
{
MessageBox.Show("수정실패");
this.DialogResult = DialogResult.None;
return;
}
}
}
catch (NullReferenceException err)
{
MessageBox.Show("입력되지 않은값이 있습니다, 다시 확인해주세요", "입력확인", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.DialogResult = DialogResult.None;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
this.DialogResult = DialogResult.None;
}
}
public bool UpdateFactory(FactoryVO VO)
{
return(dac.UpdateFactory(VO));
}
