public ActionResult Details(Item_Master_and_woreqtVO notice)
{
// TODO: Add insert logic here
Item_MasterDAC dac = new Item_MasterDAC();
if (dac.InsertItem_Master_and_woreqtVO(notice))
{
return(RedirectToAction("Index")); //인서트가 성공적으로 됐다면. 목록으로 가라 indexview가 목록임.
}
else
{
return(RedirectToAction("Details"));
}
}
/// <summary>
/// 생산의뢰 등록
/// </summary>
/// <param name="notice"></param>
/// <returns></returns>
public bool InsertItem_Master_and_woreqtVO(Item_Master_and_woreqtVO notice)
{
string sql = "Insert into Wo_Req ( Wo_Req_No, Item_Code, Req_Qty, Prd_Plan_Date, Cust_Name, Project_Name, Sale_Emp, Req_Status, Ins_Date, Ins_Emp)" +
" values( @Wo_Req_No, @Item_Code, @Req_Qty, @Prd_Plan_Date, @Cust_Name, @Project_Name, '김이박', '대기', @Ins_Date, @Ins_Emp)";
using (SqlConnection conn = new SqlConnection(Connstr))
{
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Wo_Req_No", notice.Wo_Req_No);
cmd.Parameters.AddWithValue("@Item_Code", notice.Item_Code);
cmd.Parameters.AddWithValue("@Req_Qty", notice.Req_Qty);
cmd.Parameters.AddWithValue("@Prd_Plan_Date", notice.Prd_Plan_Date);
cmd.Parameters.AddWithValue("@Cust_Name", notice.Cust_Name);
cmd.Parameters.AddWithValue("@Project_Name", notice.Project_Name);
cmd.Parameters.AddWithValue("@Ins_Date", DateTime.Now);
cmd.Parameters.AddWithValue("@Ins_Emp", UserInfo.User_Name);
conn.Open();
int iResult = cmd.ExecuteNonQuery();
conn.Close();
return(iResult > 0);
}
}
