public static int CancelIpqc(product_ipqc objModel) { int result = 0; string strSql = ""; string strSql_f = ""; strSql_f = String.Format("Select id From op_iqc_mostly Where within_code='{0}' AND id='{1}'", within_code, objModel.qc_doc_id); DataTable tbIqc = clsPublicOfGeo.ExecuteSqlReturnDataTable(strSql_f); if (tbIqc.Rows.Count > 0) { strSql += string.Format(@"UPDATE op_outpro_in_detail SET iqc_result=null,iqc_state=null" + " WHERE within_code='{0}' AND id='{1}' AND sequence_id='{2}'" , within_code, objModel.doc_id, objModel.doc_seq); strSql += string.Format(@"UPDATE " + remote_tb + "op_iqc_mostly SET state='{0}' " + " WHERE within_code='{1}' AND id='{2}'" , objModel.state, within_code, objModel.qc_doc_id); if (strSql != "") { result = clsPublicOfGeo.ExecuteSqlUpdate(strSql); } } return(result); }
public static int UpdateIpqc_NG(product_ipqc objModel) { string strSql = ""; int result = 0; //外發iqc主表 strSql += string.Format( @"Update dbo.op_iqc_mostly Set qc_result='{0}',remark='{1}',final_solution='{2}',check_person='{3}',qc_state='{4}', unqualified_iqc_seq='{5}',unqualified_category='{6}' Where within_code='0000' AND id='{7}' ", objModel.iqc_result, objModel.qc_remark, objModel.state, objModel.qc_by, objModel.iqc_state, objModel.unqualified_iqc_seq, objModel.unqualified_category, objModel.doc_id); //外發iqc從表只更新外觀這一種類型 //保存明細的處理方法objModel.qc_date strSql += string.Format( @"Update dbo.op_iqc_details Set disposal_method='{0}' Where within_code='0000' AND id='{1}' AND waster_modality='001' ", objModel.qc_date, objModel.doc_id); //objModel.mat_item 為外發入庫單據號 strSql += string.Format( @"Update dbo.op_outpro_in_detail Set iqc_result='{0}',iqc_state='{1}' Where within_code='0000' AND id='{2}' AND sequence_id='{3}' ", objModel.iqc_result, objModel.iqc_state, objModel.mat_item, objModel.sequence_id); result = clsPublicOfGeo.ExecuteSqlUpdate(strSql); return(result); }
public static int UpdateIpqc(product_ipqc objModel) { int result = 0; string strSql = ""; string gen_no = "";// GenIqcNo(objModel.qc_date); gen_no = ExistIpqc(objModel.doc_id, objModel.doc_seq); if (gen_no == "") { //產生QC單號 string strSql_f = ""; string id1 = ""; string bill_id = "QC05"; string dat = objModel.qc_date;//"2000/01/01"; string year_month = dat.Substring(2, 2) + dat.Substring(5, 2); id1 = "IQC" + year_month; strSql_f = "Select bill_code From sys_bill_max_separate Where within_code='" + within_code + "' AND bill_id='" + bill_id + "' AND year_month='" + year_month + "'"; DataTable tbGenNo = clsPublicOfGeo.ExecuteSqlReturnDataTable(strSql_f); if (tbGenNo.Rows.Count > 0) { gen_no = tbGenNo.Rows[0]["bill_code"].ToString(); gen_no = id1 + (Convert.ToInt32(gen_no.Substring(7, 5)) + 1).ToString().PadLeft(5, '0'); strSql += string.Format(@"Update sys_bill_max_separate Set bill_code='{0}' Where within_code='{1}' AND bill_id='{2}' AND year_month='{3}'" , gen_no, within_code, bill_id, year_month); } else { gen_no = id1 + "00001"; strSql += string.Format(@"INSERT INTO sys_bill_max_separate (within_code,bill_id,year_month,bill_code) " + " VALUES ('{0}','{1}','{2}','{3}')" , within_code, bill_id, year_month, gen_no); } //插入QC記錄主表 strSql += string.Format(@"INSERT INTO op_iqc_mostly(" + "within_code,id,sequence_id,vendor,vendor_id,goods_id,bill_id,qc_date,issues_qty,check_qty,qc_result,qc_state,update_count,transfers_state" + ",create_date,create_by,update_date,update_by,check_person,adobt_level,state,approved_by,approved_date,check_times,mo_id,remark,final_solution) " + " VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}'" + ",GETDATE(),'{14}',GETDATE(),'{15}', '{16}', '{17}','{18}','{19}',GETDATE(),'{20}','{21}','{22}','{23}')" , within_code, gen_no, objModel.doc_seq, objModel.vendor, objModel.vendor_id, objModel.mat_item , objModel.doc_id, objModel.qc_date, objModel.lot_qty, objModel.lot_qty, objModel.iqc_result, objModel.iqc_state , objModel.update_count, objModel.transfers_state, objModel.crusr, objModel.crusr, objModel.qc_by , objModel.adobt_level, objModel.state, objModel.crusr, objModel.check_times, objModel.mo_no, objModel.qc_remark, objModel.not_ok_rmk); //插入QC記錄明細表 strSql += string.Format(@"INSERT INTO op_iqc_details(" + "within_code,id,sequence_id,waster_modality,transfers_state,check_qty,adopt_standard,aql_standard,aql_sample,accept_qty,reject_qty,disposal_method) " + " VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')" , within_code, gen_no, objModel.sequence_id, objModel.waster_modality, objModel.transfers_state, objModel.check_qty , objModel.adopt_standard, objModel.aql_standard, objModel.aql_sample, objModel.accept_qty, objModel.reject_qty, objModel.not_ok_rmk); } else { //更新QC記錄主表 strSql += string.Format(@"UPDATE op_iqc_mostly SET " + "vendor='{0}',vendor_id='{1}',goods_id='{2}',bill_id='{3}',qc_date='{4}',issues_qty='{5}',check_qty='{6}'" + ",qc_result='{7}',qc_state='{8}',update_count='{9}',transfers_state='{10}'" + ",create_date=GETDATE(),create_by='{11}',update_date=GETDATE(),update_by='{12}',check_person='{13}'" + ",adobt_level='{14}',state='{15}',approved_by='{16}',approved_date=GETDATE(),check_times='{17}'" + ",mo_id='{18}',remark='{19}',final_solution='{20}' " + " WHERE within_code='{21}' AND id='{22}'" , objModel.vendor, objModel.vendor_id, objModel.mat_item , objModel.doc_id, objModel.qc_date, objModel.lot_qty, objModel.lot_qty, objModel.iqc_result, objModel.iqc_state , objModel.update_count, objModel.transfers_state, objModel.crusr, objModel.crusr, objModel.qc_by , objModel.adobt_level, objModel.state, objModel.crusr, objModel.check_times, objModel.mo_no, objModel.qc_remark , objModel.not_ok_rmk, within_code, gen_no); //更新QC記錄明細表 strSql += string.Format(@"UPDATE op_iqc_details SET " + "waster_modality='{0}',transfers_state='{1}',check_qty='{2}',adopt_standard='{3}',aql_standard='{4}'" + ",aql_sample='{5}',accept_qty='{6}',reject_qty='{7}',disposal_method='{8}'" + " WHERE within_code='{9}' AND id='{10}' AND sequence_id='{11}' " , objModel.waster_modality, objModel.transfers_state, objModel.check_qty , objModel.adopt_standard, objModel.aql_standard, objModel.aql_sample , objModel.accept_qty, objModel.reject_qty, objModel.not_ok_rmk, within_code, gen_no, objModel.sequence_id); } //更新外發收貨記錄表標識 strSql += string.Format(@"UPDATE op_outpro_in_detail SET iqc_result='{0}',iqc_state='{1}'" + " WHERE within_code='{2}' AND id='{3}' AND sequence_id='{4}'" , objModel.iqc_result, objModel.iqc_state, within_code, objModel.doc_id, objModel.doc_seq); if (strSql != "") { result = clsPublicOfGeo.ExecuteSqlUpdate(strSql); } return(result); }