public bool InsertProducts(ProductInsertVO InsertData, char IsBomCopy)
{
try
{
using (SqlConnection conn = new SqlConnection(this.ConnectionString))
{
conn.Open();
// 로그인이 완성되면 회사 정보를 WHERE에 반드시 추가할 것
string sql = @"SP_PRODUCT_INSERT";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_PRODUCT_ID", InsertData.Product_ID);
cmd.Parameters.AddWithValue("@P_PRODUCT_GROUP_ID", InsertData.Product_Group_ID);
cmd.Parameters.AddWithValue("@P_PRODUCT_NAME", InsertData.Product_Name);
cmd.Parameters.AddWithValue("@P_PRODUCT_INFOMATION", InsertData.Product_Information);
cmd.Parameters.AddWithValue("@P_PRODUCT_UNIT", InsertData.Product_Unit);
cmd.Parameters.AddWithValue("@P_PRODUCT_STANDARD", InsertData.Product_Standards);
cmd.Parameters.AddWithValue("@P_PRODUCT_NOTE1", InsertData.Product_Note1);
cmd.Parameters.AddWithValue("@P_PRODUCT_NOTE2", InsertData.Product_Note2);
cmd.Parameters.AddWithValue("@P_PRODUCT_USE", InsertData.Product_Use);
cmd.Parameters.AddWithValue("@P_FINAL_REGIST_TIME", InsertData.Final_Regist_Time);
cmd.Parameters.AddWithValue("@P_FINAL_REGIST_EMPLOYEE", InsertData.Final_Regist_Employee);
cmd.Parameters.AddWithValue("@P_PRODUCT_TACT_TIME", InsertData.Product_Tact_Time);
cmd.Parameters.AddWithValue("@P_PRODUCT_LEAD_TIME", InsertData.Product_Lead_Time);
cmd.Parameters.AddWithValue("@P_IS_BOM_COPY", IsBomCopy);
cmd.Parameters.AddWithValue("@P_PRODUCT_SEQ", InsertData.Product_Seq);
if (Convert.ToInt32(cmd.ExecuteNonQuery()) > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
catch (Exception err)
{
throw err;
}
}
public bool UpdateProducts(ProductInsertVO vo)
{
try
{
using (SqlConnection conn = new SqlConnection(this.ConnectionString))
{
conn.Open();
// 로그인이 완성되면 회사 정보를 WHERE에 반드시 추가할 것
string sql = @"UPDATE TBL_PRODUCT SET [product_lead_time] = @LEAD_TIME, [product_tact_time] = @TACT_TIME, [product_group_id] = @GROUP_ID, [product_name] = @PRODUCT_NAME,
[product_information] = @INFORMATION, [product_unit] = @UNIT, [product_standards] = @STANDARD, [product_note1] = @NOTE1, [product_note2] = @NOTE2,
[product_seq] = @SEQ, [product_use] = @USE, [final_regist_time] = @REGIST_TIME, [final_regist_employee] = @REGIST_EMPLOYEE
WHERE PRODUCT_ID = @PRODUCT_ID";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@LEAD_TIME", vo.Product_Lead_Time);
cmd.Parameters.AddWithValue("@Tact_time", vo.Product_Tact_Time);
cmd.Parameters.AddWithValue("@group_id", vo.Product_Group_ID);
cmd.Parameters.AddWithValue("@Product_Name", vo.Product_Name);
cmd.Parameters.AddWithValue("@Information", vo.Product_Information);
cmd.Parameters.AddWithValue("@Unit", vo.Product_Unit);
cmd.Parameters.AddWithValue("@standard", vo.Product_Standards);
cmd.Parameters.AddWithValue("@note1", vo.Product_Note1);
cmd.Parameters.AddWithValue("@note2", vo.Product_Note2);
cmd.Parameters.AddWithValue("@seq", vo.Product_Seq);
cmd.Parameters.AddWithValue("@use", vo.Product_Use);
cmd.Parameters.AddWithValue("@regist_time", vo.Final_Regist_Time);
cmd.Parameters.AddWithValue("@regist_employee", vo.Final_Regist_Employee);
cmd.Parameters.AddWithValue("@product_id", vo.Product_ID);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
catch (Exception err)
{
throw err;
}
}
private void btnClear_Click(object sender, EventArgs e)
{
// 초기화 진행 시
if (IsBomCopy == false)
{
cboSearch.SelectedIndex = 0;
dgv.headerCheckBox.Checked = false;
dgv2.headerCheckBox.Checked = false;
}
else // IsBomCopy == true
{
cboSearch.SelectedIndex = 0;
ProductInformation = null;
btnInformation.Visible = true;
btnSubmit.Visible = false;
dgv.headerCheckBox.Checked = false;
dgv2.headerCheckBox.Checked = false;
}
DataSourceBinding();
}
public bool UpdateProducts(ProductInsertVO productInsert)
{
return(dac.UpdateProducts(productInsert));
}
public bool InsertProducts(ProductInsertVO InsertData, char IsBomCopy)
{
return(dac.InsertProducts(InsertData, IsBomCopy));
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (txtProductName.TextLength < 1 || txtInformation.TextLength < 1 || txtUnit.TextLength < 1 || txtLeadTime.TextLength < 1 || txtTactTime.TextLength < 1)
{
MessageBox.Show("전부 입력해주시기 바랍니다.");
return;
}
ProductInsertVO ProductInsert = new ProductInsertVO
{
Product_ID = Update_ProductID,
Product_Name = txtProductName.Text,
Product_Group_ID = cboProductGroup.SelectedValue.ToInt(), // 그룹명 대신 그룹 ID를 넘겨줌
Product_Information = txtInformation.Text,
Product_Unit = txtUnit.Text,
Product_Standards = Convert.ToInt32(numUnit.Value),
Product_Note1 = txtNote1.Text,
Product_Note2 = txtNote2.Text,
Product_Use = UseChar,
Final_Regist_Employee = employee, // 나중에 직원 명을 가져올 것 (필수)
Final_Regist_Time = DateTime.Now,
Product_Tact_Time = txtTactTime.Text.ToInt(),
Product_Lead_Time = txtLeadTime.Text.ToInt(),
Product_Seq = numSEQ.Value.ToInt()
};
if (IsUpdate == false) // 등록
{
if (EnabledProductName == true) // BOM Copy에서 진행
{
if (MessageBox.Show("정보 등록을 진행하시겠습니까?", "진행", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
this.DialogResult = DialogResult.OK;
frm.ProductInformation = ProductInsert;
this.Close();
}
}
else // 제품 등록 시 진행
{
if (MessageBox.Show("정보 등록을 진행하시겠습니까?", "진행", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
// 등록 진행
if (pdSv.InsertProducts(ProductInsert, 'N'))
{
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
}
else if (IsUpdate == true) // 변경
{
if (MessageBox.Show("정보 등록을 진행하시겠습니까?", "진행", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
// 등록 진행
if (pdSv.UpdateProducts(ProductInsert))
{
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
}
