public bool InsertWorkOrder(WorkOrderInsVo vo)
{
int checkNum = 0;
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(ConnectionString);
cmd.CommandText = "InsertWorkOrderDetail";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Workorderno", vo.Workorderno);
cmd.Parameters.AddWithValue("@Wc_Code", vo.Wc_Code);
cmd.Parameters.AddWithValue("@item_Name", vo.Item_Name);
cmd.Parameters.AddWithValue("@Plan_Date", vo.Plan_Date);
cmd.Parameters.AddWithValue("@Plan_Starttime", vo.Plan_Starttime);
cmd.Parameters.AddWithValue("@Plan_Endtime", vo.Plan_Endtime);
cmd.Parameters.AddWithValue("@Plan_Qty", vo.Plan_Qty);
cmd.Parameters.AddWithValue("@Wo_Req_No", vo.Wo_Req_No);
cmd.Connection.Open();
checkNum = cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
return(checkNum == 1?true:false);
}
public bool InsertWorkOrder(WorkOrderInsVo vo)
{
WorkOrderDAC dac = new WorkOrderDAC();
return(dac.InsertWorkOrder(vo));
}
