public static int AddProductQCRecords(product_qc_records prd_records)
{
int Result = 0;
try
{
string strSQL = "";
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
strSQL = @"INSERT INTO dbo.product_qc_records(id, dep_no, prd_date,qc_date, mo_no,
mat_item, mat_color, lot_qty, facade_actual_qty, size_actual_qty,
actual_size, mat_logo, oth_desc, no_pass_qty, qc_no_ok,
qc_ok,do_result,crusr,crtim,seq_no)
VALUES(@id, @dep_no, @prd_date,@qc_date, @mo_no,
@mat_item, @mat_color, @lot_qty, @facade_actual_qty, @size_actual_qty,
@actual_size, @mat_logo, @oth_desc, @no_pass_qty, @qc_no_ok,
@qc_ok, @do_result,@crusr,@crtim,@seq_no) " ;
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@id", prd_records.id),
new SqlParameter("@dep_no", prd_records.dep_no),
new SqlParameter("@prd_date", prd_records.prd_date),
new SqlParameter("@qc_date", prd_records.qc_date),
new SqlParameter("@mo_no", prd_records.mo_no),
new SqlParameter("@mat_item", prd_records.mat_item),
new SqlParameter("@mat_color", prd_records.mat_color),
new SqlParameter("@lot_qty", prd_records.lot_qty),
new SqlParameter("@facade_actual_qty", prd_records.facade_actual_qty),
new SqlParameter("@size_actual_qty", prd_records.size_actual_qty),
new SqlParameter("@actual_size", prd_records.actual_size),
new SqlParameter("@mat_logo", prd_records.mat_logo),
new SqlParameter("@oth_desc", prd_records.oth_desc),
new SqlParameter("@no_pass_qty", prd_records.no_pass_qty),
new SqlParameter("@qc_no_ok", prd_records.qc_no_ok),
new SqlParameter("@qc_ok", prd_records.qc_ok),
new SqlParameter("@do_result", prd_records.do_result),
new SqlParameter("@crusr", prd_records.crusr),
new SqlParameter("@crtim", prd_records.crtim),
new SqlParameter("@seq_no", prd_records.seq_no)
};
strSQL += @" UPDATE product_records SET qc_flag='Y' WHERE prd_id=" + prd_records.id + "";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = strSQL;
cmd.Parameters.AddRange(paras);
Result = cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(Result);
}
/// <summary>
/// 更新已QC 的產品報告
/// </summary>
/// <param name="lsEntity"></param>
/// <param name="ServerConn"></param>
/// <returns></returns>
public static int UpdateProductQCRecords(product_qc_records prd_records)
{
int Result = 0;
try
{
string strSQL = "";
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
strSQL = @" UPDATE dbo.product_qc_records
SET qc_date=@qc_date ,mat_color=@mat_color ,facade_actual_qty=@facade_actual_qty ,size_actual_qty=@size_actual_qty ,actual_size=@actual_size,
mat_logo=@mat_logo ,no_pass_qty=@no_pass_qty ,oth_desc=@oth_desc ,do_result=@do_result ,amusr=@amusr,
amtim=@amtim ,qc_no_ok=@qc_no_ok ,qc_ok=@qc_ok
WHERE id=@id and seq_no=@seq_no " ;
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@qc_date", prd_records.qc_date),
new SqlParameter("@mat_color", prd_records.mat_color),
new SqlParameter("@facade_actual_qty", prd_records.facade_actual_qty),
new SqlParameter("@size_actual_qty", prd_records.size_actual_qty),
new SqlParameter("@actual_size", prd_records.actual_size),
new SqlParameter("@mat_logo", prd_records.mat_logo),
new SqlParameter("@oth_desc", prd_records.oth_desc),
new SqlParameter("@no_pass_qty", prd_records.no_pass_qty),
new SqlParameter("@qc_no_ok", prd_records.qc_no_ok),
new SqlParameter("@qc_ok", prd_records.qc_ok),
new SqlParameter("@do_result", prd_records.do_result),
new SqlParameter("@amusr", prd_records.amusr),
new SqlParameter("@amtim", prd_records.amtim),
new SqlParameter("@id", prd_records.id),
new SqlParameter("@seq_no", prd_records.seq_no)
};
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = strSQL;
cmd.Parameters.AddRange(paras);
Result = cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(Result);
}
