| | |
| | | ",'"+ HLevel + "','0','" + Convert.ToString(HStopflag ? 1 : 0) + "','" + HRemark + "','"+ HUseFlag + "','"+ HQCCheckClassID + "','" + HDefaultResult + |
| | | "','" + HAnalysisMethod + "','" + HDefectLevel + "'," + HUnitID + "," + HDestructInspect + "," + HKeyInspect + "," + HQualityStdID + |
| | | "," + HInspectMethodID + "," + HInspectInstruMentID + "," + HInspectBasisID + "," + HSampleSchemeID + "," + HISsystemSet + "" + |
| | | ",'" + HMakeEmp + "',getdate()," + HUSEORGID + "," + HCREATEORGID + ")"); |
| | | ",'" + HMakeEmp + "',getdate(),'" + HUSEORGID + "','" + HCREATEORGID + "')"); |
| | | //修改上级为非末级代码 |
| | | if (list[0].HItemID.ToString() != "") |
| | | { |
| | |
| | | { |
| | | res.code = CodeConstant.FAIL; |
| | | res.count = CountConstant.FAIL; |
| | | res.Message = "第" + line + "行,检验项目不存在!"; |
| | | res.Message = "第" + line + "行,检验项目分类不存在!"; |
| | | res.data = null; |
| | | return res; |
| | | } |
| | | else |
| | | { |
| | | provisional.Rows[i]["HQCCheckClassID"] = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
| | | provisional.Rows[i]["HQCCheckClassID"] = checkClass.Tables[0].Rows[0]["HItemID"].ToString(); |
| | | } |
| | | } |
| | | else |
| | |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | |
| | | string sql = "insert into Gy_QCCheckItem (HName,HNumber,HUSEORGID,HCREATEORGID,HShortNumber,HQCCheckClassID,HLevel,HHelpCode,HParentID,HStopflag,HUseFlag,HRemark, HMakeTime,HMakeEmp)" + |
| | | $"values('{HName}', '{HNumber}', {HUSEORGID}, {HUSEORGID}, '{sShortNumber}','{HQCCheckClassID}',{HLevel},'',0,0,'未使用','{HRemark}', '{System.DateTime.Now.ToString("G")}', '{user}')"; |
| | | string sql = "insert into Gy_QCCheckItem (HName,HNumber,HUSEORGID,HCREATEORGID,HShortNumber,HQCCheckClassID,HLevel,HEndFlag,HHelpCode,HParentID,HStopflag,HUseFlag,HAnalysisMethod,HDefaultResult,HDefectLevel,HRemark, HMakeTime,HMakeEmp)" + |
| | | $"values('{HName}', '{HNumber}', {HUSEORGID}, {HUSEORGID}, '{sShortNumber}','{HQCCheckClassID}',{HLevel},1,'',0,0,'未使用','1','合格','3','{HRemark}','{System.DateTime.Now.ToString("G")}', '{user}')"; |
| | | LogService.Write(sql); |
| | | oCN.RunProc(sql); |
| | | } |
| | | else |