public bool SaveReleaseOut(ReleaseVO release)
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = "SP_SAVE_RELEASE_USE";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@P_RELEASE_NO", release.release_no);
cmd.Parameters.AddWithValue("@P_RELEASE_SEQ", release.release_seq);
cmd.Parameters.AddWithValue("@P_FINAL_REGIST_EMPLOYEE", release.final_regist_employee);
SqlParameter pOutput = new SqlParameter("@OUTPUT", SqlDbType.VarChar, 100);
pOutput.Direction = ParameterDirection.Output;
cmd.Parameters.Add(pOutput);
cmd.Connection.Open();
int iCnt = cmd.ExecuteNonQuery();
if (iCnt < 1)
{
throw new Exception(pOutput.Value.ToString());
}
cmd.Connection.Close();
return(true);
}
}
catch (Exception err)
{
throw err;
}
}
/// <summary>
/// 출고주문 저장하기
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnInsert_Click(object sender, EventArgs e)
{
ReleaseVO release = new ReleaseVO();
release.company_id = Convert.ToInt32(dgv2.Rows[0].Cells[2].Value);
DataTable dt = (DataTable)dgv2.DataSource;
release.company_id = Convert.ToInt32(dgv2.Rows[0].Cells[2].Value);
//
if (releaseService.SaveReleasePlan(dt, release))
{
MessageBox.Show("출고 요청서를 추가하였습니다.");
dgv.DataSource = releaseService.GetReleasePlan();
dgv2.DataSource = releaseService.GetReleasePlanDetail(Convert.ToInt32(dgv.Rows[0].Cells[0].Value));
int release_no = Convert.ToInt32(dgv2.SelectedRows[0].Cells[0].Value);
for (int i = 0; i < dgv2.RowCount; i++)
{
if (Convert.ToDateTime(dgv2.Rows[i].Cells[7].Value) < Convert.ToDateTime(dgv2.Rows[i].Cells[8].Value))
{
releaseService.UpdateReleaseDateCancel(release_no, Convert.ToInt32(dgv2.Rows[i].Cells[3].Value));
}
}
dgv2.DataSource = releaseService.GetReleasePlanDetail(Convert.ToInt32(dgv.Rows[0].Cells[0].Value));
//MessageBox.Show("출고 취소 된 항목이 있습니다. 출고 요청일을 확인해주세요.");
}
}
public bool SaveReleaseOut(ReleaseVO release)
{
return(dac.SaveReleaseOut(release));
}
public bool SaveReleasePlan(DataTable dgv, ReleaseVO release)
{
return(dac.SaveReleasePlan(dgv, release));
}
/// <summary>
/// 저장하기
/// </summary>
/// <param name="release"></param>
/// <returns></returns>
public bool SaveReleasePlan(DataTable dgv, ReleaseVO release)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.Connection.Open();
SqlTransaction tran = cmd.Connection.BeginTransaction();
try
{
cmd.CommandText = "SP_SAVE_RELEASE_PLAN";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Transaction = tran;
cmd.Parameters.AddWithValue("@release_no", release.release_no);
cmd.Parameters.AddWithValue("@company_id", release.company_id);
cmd.Parameters.AddWithValue("@first_regist_time", DateTime.Now.ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("@first_regist_employee", "사원명");
cmd.Parameters.AddWithValue("@final_regist_time", DateTime.Now.ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("@final_regist_employee", "사원명");
int num = Convert.ToInt32(cmd.ExecuteScalar());
cmd.CommandText = "SP_SAVE_RELEASEDETAIL";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@release_no", num);
cmd.Parameters.Add("@release_seq", SqlDbType.Int);
cmd.Parameters.Add("@product_id", SqlDbType.Int);
cmd.Parameters.Add("@release_plan_date", SqlDbType.DateTime);
cmd.Parameters.Add("@release_date", SqlDbType.NVarChar);
cmd.Parameters.Add("@order_request_quantity", SqlDbType.Int);
cmd.Parameters.Add("@release_quantity", SqlDbType.Int);
cmd.Parameters.Add("@release_status", SqlDbType.NVarChar);
cmd.Parameters.Add("@release_request_date", SqlDbType.DateTime);
foreach (DataRow dr in dgv.Rows)
{
cmd.Parameters["@release_seq"].Value = dr["release_seq"];
cmd.Parameters["@product_id"].Value = dr["product_id"];
cmd.Parameters["@release_plan_date"].Value = dr["release_plan_date"];
cmd.Parameters["@release_date"].Value = "";
cmd.Parameters["@order_request_quantity"].Value = dr["order_request_quantity"];
cmd.Parameters["@release_quantity"].Value = 0;
cmd.Parameters["@release_status"].Value = "출고예정";
cmd.Parameters["@release_request_date"].Value = dr["release_request_date"];
cmd.ExecuteNonQuery();
}
tran.Commit();
cmd.Connection.Close();
return(true);
}
catch (Exception err)
{
tran.Rollback();
throw err;
}
}
}
