| | |
|---|
| | | { |
|---|
| | | 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 |
|---|
