using Newtonsoft.Json; using Newtonsoft.Json.Linq; using Pub_Class; using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Web.Http; using WebAPI.Models; namespace WebAPI.Controllers { //工序检验单Controller //数据库主表QC_ProcessCheckBillMain //数据库子表QC_ProcessCheckBillSub public class QC_ProcessCheckBillController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus; private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); public DAL.ClsQC_ProcessCheckBill BillOld = new DAL.ClsQC_ProcessCheckBill(); DataSet ds; //获取系统参数 Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); //#region 工序检验单列表 //[Route("QC_ProcessCheckBill/QC_ProcessCheckBillList")] //[HttpGet] //public object QC_ProcessCheckBillList(string sWhere, string user) //{ // try // { // List columnNameList = new List(); // string sql1 = "select * from h_v_QC_ProcessCheckBill where 1 = 1 "; // string sql = sql1 + sWhere + " order by hmainid desc"; // ds = oCN.RunProcReturn(sql, "h_v_QC_ProcessCheckBill"); // //添加列名 // 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) // { // objJsonResult.code = "1"; // objJsonResult.count = 1; // objJsonResult.Message = "Sucess！"; // objJsonResult.list = columnNameList; // objJsonResult.data = ds.Tables[0]; // return objJsonResult; // } // else // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "没有查询到数据"; // objJsonResult.list = columnNameList; // 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("QC_ProcessCheckBill/QC_ProcessCheckBillList")] [HttpGet] public object QC_ProcessCheckBillList(string sWhere, string user) { try { List columnNameList = new List(); string sql1 = "select * from h_v_QC_ProcessCheckBill where 1 = 1 "; string sql = sql1 + sWhere + " order by 制单日期 desc"; ds = oCN.RunProcReturn(sql, "h_v_QC_ProcessCheckBill"); //添加列名 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) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.list = columnNameList; objJsonResult.data = ds.Tables[0]; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有查询到数据"; objJsonResult.list = columnNameList; 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 工序检验单列表2 只获取表头数据，不取明细行信息 [Route("QC_ProcessCheckMainBill/QC_ProcessCheckMainBillList")] [HttpGet] public object QC_ProcessCheckMainBillList(string sWhere, string user) { try { List columnNameList = new List(); //判断权限 if (!DBUtility.ClsPub.Security_Log("QC_ProcessCheckBill_Query", 3, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "您没有该模块权限,请与管理员联系！"; objJsonResult.data = null; return objJsonResult; } string sql1 = "select * from h_v_QC_ProcessCheckBillMainList where 1 = 1 "; string sql = sql1 + sWhere + " order by 制单日期 desc"; ds = oCN.RunProcReturn(sql, "h_v_QC_ProcessCheckBillMainList"); //添加列名 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) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.list = columnNameList; objJsonResult.data = ds.Tables[0]; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有查询到数据"; objJsonResult.list = columnNameList; 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("QC_ProcessCheckBill/QC_ProcessCheckBill_Edit")] [HttpGet] public object QC_ProcessCheckBill_Edit(string sWhere, string user) { try { List columnNameList = new List(); string sql1 = "select * from h_v_QC_ProcessCheckBill_Edit where 1 = 1 "; string sql = sql1 + sWhere + " order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_QC_ProcessCheckBill_Edit"); //添加列名 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) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.list = columnNameList; objJsonResult.data = ds.Tables[0]; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有查询到数据"; objJsonResult.list = columnNameList; 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 工序检验单 审核 反审核 关闭 反关闭 作废 反作废 /// /// 工序检验单 审核、反审核 /// /// 单据ID /// 审核(0),反审核(1) /// 审核人 /// [Route("QC_ProcessCheckBill/QC_ProcessCheckBillMainValue")] [HttpGet] public object QC_ProcessCheckBillMainValue(int HInterID, int IsAudit, string CurUserName) { try { //审核权限 if (!DBUtility.ClsPub.Security_Log_second("QC_ProcessCheckBill_Check", 1, false, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败！无权限！"; objJsonResult.data = null; return objJsonResult; } var ds = oCN.RunProcReturn("select * from QC_ProcessCheckBillMain where HInterID=" + HInterID, "QC_ProcessCheckBillMain"); if (ds.Tables[0].Rows.Count > 0) { if (IsAudit == 0) //审核判断 { if (ds.Tables[0].Rows[0]["HChecker"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已审核!不能再次审核！"; objJsonResult.data = null; return objJsonResult; } } if (IsAudit == 1) //反审核判断 { if (ds.Tables[0].Rows[0]["HChecker"].ToString() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据未审核!不需要反审核!"; objJsonResult.data = null; return objJsonResult; } } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据不存在!"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran(); if (IsAudit == 0) //审核判断 { //审核前控制 DataSet BeforeDs = oCN.RunProcReturn("Exec h_p_QC_ProcessCheckBill_BeforeCheckCtrl " + HInterID.ToString() + ",'" + CurUserName + "'", "h_p_QC_ProcessCheckBill_BeforeCheckCtrl "); if (BeforeDs == null || BeforeDs.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核前判断失败！"; objJsonResult.data = null; return objJsonResult; } else { if (DBUtility.ClsPub.isLong(BeforeDs.Tables[0].Rows[0]["HBack"]) == 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(BeforeDs.Tables[0].Rows[0]["HRemark"]); objJsonResult.data = null; return objJsonResult; } } oCN.RunProc("update QC_ProcessCheckBillMain set HChecker='" + CurUserName + "',HCheckDate=getdate() where HInterID=" + HInterID); //审核后控制 DataSet EndDs = oCN.RunProcReturn("Exec h_p_QC_ProcessCheckBill_AfterCheckCtrl " + HInterID.ToString() + ",'" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','" + CurUserName + "'", "h_p_QC_ProcessCheckBill_AfterCheckCtrl"); if (EndDs == null || EndDs.Tables.Count == 0 || EndDs.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核后判断失败！"; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } else { if (DBUtility.ClsPub.isLong(EndDs.Tables[0].Rows[0]["HBack"]) == 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败！" + DBUtility.ClsPub.isStrNull(EndDs.Tables[0].Rows[0]["HRemark"]); objJsonResult.data = null; return objJsonResult; } } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "审核成功"; objJsonResult.data = null; } if (IsAudit == 1) //反审核判断 { //反审核前控制 DataSet BeforeDs = oCN.RunProcReturn("Exec h_p_QC_ProcessCheckBill_BeforeUnCheckCtrl " + HInterID.ToString() + ",'" + CurUserName + "'", "h_p_QC_ProcessCheckBill_BeforeUnCheckCtrl"); if (BeforeDs == null || BeforeDs.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "反审核前判断失败！"; objJsonResult.data = null; return objJsonResult; } else { if (DBUtility.ClsPub.isLong(BeforeDs.Tables[0].Rows[0]["HBack"]) == 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "反审核失败！" + DBUtility.ClsPub.isStrNull(BeforeDs.Tables[0].Rows[0]["HRemark"]); objJsonResult.data = null; return objJsonResult; } } oCN.RunProc("update QC_ProcessCheckBillMain set HChecker='',HCheckDate=null where HInterID=" + HInterID); //反审核后控制 DataSet EndDs = oCN.RunProcReturn("Exec h_p_QC_ProcessCheckBill_AfterUnCheckCtrl " + HInterID.ToString() + ",'" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','" + CurUserName + "'", " h_p_QC_ProcessCheckBill_AfterUnCheckCtrl"); if (EndDs == null || EndDs.Tables.Count == 0 || EndDs.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "反审核后判断失败！"; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } else { if (DBUtility.ClsPub.isLong(EndDs.Tables[0].Rows[0]["HBack"]) == 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "反审核失败！" + DBUtility.ClsPub.isStrNull(EndDs.Tables[0].Rows[0]["HRemark"]); objJsonResult.data = null; return objJsonResult; } } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "反审核成功"; objJsonResult.data = null; } oCN.Commit(); return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "审核失败或者反审核失败！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } /// /// 工序检验单 关闭 反关闭 /// /// /// /// /// [Route("QC_ProcessCheckBill/CloseQC_ProcessCheckBillMain")] [HttpGet] public object CloseQC_ProcessCheckBillMain(string HInterID, int Type, string user) { try { //判断是否有删除权限 if (!DBUtility.ClsPub.Security_Log("QC_ProcessCheckBill_Close", 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; BillOld.MvarItemKey = "QC_ProcessCheckBillMain"; oCN.BeginTran();//开始事务 //Type 1 关闭 2 反关闭 if (Type == 1) { //判断单据是否已经关闭 DataSet ds; string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID; ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据不存在！"; objJsonResult.data = null; return objJsonResult; } if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已作废!不能进行关闭!"; objJsonResult.data = null; return objJsonResult; } if (ds.Tables[0].Rows[0]["HCloseMan"] != null && ds.Tables[0].Rows[0]["HCloseMan"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已关闭!不能再次关闭!"; objJsonResult.data = null; return objJsonResult; } //关闭单据 if (!BillOld.CloseBill(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 " + BillOld.MvarItemKey + " where HinterID = " + HInterID; ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey); if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已作废!不能进行关闭!"; objJsonResult.data = null; return objJsonResult; } if (ds.Tables[0].Rows[0]["HCloseMan"] == null || ds.Tables[0].Rows[0]["HCloseMan"].ToString() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据未关闭!不需要再反关闭!"; objJsonResult.data = null; return objJsonResult; } //反关闭单据 if (!BillOld.CancelClose(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; } } /// /// 工序检验单 作废 反作废 /// /// /// /// /// [Route("QC_ProcessCheckBill/DropQC_ProcessCheckBillMain")] [HttpGet] public object DropQC_ProcessCheckBillMain(string HInterID, int Type, string user) { try { //判断是否有作废权限 if (!DBUtility.ClsPub.Security_Log("QC_ProcessCheckBill_Drop", 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; BillOld.MvarItemKey = "QC_ProcessCheckBillMain"; oCN.BeginTran();//开始事务 //Type 1 作废 2 反作废 if (Type == 1) { //判断单据是否已经作废 DataSet ds; string sql = "select * from " + BillOld.MvarItemKey + " where HinterID = " + HInterID; ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据不存在！"; objJsonResult.data = null; return objJsonResult; } if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已审核!不能进行作废!"; objJsonResult.data = null; return objJsonResult; } if (ds.Tables[0].Rows[0]["HDeleteMan"] != null && ds.Tables[0].Rows[0]["HDeleteMan"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已作废!不需要再作废!"; objJsonResult.data = null; return objJsonResult; } //作废单据 if (!BillOld.Cancelltion(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 " + BillOld.MvarItemKey + " where HinterID = " + HInterID; ds = oCN.RunProcReturn(sql, BillOld.MvarItemKey); if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据已审核!不能进行作废!"; objJsonResult.data = null; return objJsonResult; } if (ds.Tables[0].Rows[0]["HDeleteMan"] == null || ds.Tables[0].Rows[0]["HDeleteMan"].ToString() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据未作废!不需要再反作废!"; objJsonResult.data = null; return objJsonResult; } //反作废单据 if (!BillOld.AbandonCancelltion(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 /// /// 返回工序检验单列表 ///参数：string sql。 ///返回值：object。 /// [Route("QC_ProcessCheckBill/GetProcessCheckBillList")] [HttpGet] public object GetProcessCheckBillList(string sWhere, string user) { try { //查看权限 if (!DBUtility.ClsPub.Security_Log("QC_ProcessCheckBill_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_QC_ProcessCheckBillListDetail order by hmainid desc ", "h_v_QC_ProcessCheckBillListDetail"); } else { string sql1 = "select * from h_v_QC_ProcessCheckBillListDetail where 1 = 1 "; string sql = sql1 + sWhere + " order by hmainid desc "; ds = oCN.RunProcReturn(sql, "h_v_QC_ProcessCheckBillListDetail"); } //if (ds.Tables[0].Rows.Count != 0 || ds != null) //{ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; 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; } } #region 工序检验单保存 /// /// 新增单据-保存按钮 ///参数：string sql。 ///返回值：object。 /// [Route("QC_ProcessCheckBill/set_SaveBill")] [HttpPost] public object set_SaveBill([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); //保存单据 return objJsonResult = AddBillMain(msg1); } public json AddBillMain(string msg1) { string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string OperationType = sArray[2].ToString().Trim(); string user = sArray[3].ToString();//用户名 bool bResult; try { //判断权限 if (!DBUtility.ClsPub.Security_Log("QC_ProcessCheckBill_Edit", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无保存权限"; objJsonResult.data = null; return objJsonResult; } msg2 = "[" + msg2.ToString() + "]"; List mainList = Newtonsoft.Json.JsonConvert.DeserializeObject>(msg2); DAL.ClsQC_ProcessCheckBill BillNew = new DAL.ClsQC_ProcessCheckBill(); //判断会计期是否合理 string s = ""; int sYear = 0; int sPeriod = 0; DateTime HDate = mainList[0].HDate;//日期 if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s; objJsonResult.data = null; return objJsonResult; } BillNew.omodel.HYear = sYear; BillNew.omodel.HPeriod = sPeriod; //固定赋值================================= BillNew.omodel.HInterID = mainList[0].HInterID;//递入type得到的单据ID BillNew.omodel.HBillNo = mainList[0].HBillNo;//递入type得到的单据号 BillNew.omodel.HDate = HDate; BillNew.omodel.HRemark = mainList[0].HRemark;//备注 BillNew.omodel.HMaker = mainList[0].HMaker; BillNew.omodel.HSourceID = ClsPub.isLong(mainList[0].HSourceID); BillNew.omodel.HICMOInterID = ClsPub.isLong(mainList[0].HICMOInterID); BillNew.omodel.HICMOBillNo = ClsPub.isStrNull(mainList[0].HICMOBillNo); BillNew.omodel.HICMOEntryID = ClsPub.isLong(mainList[0].HICMOEntryID); BillNew.omodel.HICMOQty = ClsPub.isLong(mainList[0].HICMOQty); BillNew.omodel.HProcExchInterID = ClsPub.isLong(mainList[0].HProcExchInterID); BillNew.omodel.HProcExchEntryID = ClsPub.isLong(mainList[0].HProcExchEntryID); BillNew.omodel.HProcExchBillNo = ClsPub.isStrNull(mainList[0].HProcExchBillNo); BillNew.omodel.HProcExchQty = ClsPub.isLong(mainList[0].HProcExchQty); BillNew.omodel.HMaterID = ClsPub.isLong(mainList[0].HMaterID); BillNew.omodel.HFirstCheckEmp = ClsPub.isLong(mainList[0].HFirstCheckEmp); BillNew.omodel.HCheckerResult = ClsPub.isStrNull(mainList[0].HCheckerResult); BillNew.omodel.HMainSourceInterID = ClsPub.isLong(mainList[0].HMainSourceInterID); BillNew.omodel.HMainSourceEntryID = ClsPub.isLong(mainList[0].HMainSourceEntryID); BillNew.omodel.HMainSourceBillNo = ClsPub.isStrNull(mainList[0].HMainSourceBillNo); BillNew.omodel.HMainSourceBillType = ClsPub.isStrNull(mainList[0].HMainSourceBillType); BillNew.omodel.HQCSchemeID = ClsPub.isLong(mainList[0].HQCSchemeID); BillNew.omodel.HBillStatus = 1; BillNew.omodel.HProcID = ClsPub.isLong(mainList[0].HProcID); BillNew.omodel.HShiftsID = ClsPub.isLong(mainList[0].HShiftsID); BillNew.omodel.HErrTreatment = ClsPub.isStrNull(mainList[0].HErrTreatment); BillNew.omodel.HBatchNo = ClsPub.isStrNull(mainList[0].HBatchNo); BillNew.omodel.HTakeSampleCheckBillID = ClsPub.isLong(mainList[0].HTakeSampleCheckBillID); BillNew.omodel.HTakeSampleCheckBillNo = ClsPub.isStrNull(mainList[0].HTakeSampleCheckBillNo); List subList = Newtonsoft.Json.JsonConvert.DeserializeObject>(msg3); BillNew.DetailColl = new List(); for (int i = 0; i < subList.ToArray().Length; i++) { if (i >= 0)//HQty { Model.ClsQC_ProcessCheckBillSub oSub = new Model.ClsQC_ProcessCheckBillSub(); oSub.HEntryID = i+1; oSub.HRemark = ClsPub.isStrNull(subList[i].HRemark); oSub.HSourceInterID = ClsPub.isLong(subList[i].HSourceInterID); oSub.HSourceEntryID = ClsPub.isLong(subList[i].HSourceEntryID); oSub.HSourceBillType = ClsPub.isStrNull(subList[i].HSourceBillType); oSub.HSourceBillNo = ClsPub.isStrNull(subList[i].HSourceBillNo); oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[i].HRelationQty); oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[i].HRelationMoney); oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[i].HCloseMan); oSub.HCloseType = DBUtility.ClsPub.isBool(subList[i].HCloseType); oSub.HQCCheckItemID = DBUtility.ClsPub.isLong(subList[i].HQCCheckItemID); oSub.HQCStd = DBUtility.ClsPub.isStrNull(subList[i].HQCStd); oSub.HResult = DBUtility.ClsPub.isStrNull(subList[i].HResult); oSub.HQCRelValue = DBUtility.ClsPub.isStrNull(subList[i].HQCRelValue); oSub.HProcCheckTime = HDate; oSub.HBillNo_bak = DBUtility.ClsPub.isStrNull(mainList[0].HBillNo); oSub.HProcCheckEmp = ClsPub.isLong(mainList[0].HFirstCheckEmp); oSub.HSampleSchemeID = DBUtility.ClsPub.isLong(subList[i].HSampleSchemeID); oSub.HSampleQty = DBUtility.ClsPub.isLong(subList[i].HSampleQty); oSub.HSampleDamageQty = DBUtility.ClsPub.isDoule(subList[i].HSampleDamageQty); oSub.HAcceptQty = DBUtility.ClsPub.isLong(subList[i].HAcceptQty); oSub.HRejectQty = DBUtility.ClsPub.isLong(subList[i].HRejectQty); oSub.HSampleUnRightQty = DBUtility.ClsPub.isDoule(subList[i].HSampleUnRightQty); oSub.HStatus = DBUtility.ClsPub.isStrNull(subList[i].HStatus); oSub.HUnitID = DBUtility.ClsPub.isLong(subList[i].HUnitID); oSub.HInspectVal = DBUtility.ClsPub.isStrNull(subList[i].HInspectVal); oSub.HTargetVal = DBUtility.ClsPub.isStrNull(subList[i].HTargetVal); oSub.HUpLimit = DBUtility.ClsPub.isStrNull(subList[i].HUpLimit); oSub.HDownLimit = DBUtility.ClsPub.isStrNull(subList[i].HDownLimit); oSub.HQCNote = DBUtility.ClsPub.isStrNull(subList[i].HQCNote); oSub.HUpOffSet = DBUtility.ClsPub.isStrNull(subList[i].HUpOffSet); oSub.HDownOffSet = DBUtility.ClsPub.isStrNull(subList[i].HDownOffSet); oSub.HAnalysisMethod = DBUtility.ClsPub.isStrNull(subList[i].HAnalysisMethod); oSub.HKeyInspect = DBUtility.ClsPub.isLong(subList[i].HKeyInspect); oSub.HInspectInstruMentID = DBUtility.ClsPub.isLong(subList[i].HInspectInstruMentID); oSub.HInspectResult = DBUtility.ClsPub.isStrNull(subList[i].HResult); BillNew.DetailColl.Add(oSub); } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无明细行信息!"; objJsonResult.data = null; return objJsonResult; } } //保存完毕后处理 if (OperationType.Equals("1") || OperationType.Equals("2")) { bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); } else { bResult = BillNew.ModifyBill(BillNew.omodel.HInterID, ref ClsPub.sExeReturnInfo); } //提示 if (bResult == true) { objJsonResult.code = "1"; objJsonResult.count = 1; //objJsonResult.Message = "单据存盘完毕!单据号:" + mainList[0].HBillNo.Trim(); objJsonResult.Message = ClsPub.sExeReturnInfo+"单据号:" + mainList[0].HBillNo.Trim(); objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败!原因:" + ClsPub.sExeReturnInfo; 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 检验值保存 [Route("QC_ProcessCheckBill/set_SaveValue")] [HttpPost] public object set_SaveValue([FromBody] JObject msg) { ListModels oListModels = new ListModels(); try { var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string Value = sArray[0].ToString(); //检验值表格 Int64 HInterID = Convert.ToInt64(sArray[1]); //主ID Int64 HEntryID = Convert.ToInt64(sArray[2]); //子ID bool bResult; List valueList = new List(); valueList = oListModels.getObjectByJson_ClsQC_ProcessCheckBillSub_ValueGrid(Value); DAL.ClsQC_ProcessCheckBill BillNew = new DAL.ClsQC_ProcessCheckBill(); for (int i = 0; i < valueList.ToArray().Length; i++) { if (i >= 0)//HQty { Model.ClsQC_ProcessCheckBillSub_ValueGrid oSub_Value = new Model.ClsQC_ProcessCheckBillSub_ValueGrid(); oSub_Value.HInterID = HInterID; oSub_Value.HEntryID = HEntryID; oSub_Value.HSEQ = i + 1; oSub_Value.HInSpectResult = ClsPub.isStrNull(valueList[i].HInSpectResult); oSub_Value.HInSpectValue = ClsPub.isDoule(valueList[i].HInSpectValue); oSub_Value.HInSpectValueB = ClsPub.isLong(valueList[i].HInSpectValueB); oSub_Value.HInSpectValueT = ClsPub.isStrNull(valueList[i].HInSpectValueT); BillNew.DetailColl_Value.Add(oSub_Value); } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无明细行信息!"; objJsonResult.data = null; return objJsonResult; } } bResult = BillNew.AddValue(ref ClsPub.sExeReturnInfo, ref HInterID, ref HEntryID); if (bResult == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "保存检验值成功"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败!原因:" + ClsPub.sExeReturnInfo; 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 工序检验单Old /// /// 工序检验单列表修改按钮方法 ///参数：string sql。 ///返回值：object。 /// [Route("QC_ProcessCheckBill/xg")] [HttpGet] public object xg(long HInterID) { try { ds = oCN.RunProcReturn("select HInterID,HBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" + ",HMaterID,HProcID,HSourceID,HEmpID,HInStockQty" + ",HCheckQty,HRightQty,HBadQty,HFirstCheckEmp,HCheckerResult" + ",HBarCode,HLBatchNo,HCusID,HSortBillNo,HContrctBatchNo" + ",HProdAreaID,HProdTypeID,HProdStoveNo,HRecipeID,HDiameter1" + ",HDiameter2,HRoutingInterID,HDrawingDireID,HPackTypeID from QC_ProcessCheckBillMain where HInterID=" + HInterID, "QC_ProcessCheckBillMain"); 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; } } /// /// 修改单据-保存按钮 ///参数：string sql。 ///返回值：object。 /// [Route("QC_ProcessCheckBill/AddBill1")] [HttpPost] public object AddBill1([FromBody] JObject oMain) { var _value = oMain["oMain"].ToString(); string msg1 = _value.ToString(); try { DAL.ClsQC_ProcessCheckBill oProcess = new DAL.ClsQC_ProcessCheckBill(); msg1 = "[" + msg1.ToString() + "]"; List mainList = Newtonsoft.Json.JsonConvert.DeserializeObject>(msg1); string BillType = "7507"; long HInterID = mainList[0].HInterID;//递入type得到的单据ID string HBillNo = mainList[0].HBillNo;//递入type得到的单据号 DateTime HDate = mainList[0].HDate;//日期 int HYear = 2021; double HPeriod = 1; long HBillStatus = mainList[0].HBillStatus; long HCheckItemNowID = mainList[0].HCheckItemNowID; long HCkeckItemNextID = mainList[0].HCheckItemNextID; long HCheckFlowID = mainList[0].HCheckFlowID; string HRemark = mainList[0].HRemark;//备注 string HBacker = mainList[0].HBacker; DateTime HBackDate = mainList[0].HBackDate; string HBackRemark = mainList[0].HBackRemark; string HChecker = mainList[0].HChecker; DateTime HCheckDate = mainList[0].HCheckDate; string HMaker = mainList[0].HMaker; DateTime HMakeDate = mainList[0].HMakeDate; string HUpDater = mainList[0].HUpDater; DateTime HUpDateDate = mainList[0].HUpDateDate; string HCloseMan = mainList[0].HCloseMan; DateTime HCloseDate = mainList[0].HCloseDate; string HCloseType = mainList[0].HCloseType; string HDeleteMan = mainList[0].HDeleteMan; DateTime HDeleteDate = mainList[0].HDeleteDate; string HMainSourceBillType = mainList[0].HMainSourceBillType; long HMainSourceInterID = mainList[0].HMainSourceInterID; long HMainSourceEntryID = mainList[0].HMainSourceEntryID; string HMainSourceBillNo = mainList[0].HMainSourceBillNo; double HPrintQty = mainList[0].HPrintQty; long HICMOInterID = mainList[0].HICMOInterID; string HICMOBillNo = mainList[0].HICMOBillNo; long HProExchInterID = mainList[0].HProcExchInterID; long HProExchEntryID = mainList[0].HProcExchEntryID; string HProExchBillNo = mainList[0].HProcExchBillNo; long HMaterID = mainList[0].HMaterID; long HProcID = mainList[0].HProcID; long HSourceID = mainList[0].HSourceID; long HEmpID = mainList[0].HEmpID; double HInStockQty = mainList[0].HInStockQty; double HCheckQty = mainList[0].HCheckQty; double HRightQty = mainList[0].HRightQty; double HBadQty = mainList[0].HBadQty; long HFirstCheckEmp = mainList[0].HFirstCheckEmp; string HCheckerResult = mainList[0].HCheckerResult; string HBarcode = mainList[0].HBarcode; string HLBatchNo = mainList[0].HLBatchNo; long HCusID = mainList[0].HCusID; string HSortBillNo = mainList[0].HSortBillNo; string HConTrctBatchNo = mainList[0].HContrctBatchNo; long HProdAreaID = mainList[0].HProdAreaID; long HProdTypeID = mainList[0].HProdTypeID; string HProdStoveNo = mainList[0].HProdStoveNo; long HRecipeID = mainList[0].HRecipeID; double HDiameter1 = mainList[0].HDiameter1; double HDiameter2 = mainList[0].HDiameter2; long HRoutingInterID = mainList[0].HRoutingInterID; long HPackTypeID = mainList[0].HPackTypeID; long HDrawingDireID = mainList[0].HDrawingDireID; //若MAINDI重复则重新获取 oCN.BeginTran(); //主表 oCN.RunProc("Update QC_ProcessCheckBillMain set " + "HMaterID=" + HMaterID + ",HSourceID=" + HSourceID + ",HEmpID=" + HEmpID + ",HInStockQty=" + HInStockQty + ",HCheckQty=" + HCheckQty + ",HRightQty=" + HRightQty + ",HBadQty=" + HBadQty + ",HCusID=" + HCusID + ",HRemark= '" + HRemark + "' Where HInterID=" + HInterID, ref DBUtility.ClsPub.sExeReturnInfo); //修改子项目代码 //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Department,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); //将上级 为非末级 //oCN.RunProc("Update Gy_Department set HEndflag=0 where HItemID=" + HInterID, 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; } } /// /// 工序检验单列表删除按钮 ///参数：string sql。 ///返回值：object。 /// [Route("QC_ProcessCheckBill/Delete_Json")] [HttpGet] public object Delete_Json(long HItemID,string user) { DAL.ClsQC_ProcessCheckBill BillOld = new DAL.ClsQC_ProcessCheckBill(); try { //查看权限 if (!DBUtility.ClsPub.Security_Log("QC_ProcessCheckBill_Delete", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "无删除权限！"; objJsonResult.data = null; return objJsonResult; } var ds = oCN.RunProcReturn("select * from QC_ProcessCheckBillMain where HInterID=" + HItemID, "QC_ProcessCheckBillMain"); //删除前控制 DataSet BeforeDs = oCN.RunProcReturn("Exec h_p_QC_ProcessCheckBill_BeforeDelCtrl " + HItemID.ToString() + ",'" + user + "'", "h_p_QC_ProcessCheckBill_BeforeDelCtrl"); if (BeforeDs == null || BeforeDs.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "删除前判断失败！"; objJsonResult.data = null; return objJsonResult; } else { if (DBUtility.ClsPub.isLong(BeforeDs.Tables[0].Rows[0]["HBack"]) == 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "删除失败！" + DBUtility.ClsPub.isStrNull(BeforeDs.Tables[0].Rows[0]["HRemark"]); objJsonResult.data = null; return objJsonResult; } } if (BillOld.DeleteBill(HItemID, ds.Tables[0].Rows[0]["HBillNo"].ToString(), "h_p_QC_ProcessCheckBill_AfterDelCtrl", user, ref ClsPub.sExeReturnInfo) != true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "删除成功"; objJsonResult.data = null; return objJsonResult; } 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 /// ///返回检验值列表 /// /// /// [Route("QC_ValueTable_ProcessCheck/getValueList")] [HttpGet] public object getValueList(Int64 HInterID, Int64 HEntryID, string user) { DataSet ds; try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ds = oCN.RunProcReturn("select * from QC_ProcessCheckBillSub_ValueGrid where HInterID=" + HInterID + " and HEntryID=" + HEntryID, "QC_ProcessCheckBillSub_ValueGrid"); if (ds.Tables[0].Rows.Count > 0) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有查询到数据！"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "没有返回任何记录！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #region 首件检验单根据源单类型获取信息-源单为工序出站单 [Route("QC_ProcessCheckBill/get_StationOutBill")] [HttpGet] public object get_StationOutBill(string HInterID, string user) { try { List columnNameList = new List(); string sReturn = ""; string sql = ""; if (oSystemParameter.ShowBill(ref sReturn)) { switch (oSystemParameter.omodel.QC_ProcessCheckBill_QCSchemeSource) { case "工序": sql = "exec h_p_QC_ProcessCheck_GetStationOutBillList " + "'工序','" + HInterID + "'"; break; case "物料": sql = "exec h_p_QC_ProcessCheck_GetStationOutBillList " + "'物料','" + HInterID + "'"; break; case "工艺路线": sql = "exec h_p_QC_ProcessCheck_GetStationOutBillList " + "'工艺路线','" + HInterID + "'"; break; } } ds = oCN.RunProcReturn(sql, "h_p_QC_ProcessCheck_GetStationOutBillList"); //添加列名 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列对象的列名 } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucess！"; objJsonResult.list = columnNameList; 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 工序检验单根据源单类型获取信息-源单为生产状态临时表（3722） /// ///参数：string sql。 ///返回值：object。 /// [Route("QC_ProcessCheckBill/get_ICMOBillStatus_Tmp")] [HttpGet] public object get_ICMOBillStatus_Tmp(int HInterID, int HEntryID, string HBillType) { try { List columnNameList = new List(); string sReturn = ""; string sql = ""; if (oSystemParameter.ShowBill(ref sReturn)) { switch (oSystemParameter.omodel.QC_ProcessCheckBill_QCSchemeSource) { case "工序": sql = "exec h_p_QC_GetInfoByICMOStatusBill " + "'工序'," + HInterID + "," + HEntryID + "," + HBillType; break; case "物料": sql = "exec h_p_QC_GetInfoByICMOStatusBill " + "'物料'," + HInterID + "," + HEntryID + "," + HBillType; break; case "工艺路线": sql = "exec h_p_QC_GetInfoByICMOStatusBill " + "'工艺路线'," + HInterID + "," + HEntryID + "," + HBillType; break; } } ds = oCN.RunProcReturn(sql, "h_p_QC_GetInfoByICMOStatusBill"); if (ds == null || ds.Tables[0].Rows.Count == 0) { } else { //添加列名 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 (HInterID == 0 || HBillType.Equals("")) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "参数不全，获取源单信息失败！HInterID：" + HInterID + "；HEntryID：" + HEntryID + "；HBillType：" + HBillType + "；"; // objJsonResult.data = null; // return objJsonResult; //} //else //{ // ds = oCN.RunProcReturn("exec h_p_QC_GetInfoByICMOStatusBill " + HInterID + "," + HEntryID + "," + HBillType, "h_p_QC_GetInfoByICMOStatusBill"); //} if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查询数据异常，请与管理员联系！"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "返回记录成功！"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "查询数据异常，请与管理员联系！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion } }