| using DBUtility; | 
| using Newtonsoft.Json; | 
| using Newtonsoft.Json.Linq; | 
| using System; | 
| using System.Collections.Generic; | 
| using System.Data; | 
| using System.Linq; | 
| using System.Net; | 
| using System.Net.Http; | 
| using System.Web.Http; | 
| using WebAPI.Models; | 
|   | 
| namespace WebAPI.Controllers.BaseSet | 
| { | 
|     public class Gy_CheckItemController : ApiController | 
|     { | 
|         public DBUtility.ClsPub.Enum_BillStatus BillStatus; | 
|   | 
|         private json objJsonResult = new json(); | 
|         SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); | 
|         DataSet ds; | 
|         public DAL.ClsGy_QCCheckItem_Ctl BillOld = new DAL.ClsGy_QCCheckItem_Ctl(); | 
|   | 
|         #region 检验项目列表数据 | 
|         /// <summary> | 
|         /// 返回检验项目列表 | 
|         ///参数:string sql。 | 
|         ///返回值:object。 | 
|         /// </summary> | 
|         [Route("Gy_CheckItem/list")] | 
|         [HttpGet] | 
|         public object list(string sWhere,string user) | 
|         { | 
|             try | 
|             { | 
|                 List<object> columnNameList = new List<object>(); | 
|                 //查看权限 | 
|                 if (!DBUtility.ClsPub.Security_Log("Gy_QCCheckItem_Query", 1, false, user)) | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 0; | 
|                     objJsonResult.Message = "无查看权限!"; | 
|                     objJsonResult.data = null; | 
|                     return objJsonResult; | 
|                 } | 
|   | 
|                 if (sWhere == null || sWhere.Equals("")) | 
|                 { | 
|                     ds = oCN.RunProcReturn("select * from h_v_IF_QCCheckItemList  order by 代码", "h_v_IF_QCCheckItemList"); | 
|                 } | 
|                 else | 
|                 { | 
|                     string sql1 = "select * from h_v_IF_QCCheckItemList where 1 = 1 "; | 
|                     string sql = sql1 + sWhere+ " order by 代码"; | 
|                     ds = oCN.RunProcReturn(sql, "h_v_IF_QCCheckItemList"); | 
|                 } | 
|   | 
|                 //添加列名 | 
|                 foreach (DataColumn col in ds.Tables[0].Columns) | 
|                 { | 
|                     Type dataType = col.DataType; | 
|                     string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; | 
|                     columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名 | 
|                 } | 
|   | 
|                 //if (ds.Tables[0].Rows.Count != 0 || ds != null) | 
|                 //{ | 
|                 objJsonResult.code = "1"; | 
|                 objJsonResult.count = 1; | 
|                 objJsonResult.Message = "Sucess!"; | 
|                 objJsonResult.data = ds.Tables[0]; | 
|                 objJsonResult.list = columnNameList; | 
|                 return objJsonResult; | 
|                 //} | 
|                 //else | 
|                 //{ | 
|                 //objJsonResult.code = "0"; | 
|                 //objJsonResult.count = 0; | 
|                 //objJsonResult.Message = "无数据"; | 
|                 //objJsonResult.data = null; | 
|                 //return objJsonResult; | 
|                 //} | 
|             } | 
|             catch (Exception e) | 
|             { | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 0; | 
|                 objJsonResult.Message = "Exception!" + e.ToString(); | 
|                 objJsonResult.data = null; | 
|                 return objJsonResult; | 
|             } | 
|         } | 
|         #endregion | 
|   | 
|         #region 检验项目根据树型ID查询所有层级列表数据 | 
|         /// <summary> | 
|         /// 根据树型ID 查找记录 | 
|         ///参数:string sql。 | 
|         ///返回值:object。 | 
|         /// </summary> | 
|         [Route("Gy_CheckItem/cx")] | 
|         [HttpGet] | 
|         public object cx(long HInterID) | 
|         { | 
|             try | 
|             { | 
|   | 
|                 //ds = oCN.RunProcReturn("select * from h_v_IF_RepairCheckList where HitemID=" + HInterID, "h_v_IF_RepairCheckList"); | 
|                 ds = oCN.RunProcReturn(string.Format(@"WITH a AS (SELECT * FROM dbo.h_v_IF_QCCheckItemList WHERE HitemID=" + HInterID + " UNION ALL SELECT s.* FROM dbo.h_v_IF_QCCheckItemList AS s,a WHERE s.parentid=a.HitemID) SELECT * FROM a"), "h_v_IF_QCCheckItemList"); | 
|                 if (ds == null || ds.Tables[0].Rows.Count == 0) | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 0; | 
|                     objJsonResult.Message = "false!"; | 
|                     objJsonResult.data = null; | 
|                     return objJsonResult; | 
|                 } | 
|                 else | 
|                 { | 
|                     objJsonResult.code = "1"; | 
|                     objJsonResult.count = 1; | 
|                     objJsonResult.Message = "Sucess!"; | 
|                     objJsonResult.data = ds.Tables[0]; | 
|                     return objJsonResult; | 
|                 } | 
|             } | 
|             catch (Exception e) | 
|             { | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 0; | 
|                 objJsonResult.Message = "Exception!" + e.ToString(); | 
|                 objJsonResult.data = null; | 
|                 return objJsonResult; | 
|             } | 
|         } | 
|         #endregion | 
|   | 
|         #region 删除检验项目 | 
|         /// <summary> | 
|         /// 检验项目列表删除按钮 | 
|         ///参数:string sql。 | 
|         ///返回值:object。 | 
|         /// </summary> | 
|         [Route("Gy_CheckItem/Delete_Json")] | 
|         [HttpGet] | 
|         public object Delete_Json(long HItemID, string User, string ModRightNameDelete) | 
|         { | 
|             DAL.ClsGy_QCCheckItem_Ctl oDept = new DAL.ClsGy_QCCheckItem_Ctl(); | 
|             DAL.ClsGy_QCCheckItem_View oDeptHlp = new DAL.ClsGy_QCCheckItem_View(); | 
|             try | 
|             { | 
|                 //判断是否有删除权限 | 
|                 if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, false, User)) | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 0; | 
|                     objJsonResult.Message = "没有删除权限"; | 
|                     objJsonResult.data = null; | 
|                     return objJsonResult; | 
|                 } | 
|   | 
|                 if (oDeptHlp.GetInfoByID(HItemID)) | 
|                 { | 
|                     if (oDept.HavChildCodes(HItemID)) | 
|                     { | 
|                         objJsonResult.code = "0"; | 
|                         objJsonResult.count = 0; | 
|                         objJsonResult.Message = "此项目存在子项目,不能删除!"; | 
|                         objJsonResult.data = null; | 
|                         return objJsonResult; | 
|                     } | 
|                     //删除前判断是否 已使用 20141020 | 
|                     if (oDeptHlp.omodel.HUseFlag != "未使用") | 
|                     { | 
|                         objJsonResult.code = "0"; | 
|                         objJsonResult.count = 0; | 
|                         objJsonResult.Message = "此项目已使用或者未检测,不能删除!请重新检测再删除!"; | 
|                         objJsonResult.data = null; | 
|                         return objJsonResult; | 
|                     } | 
|                     // | 
|                     if (oDept.DeleteByID(HItemID)) | 
|                     { | 
|                         //写入日志 | 
|                         ClsPub.Add_Log("", "删除项目,代码:" + oDeptHlp.omodel.HNumber + ",名称:" + oDeptHlp.omodel.HName, ClsPub.CurUserName); | 
|                         //更新上级为 末级 | 
|                         objJsonResult.code = "1"; | 
|                         objJsonResult.count = 1; | 
|                         objJsonResult.Message = "删除成功"; | 
|                         objJsonResult.data = null; | 
|                         return objJsonResult; | 
|                     } | 
|                     else | 
|                     { | 
|                         objJsonResult.code = "0"; | 
|                         objJsonResult.count = 0; | 
|                         objJsonResult.Message = "删除失败"; | 
|                         objJsonResult.data = null; | 
|                         return objJsonResult; | 
|                     } | 
|                 } | 
|                 //ds = oCN.RunProcReturn("delete from Gy_Department where HItemID =  " + HItemID, "Gy_Department"); | 
|   | 
|                 objJsonResult.code = "1"; | 
|                 objJsonResult.count = 1; | 
|                 objJsonResult.Message = "删除成功"; | 
|                 objJsonResult.data = null; | 
|                 return objJsonResult; | 
|             } | 
|             catch (Exception e) | 
|             { | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 0; | 
|                 objJsonResult.Message = "Exception!" + e.ToString(); | 
|                 objJsonResult.data = null; | 
|                 return objJsonResult; | 
|             } | 
|         } | 
|         #endregion | 
|   | 
|         #region 检验项目新增保存 | 
|         /// <summary> | 
|         /// 检验项目-保存按钮 | 
|         ///参数:string sql。 | 
|         ///返回值:object。 | 
|         /// </summary> | 
|         [Route("Gy_CheckItem/AddBill")] | 
|         [HttpPost] | 
|         public object AddBill([FromBody] JObject oMain) | 
|         { | 
|             try | 
|             { | 
|                 var _value = oMain["oMain"].ToString(); | 
|                 string msg1 = _value.ToString(); | 
|                 //反序列化 | 
|                 msg1 = "[" + msg1.ToString() + "]"; | 
|   | 
|                 DAL.ClsGy_QCCheckItem_Ctl oDept = new DAL.ClsGy_QCCheckItem_Ctl(); | 
|                 DAL.ClsGy_QCCheckItem_View oDeptHlp = new DAL.ClsGy_QCCheckItem_View(); | 
|   | 
|   | 
|   | 
|                 List<CheckItem> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<CheckItem>>(msg1); | 
|   | 
|                 long HItemID = list[0].HItemID.ToString() == "" ? 0 : list[0].HItemID; | 
|                 string HNumber = list[0].HNumber; | 
|                 string HName = list[0].HName; | 
|                 string HShortNumber = list[0].HNumber; | 
|                 long HParentID = list[0].HParentID; | 
|                 long HLevel= list[0].HLevel; | 
|                 string HHelpCode = list[0].HHelpCode; | 
|                 string HRemark = list[0].HRemark; | 
|                 bool HStopflag = list[0].HStopflag; | 
|                 bool HUseFlag = list[0].HUseFlag; | 
|                 long HQCCheckClassID = list[0].HQCCheckClassID; | 
|                 string HDefaultResult = list[0].HDefaultResult; | 
|   | 
|                 long HUnitID = list[0].HUnitID; | 
|                 string HAnalysisMethod = list[0].HAnalysisMethod; | 
|                 string HDefectLevel = list[0].HDefectLevel; | 
|                 long HDestructInspect = list[0].HDestructInspect; | 
|                 long HKeyInspect = list[0].HKeyInspect; | 
|                 long HQualityStdID = list[0].HQualityStdID; | 
|                 long HInspectMethodID = list[0].HInspectMethodID; | 
|                 long HInspectInstruMentID = list[0].HInspectInstruMentID; | 
|                 long HInspectBasisID = list[0].HInspectBasisID; | 
|                 long HSampleSchemeID = list[0].HSampleSchemeID; | 
|                 long HISsystemSet = list[0].HISsystemSet; | 
|   | 
|                 if (!DBUtility.ClsPub.AllowNumber(HNumber)) | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 0; | 
|                     objJsonResult.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’!"; | 
|                     objJsonResult.data = null; | 
|                     return objJsonResult; | 
|                 } | 
|   | 
|   | 
|   | 
|                 //若MAINDI重复则重新获取 | 
|                 oCN.BeginTran(); | 
|                 //主表 | 
|                 oCN.RunProc("Insert Into Gy_QCCheckItem " + | 
|                 "(HNumber,HName,HHelpCode,HShortNumber,HParentID" + | 
|                 ",HLevel,HEndFlag,HStopflag,HRemark,HUseFlag,HQCCheckClassID,HDefaultResult" + | 
|                 ",HAnalysisMethod,HDefectLevel,HUnitID,HDestructInspect,HKeyInspect,HQualityStdID" + | 
|                 ",HInspectMethodID,HInspectInstruMentID,HInspectBasisID,HSampleSchemeID,HISsystemSet) " + | 
|                 " values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "','" + HItemID + "'" + | 
|                 ",'"+ HLevel + "','0','" + Convert.ToString(HStopflag ? 1 : 0) + "','" + HRemark + "','未使用','"+ HQCCheckClassID + "','" + HDefaultResult +  | 
|                 "','" + HAnalysisMethod + "','" + HDefectLevel + "'," + HUnitID + "," + HDestructInspect + "," + HKeyInspect + "," + HQualityStdID + | 
|                 "," + HInspectMethodID + "," + HInspectInstruMentID + "," + HInspectBasisID + "," + HSampleSchemeID + "," + HISsystemSet + ")"); | 
|                 //修改上级为非末级代码 | 
|                 if (list[0].HItemID.ToString() != "") | 
|                 { | 
|                     oCN.RunProc("Update Gy_QCCheckItem set HEndflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); | 
|                 } | 
|                 oCN.Commit(); | 
|                 objJsonResult.code = "1"; | 
|                 objJsonResult.count = 1; | 
|                 objJsonResult.Message = "新增成功!"; | 
|                 //objJsonResult.data = null; | 
|                 return objJsonResult; | 
|             } | 
|             catch (Exception e) | 
|             { | 
|                 oCN.RollBack(); | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 0; | 
|                 objJsonResult.Message = "Exception!" + e.Message; | 
|                 objJsonResult.data = null; | 
|                 return objJsonResult; | 
|             } | 
|         } | 
|         #endregion | 
|   | 
|         #region 检验项目修改保存 | 
|         /// <summary> | 
|         /// 修改单据-保存按钮 | 
|         ///参数:string sql。 | 
|         ///返回值:object。 | 
|         /// </summary> | 
|         [Route("Gy_CheckItem/EditBill")] | 
|         [HttpPost] | 
|         public object EditBill([FromBody] JObject oMain) | 
|         { | 
|   | 
|             try | 
|             { | 
|                 DAL.ClsGy_QCCheckItem_Ctl oDept = new DAL.ClsGy_QCCheckItem_Ctl(); | 
|                 DAL.ClsGy_QCCheckItem_View oDeptHlp = new DAL.ClsGy_QCCheckItem_View(); | 
|   | 
|                 var _value = oMain["oMain"].ToString(); | 
|                 string msg1 = _value.ToString(); | 
|                 string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); | 
|                 string msg2 = sArray[0].ToString(); | 
|                 string msg3 = sArray[1].ToString(); | 
|                 string msg4 = sArray[2].ToString();//用户名 | 
|                 string msg5 = sArray[3].ToString(); | 
|   | 
|                 //判断权限 | 
|                 if (!DBUtility.ClsPub.Security_Log(msg5, 1, false, msg4)) | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 0; | 
|                     objJsonResult.Message = "无保存权限"; | 
|                     objJsonResult.data = null; | 
|                     return objJsonResult; | 
|                 } | 
|   | 
|                 //反序列化 | 
|                 msg2 = "[" + msg2.ToString() + "]"; | 
|                 List<CheckItem> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<CheckItem>>(msg2); | 
|   | 
|                 long HItemID = int.Parse(msg3); | 
|                 string HNumber = list[0].HNumber; | 
|                 string HName = list[0].HName; | 
|                 string HShortNumber = list[0].HNumber; | 
|                 long HParentID = list[0].HParentID.ToString() == "" ? 0 : list[0].HParentID; | 
|                 string HHelpCode = list[0].HHelpCode; | 
|                 long  HQCCheckClassID = list[0].HQCCheckClassID; | 
|                 string HRemark = list[0].HRemark; | 
|                 bool HStopflag = list[0].HStopflag; | 
|                 bool HUseFlag = list[0].HUseFlag; | 
|   | 
|                 string HDefaultResult = list[0].HDefaultResult; | 
|                 long HUnitID = list[0].HUnitID; | 
|                 string HAnalysisMethod = list[0].HAnalysisMethod; | 
|                 string HDefectLevel = list[0].HDefectLevel; | 
|                 long HDestructInspect = list[0].HDestructInspect; | 
|                 long HKeyInspect = list[0].HKeyInspect; | 
|                 long HQualityStdID = list[0].HQualityStdID; | 
|                 long HInspectMethodID = list[0].HInspectMethodID; | 
|                 long HInspectInstruMentID = list[0].HInspectInstruMentID; | 
|                 long HInspectBasisID = list[0].HInspectBasisID; | 
|                 long HSampleSchemeID = list[0].HSampleSchemeID; | 
|                 long HISsystemSet = list[0].HISsystemSet; | 
|   | 
|                 if (!DBUtility.ClsPub.AllowNumber(HNumber)) | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 0; | 
|                     objJsonResult.Message = "代码中不能出现连续‘.’并且首位末位不能为‘.’!"; | 
|                     objJsonResult.data = null; | 
|                     return objJsonResult; | 
|                 } | 
|   | 
|                 if (oDept.HavSameNumber(HItemID, HNumber)) | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 0; | 
|                     objJsonResult.Message = "代码重复!"; | 
|                     objJsonResult.data = null; | 
|                     return objJsonResult; | 
|                 } | 
|   | 
|   | 
|                 //若MAINDI重复则重新获取 | 
|                 oCN.BeginTran(); | 
|                 //主表 | 
|                 oCN.RunProc("Update Gy_QCCheckItem set " + | 
|                     " HNumber='" + HNumber + "'" + | 
|                     ",HName='" + HName + "'" + | 
|                     ",HShortNumber='" + HShortNumber + "'" + | 
|                     ",HHelpCode='" + HHelpCode + "'" + | 
|                     ",HParentID=" + HParentID + | 
|                     ",HStopflag='" + HStopflag + "'" + | 
|                     ",HQCCheckClassID='" + HQCCheckClassID + "'" + | 
|                     ",HDefaultResult='" + HDefaultResult + "'" + | 
|   | 
|                     ",HAnalysisMethod='" + HAnalysisMethod + "'" + | 
|                     ",HDefectLevel='" + HDefectLevel + "'" + | 
|                     ",HUnitID='" + HUnitID + "'" + | 
|                     ",HDestructInspect='" + HDestructInspect + "'" + | 
|                     ",HKeyInspect='" + HKeyInspect + "'" + | 
|                     ",HQualityStdID='" + HQualityStdID + "'" + | 
|                     ",HInspectMethodID='" + HInspectMethodID + "'" + | 
|                     ",HInspectInstruMentID='" + HInspectInstruMentID + "'" + | 
|                     ",HInspectBasisID='" + HInspectBasisID + "'" + | 
|                     ",HSampleSchemeID='" + HSampleSchemeID + "'" + | 
|                     ",HISsystemSet='" + HISsystemSet + "'" + | 
|   | 
|                     ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); | 
|                 //修改子项目代码 | 
|                 //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_RepairCheck,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); | 
|                 //将上级 为非末级 | 
|                 oCN.RunProc("Update Gy_QCCheckItem set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); | 
|                 // | 
|                 oCN.Commit(); | 
|                 objJsonResult.code = "1"; | 
|                 objJsonResult.count = 1; | 
|                 objJsonResult.Message = "修改单据成功!"; | 
|                 //objJsonResult.data = null; | 
|                 return objJsonResult; | 
|             } | 
|             catch (Exception e) | 
|             { | 
|                 oCN.RollBack(); | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 0; | 
|                 objJsonResult.Message = "Exception!" + e.Message; | 
|                 objJsonResult.data = null; | 
|                 return objJsonResult; | 
|             } | 
|         } | 
|         #endregion | 
|   | 
|         #region 检验项目修改获取绑定数据 | 
|         /// <summary> | 
|         /// 维修列表修改按钮方法 | 
|         ///参数:string sql。 | 
|         ///返回值:object。 | 
|         /// </summary> | 
|         [Route("Gy_CheckItem/xg")] | 
|         [HttpGet] | 
|         public object xg(long HInterID) | 
|         { | 
|             try | 
|             { | 
|                 ds = oCN.RunProcReturn("select * from Gy_QCCheckItem where HItemID=" + HInterID, "Gy_QCCheckItem"); | 
|   | 
|                 objJsonResult.code = "1"; | 
|                 objJsonResult.count = 1; | 
|                 objJsonResult.Message = ""; | 
|                 objJsonResult.data = ds.Tables[0]; | 
|                 return objJsonResult; | 
|             } | 
|             catch (Exception e) | 
|             { | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 0; | 
|                 objJsonResult.Message = "Exception!" + e.ToString(); | 
|                 objJsonResult.data = null; | 
|                 return objJsonResult; | 
|             } | 
|         } | 
|         #endregion | 
|   | 
|         #region 检验项目修改获取绑定数据视图 | 
|         /// <summary> | 
|         /// 维修列表修改按钮方法 | 
|         ///参数:string sql。 | 
|         ///返回值:object。 | 
|         /// </summary> | 
|         [Route("Gy_CheckItem/xg_View")] | 
|         [HttpGet] | 
|         public object xg_View(long HInterID) | 
|         { | 
|             try | 
|             { | 
|                 ds = oCN.RunProcReturn("select * from h_v_Gy_QCCheckItemList_Edit where HItemID=" + HInterID, "h_v_Gy_QCCheckItemList_Edit"); | 
|   | 
|                 objJsonResult.code = "1"; | 
|                 objJsonResult.count = 1; | 
|                 objJsonResult.Message = ""; | 
|                 objJsonResult.data = ds.Tables[0]; | 
|                 return objJsonResult; | 
|             } | 
|             catch (Exception e) | 
|             { | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 0; | 
|                 objJsonResult.Message = "Exception!" + e.ToString(); | 
|                 objJsonResult.data = null; | 
|                 return objJsonResult; | 
|             } | 
|         } | 
|         #endregion | 
|   | 
|         #region 检验项目获取树型列表数据 | 
|         [Route("Gy_CheckItem/LoadTree")] | 
|         [HttpGet] | 
|         public object LoadTree_Json(string sWhere) | 
|         { | 
|             SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN(); | 
|             //ds = oCN.RunProcReturn("select * from h_v_IF_GroupList " + sWhere, "h_v_IF_GroupList"); | 
|   | 
|             ds = oCN.RunProcReturn("select * from h_v_Gy_QCCheckItemLoadTree", "h_v_Gy_QCCheckItemLoadTree"); | 
|             if (ds == null || ds.Tables[0].Rows.Count == 0) | 
|             { | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 0; | 
|                 objJsonResult.Message = "false!"; | 
|                 objJsonResult.data = null; | 
|                 return objJsonResult; | 
|             } | 
|             else | 
|             { | 
|                 objJsonResult.code = "1"; | 
|                 objJsonResult.count = 1; | 
|                 objJsonResult.Message = "Sucess!"; | 
|                 objJsonResult.data = ds.Tables[0]; | 
|                 return objJsonResult; | 
|             } | 
|         } | 
|         #endregion | 
|   | 
|         #region 检验项目审核/反审核 | 
|         [Route("Gy_CheckItem/AuditGy_CheckItem")] | 
|         [HttpGet] | 
|         public object AuditGy_CheckItem(string HInterID, int Type, string user) | 
|         { | 
|             try | 
|             { | 
|                 //判断是否有审核权限 | 
|                 if (!DBUtility.ClsPub.Security_Log("Gy_QCCheckItem_Check", 1, false, user)) | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 0; | 
|                     objJsonResult.Message = "无权限审核!"; | 
|                     objJsonResult.data = null; | 
|                     return objJsonResult; | 
|                 } | 
|   | 
|                 if (string.IsNullOrWhiteSpace(HInterID)) | 
|                 { | 
|                     objJsonResult.code = "0"; | 
|                     objJsonResult.count = 0; | 
|                     objJsonResult.Message = "HInterID为空!"; | 
|                     objJsonResult.data = null; | 
|                     return objJsonResult; | 
|                 } | 
|   | 
|                 ClsPub.CurUserName = user; | 
|                 oCN.BeginTran();//开始事务 | 
|   | 
|                 //Type 1 审核  2  反审核 | 
|                 if (Type == 1) | 
|                 { | 
|                     //判断单据是否已经审核 | 
|                     DataSet ds; | 
|                     string sql = "select * from  Gy_QCCheckItem where HItemID = " + HInterID; | 
|                     ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey); | 
|                     if (ds.Tables[0].Rows[0]["HCheckEmp"] != null && ds.Tables[0].Rows[0]["HCheckEmp"].ToString() != "") | 
|                     { | 
|                         objJsonResult.code = "0"; | 
|                         objJsonResult.count = 0; | 
|                         objJsonResult.Message = "单据已审核!不能再次审核!"; | 
|                         objJsonResult.data = null; | 
|                         return objJsonResult; | 
|                     } | 
|                     //审核单据 | 
|                     if (!BillOld.AuditByID2(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo)) | 
|                     { | 
|                         objJsonResult.code = "0"; | 
|                         objJsonResult.count = 1; | 
|                         objJsonResult.Message = "审核失败!原因:" + ClsPub.sExeReturnInfo; | 
|                         objJsonResult.data = null; | 
|                         return objJsonResult; | 
|                     } | 
|                 } | 
|   | 
|                 else | 
|                 { | 
|                     //判断单据是否已经反审核 | 
|                     DataSet ds; | 
|                     string sql = "select * from  Gy_QCCheckItem where HItemID = " + HInterID; | 
|                     ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey); | 
|                     if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) | 
|                     { | 
|                         if (ds.Tables[0].Rows[0]["HCheckEmp"] == null || ds.Tables[0].Rows[0]["HCheckEmp"].ToString() == "") | 
|                         { | 
|                             objJsonResult.code = "0"; | 
|                             objJsonResult.count = 0; | 
|                             objJsonResult.Message = "单据未审核!不需要反审核!"; | 
|                             objJsonResult.data = null; | 
|                             return objJsonResult; | 
|                         } | 
|                         //反审核单据 | 
|                         if (!BillOld.DeAuditByID2(Int64.Parse(HInterID), ref ClsPub.sExeReturnInfo)) | 
|                         { | 
|                             objJsonResult.code = "0"; | 
|                             objJsonResult.count = 1; | 
|                             objJsonResult.Message = "反审核失败!原因:" + ClsPub.sExeReturnInfo; | 
|                             objJsonResult.data = null; | 
|                             return objJsonResult; | 
|                         } | 
|                     } | 
|                 } | 
|   | 
|                 oCN.Commit();//提交事务 | 
|   | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 1; | 
|                 objJsonResult.Message = "执行成功!"; | 
|                 objJsonResult.data = null; | 
|                 return objJsonResult; ; | 
|   | 
|             } | 
|             catch (Exception e) | 
|             { | 
|                 objJsonResult.code = "0"; | 
|                 objJsonResult.count = 0; | 
|                 objJsonResult.Message = "执行失败!" + e.ToString(); | 
|                 objJsonResult.data = null; | 
|                 return objJsonResult; | 
|             } | 
|         } | 
|         #endregion | 
|   | 
|     } | 
| } |