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); }