| | |
| | | DataSet ds = new DataSet(); |
| | | ds = oCN.RunProcReturn("select * from Gy_MouldFileMain where HInterID=" + HInterID, "Gy_MouldFileMain"); |
| | | DataRow dr = ds.Tables[0].Rows[0]; |
| | | dr["HPrintQty"] = 0; |
| | | |
| | | string Num = dr["HBarCode"].ToString(); |
| | | string Num1 = Num.Substring(0, (Num.Length) - 5); |
| | | oCN.BeginTran(); |
| | |
| | | string refSav = sArray[2].ToString();//æä½æ¹å¼æ°æ®ç±»å 1æ·»å 3ä¿®æ¹ 2 å¤å¶ |
| | | string msg4 = sArray[3].ToString();//ç¨æ·å |
| | | string msg5 = sArray[4].ToString(); |
| | | if (msg5 != null || msg5 != "") |
| | | if (msg5 != null && msg5 != ""&& msg5 != "undefined") |
| | | { |
| | | |
| | | msg5 = msg5.Substring(1); |
| | |
| | | { |
| | | |
| | | bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (msg5 != "") |
| | | if (msg5 != null && msg5 != "" && msg5 != "undefined") |
| | | { |
| | | oCN.RunProc("update WL_YayBillMain set HDate_Accounting=getdate() , HSurer_Accounting='" + msg4 +"'" +" where HInterID in (" + msg5 + ")"); |
| | | } |
| | |
| | | "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | "," + oSub.HQCCheckItemID.ToString() + ",'" + oSub.HQCStd + "','" + oSub.HQCNote1 + "','" + oSub.HQCNote2 + "','" + oSub.HQCNote3 + "','" + oSub.HQCNote4 + "'" + |
| | | ",'" + oSub.HQCNote5 + "','" + oSub.HQCNote6 + "','" + oSub.HQCNote7 + "','" + oSub.HQCNote8 + "','" + oSub.HQCNote9 + "','" + oSub.HQCNote10 + "','" + oSub.HQCNote1_SN + "','" + oSub.HQCNote2_SN + "','" + oSub.HQCNote3_SN + "','" + oSub.HQCNote4_SN + "','" + oSub.HQCNote5_SN + "','" + oSub.HQCNote6_SN + "','" + oSub.HQCNote7_SN + "','" + oSub.HQCNote8_SN + "','" + oSub.HQCNote9_SN + "','" + oSub.HQCNote10_SN + "'" + |
| | | "," + oSub.HTargetVal + "," + oSub.HInspectMethodID + "," + oSub.HDownLimit + "," + oSub.HUpLimit + ",'" + oSub.HAnalysisMethod + "'" + |
| | | "," + oSub.HTargetVal2 + "," + oSub.HTargetVal3 + "," + oSub.HTargetVal4 + "," + oSub.HTargetVal5 + "," + oSub.HTargetVal6 + |
| | | ",'" + oSub.HTargetVal + "'," + oSub.HInspectMethodID + "," + oSub.HDownLimit + "," + oSub.HUpLimit + ",'" + oSub.HAnalysisMethod + "'" + |
| | | ",'" + oSub.HTargetVal2 + "','" + oSub.HTargetVal3 + "','" + oSub.HTargetVal4 + "','" + oSub.HTargetVal5 + "','" + oSub.HTargetVal6 +"'"+ |
| | | ") "); |
| | | } |
| | | |