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