MES-WEB-API.git

			@@ -27,7 +27,7 @@
			#region å·¡æ£ååè¡¨
			[Route("QC_PatrolProcCheckOtherBill/QC_PatrolProcCheckOtherBillList")]
			[HttpGet]
			public object QC_FirstPieceCheckBillList(string sWhere, string user)
			public object QC_PatrolProcCheckOtherBillList(string sWhere, string user)
			{
			try
			{
			@@ -66,7 +66,7 @@
			#region å·¡æ£åç¼è¾åæ¾
			[Route("QC_PatrolProcCheckOtherBill/QC_PatrolProcCheckOtherBillList_Edit")]
			[HttpGet]
			public object QC_FirstPieceCheckBillList_Edit(string sWhere, string user)
			public object QC_PatrolProcCheckOtherBillList_Edit(string sWhere, string user)
			{
			try
			{
			@@ -1079,5 +1079,455 @@
			}
			#endregion

			#region PDAå·¡æ£è®°å½å æ¥è¯¢åè¡¨
			[Route("QC_PatrolProcCheckOtherBill/QC_PatrolProcCheckOtherBillList_PDA")]
			[HttpGet]
			public object QC_PatrolProcCheckOtherBillList_PDA(string sWhere, string user)
			{
			try
			{

			//å¤ææ¯å¦æç¼è¾æé
			if (!DBUtility.ClsPub.Security_Log("QC_PatrolProcCheckOtherBill_Query", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ æ¥è¯¢æé!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			ds = oCN.RunProcReturn("select ManagerFlag from gy_czygl where czymc='" + user.Trim() + "'", "gy_czygl");
			string sErr = "";
			oSystemParameter.ShowBill(ref sErr);
			if (oSystemParameter.omodel.WMS_CampanyName == "ä¹ä¸")
			{
			}
			else
			{
			if (!(bool)ds.Tables[0].Rows[0]["ManagerFlag"]) //æ¯å¦ç®¡çå
			{
			//ä¸æ¯ç®¡çå
			sWhere += " and å¶åäºº = '" + user + "'";
			}
			}

			string sql = "select * from h_v_QC_PatrolProcCheckOtherBill where 1=1 " + sWhere;

			ds = oCN.RunProcReturn(sql, "h_v_QC_PatrolProcCheckOtherBill");

			DataTable dt = ds.Tables[0];

			//è·ååå
			List<object> columnNameList = new List<object>();
			//æ·»å åå
			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 = dt;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region PDAå·¡æ£è®°å½åæ°å¢ä¿å
			[Route("QC_PatrolProcCheckOtherBill/QC_PatrolProcCheckOtherBillAddBill_PDA")]
			[HttpPost]
			public object QC_PatrolProcCheckOtherBillAddBill_PDA([FromBody] JObject oMain)
			{
			var _value = oMain["oMain"].ToString();
			string msg1 = _value.ToString();
			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
			try
			{
			//ååºåå
			string msg2 = "[" + sArray[0].ToString() + "]";
			string user = sArray[1].ToString();//ç¨æ·å
			string OperationType = sArray[2].ToString();//ç±»å
			string msg_entry = sArray[3].ToString(); //æç»è¡ä¿¡æ¯

			//å¤ææ¯å¦æç¼è¾æé
			if (!DBUtility.ClsPub.Security_Log("QC_PatrolProcCheckOtherBill_Edit", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ ç¼è¾æé!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			DAL.ClsQC_PatrolProcCheckOtherBill BillNew = new DAL.ClsQC_PatrolProcCheckOtherBill();

			List<Model.ClsQC_PatrolProcCheckOtherBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsQC_PatrolProcCheckOtherBillMain>>(msg2);
			string BillType = "7505";
			string HBillSubType = "7505";
			long HInterID = list[0].HInterID;//éå¥typeå¾å°çåæ®ID
			string HBillNo = list[0].HBillNo;//éå¥typeå¾å°çåæ®å·
			int HBillStatus = 1;
			string HMaker = user;//å¶åäºº
			int HYear = DateTime.Now.Year;
			double HPeriod = DateTime.Now.Month;
			long HSourceID = list[0].HSourceID;//çäº§èµæº
			long HICMOInterID = list[0].HICMOInterID;//ä»»å¡åID
			long HICMOEntryID = list[0].HICMOEntryID;//ä»»å¡ååID
			string HICMOBillNo = list[0].HICMOBillNo;//ä»»å¡å
			string HProcExchBillNo = list[0].HProcExchBillNo;//æå¼å¡
			long HMaterID = list[0].HMaterID;//äº§åID
			//long HUnitID = list[0].HUnitID;//è®¡éåä½
			long HProcID = list[0].HProcID;//å·¥åºID
			long HPRDORGID = list[0].HPRDORGID;//ç»ç»ID
			bool HLastResult = list[0].HLastResult;//è¯æ ·ç»è®º
			long HQCSchemeID = list[0].HQCSchemeID;//æ£éªæ¹æ¡
			long HProcExchInterID = list[0].HProcExchInterID;//æµè½¬å¡ID
			long HProcExchEntryID = list[0].HProcExchEntryID;//æµè½¬å¡åID
			string HBatchNo = list[0].HBatchNo;//æµè½¬å¡æ¹æ¬¡å·
			long HMainSourceInterID = list[0].HMainSourceInterID;//æºåID
			long HMainSourceEntryID = list[0].HMainSourceEntryID;//æºååID
			string HMainSourceBillNo = list[0].HMainSourceBillNo;//æºååå·
			string HMainSourceBillType = list[0].HMainSourceBillType;//æºåç±»å

			//è¡¨ä½æ°æ®
			List<Model.ClsQC_PatrolProcCheckOtherBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsQC_PatrolProcCheckOtherBillSub>>(msg_entry);
			for (int i = 0; i < subList.ToArray().Length; i++)
			{
			if (subList.ToArray().Length >= 0)
			{
			Model.ClsQC_PatrolProcCheckOtherBillSub oSub = new Model.ClsQC_PatrolProcCheckOtherBillSub();
			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.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.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 == "True" ? 1 : 0);

			oSub.HQCNote = DBUtility.ClsPub.isStrNull(subList[i].HQCNote);//æ£éªè®°å½
			oSub.HMax = DBUtility.ClsPub.isStrNull(subList[i].HMax);
			oSub.HMin = DBUtility.ClsPub.isStrNull(subList[i].HMin);
			oSub.HAvg = DBUtility.ClsPub.isStrNull(subList[i].HAvg);



			BillNew.DetailColl.Add(oSub);
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ æç»è¡ä¿¡æ¯!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			//åæ®å®æ´æ§å¤æ
			if (HProcExchBillNo == "" && HMainSourceBillNo.Substring(0, Math.Min(2, HMainSourceBillNo.Length)) != "MO")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æµè½¬å¡æ²¡æéæ©ï¼è¯·æ«ææ¡å½¢ç æè¾å¥æ¡å½¢ç ååè½¦";
			objJsonResult.data = null;
			return objJsonResult;
			}

			var num = 0;

			oCN.BeginTran();
			if (OperationType == "1")
			{
			num = 1;

			ds = oCN.RunProcReturn("select * from QC_PatrolProcCheckOtherBillMain where HBillNo='" + HBillNo + "'", "QC_PatrolProcCheckOtherBillMain");
			if (ds.Tables[0].Rows.Count == 1)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ®å·éå¤ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			oCN.RunProc("Insert Into QC_PatrolProcCheckOtherBillMain " +
			"(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" +
			",HYear,HPeriod,HMaterID,HSourceID,HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchBillNo" +
			",HPRDORGID,HLastResult,HProcID,HQCSchemeID,HBatchNo," +
			"HProcExchInterID,HProcExchEntryID,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType)" +
			" values('" + BillType + "','" + HBillSubType + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate()" +
			"," + HYear + "," + HPeriod + ",'" + HMaterID + "','" + HSourceID + "'," + HICMOInterID + "," + HICMOEntryID + ",'" + HICMOBillNo + "','" + HProcExchBillNo + "'" +
			"," + HPRDORGID + ",'" + HLastResult + "','" + HProcID + "','" + HQCSchemeID + "','" + HBatchNo + "'," +
			"" + HProcExchInterID + "," + HProcExchEntryID + "," + HMainSourceInterID + "," + HMainSourceEntryID + ",'" + HMainSourceBillNo + "','" + HMainSourceBillType + "'" + ") ");

			//æå¥åè¡¨
			foreach (Model.ClsQC_PatrolProcCheckOtherBillSub oSub in BillNew.DetailColl)
			{
			string sql = "Insert into QC_PatrolProcCheckOtherBillSub " +
			" (HInterID,HBillNo_bak,HEntryID" +
			",HRemark,HSourceInterID" +
			",HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
			",HQCCheckItemID,HQCStd,HResult" +
			",HStatus,HUnitID,HKeyInspect,HAnalysisMethod,HInspectInstruMentID,HInspectResult," +
			"HQCNote,HMax,HMin,HAvg" +
			") values("
			+ HInterID.ToString() + ",'" + oSub.HBillNo_bak + "'," + oSub.HEntryID.ToString() + ",'" + oSub.HRemark + "'," + HMainSourceInterID.ToString() +
			"," + HMainSourceEntryID.ToString() + ",'" + HMainSourceBillNo + "','" + HMainSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
			"," + oSub.HQCCheckItemID.ToString() + ",'" + oSub.HQCStd + "','" + oSub.HResult + "'" +
			",'" + oSub.HStatus + "'," + oSub.HUnitID + "," + oSub.HKeyInspect + ",'" + oSub.HAnalysisMethod + "'," + oSub.HInspectInstruMentID + ",'" + oSub.HInspectResult + "'" +
			",'" + oSub.HQCNote + "','" + oSub.HMax + "','" + oSub.HMin + "','" + oSub.HAvg + "'" +
			")";

			oCN.RunProc("Insert into QC_PatrolProcCheckOtherBillSub " +
			" (HInterID,HBillNo_bak,HEntryID" +
			",HRemark,HSourceInterID" +
			",HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
			",HQCCheckItemID,HQCStd,HResult" +
			",HStatus,HUnitID,HKeyInspect,HAnalysisMethod,HInspectInstruMentID,HInspectResult," +
			"HQCNote,HMax,HMin,HAvg" +
			") values("
			+ HInterID.ToString() + ",'" + oSub.HBillNo_bak + "'," + oSub.HEntryID.ToString() + ",'" + oSub.HRemark + "'," + HMainSourceInterID.ToString() +
			"," + HMainSourceEntryID.ToString() + ",'" + HMainSourceBillNo + "','" + HMainSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
			"," + oSub.HQCCheckItemID.ToString() + ",'" + oSub.HQCStd + "','" + oSub.HResult + "'" +
			",'" + oSub.HStatus + "'," + oSub.HUnitID + "," + oSub.HKeyInspect + ",'" + oSub.HAnalysisMethod + "'," + oSub.HInspectInstruMentID + ",'" + oSub.HInspectResult + "'" +
			",'" + oSub.HQCNote + "','" + oSub.HMax + "','" + oSub.HMin + "','" + oSub.HAvg + "'" +
			") ");
			}
			}
			else
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æä½ç±»åæ æï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}

			oCN.Commit();

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "æ°å¢åæ®æåï¼";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			catch (Exception e)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region PDAå·¡æ£è®°å½å å®¡æ ¸/åå®¡æ ¸åè½
			[Route("QC_PatrolProcCheckOtherBill/CheckQC_PatrolProcCheckOtherBillBill_PDA")]
			[HttpGet]
			public object CheckQC_PatrolProcCheckOtherBillBill_PDA(string HInterID, int Type, string user)
			{
			try
			{
			//å¤ææ¯å¦æå é¤æé
			if (!DBUtility.ClsPub.Security_Log("QC_PatrolProcCheckOtherBill_Query", 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;
			}

			BillOld.MvarItemKey = "QC_PatrolProcCheckOtherBillMain";
			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.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;
			}
			}
			//å®¡æ ¸åæ®
			oCN.RunProc(" Update " + BillOld.MvarItemKey + " set HChecker='" + user + "',HCheckDate=getdate(),HBillStatus=2 Where HInterID=" + HInterID.ToString());

			}
			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;
			}
			}
			//åå®¡æ ¸åæ®
			oCN.RunProc(" Update " + BillOld.MvarItemKey + " set HChecker='',HCheckDate=null,HBillStatus=1 Where HInterID=" + HInterID.ToString());
			}

			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

			#region PDAå·¡æ£è®°å½å å é¤åè½
			[Route("QC_PatrolProcCheckOtherBill/DelQC_PatrolProcCheckOtherBillBill_PDA")]
			[HttpGet]
			public object DelQC_PatrolProcCheckOtherBillBill_PDA(Int64 lngBillKey, string user)
			{
			DataSet ds;
			string ModRightNameCheck = "QC_PatrolProcCheckOtherBill_Delete";
			try
			{
			//å é¤æé
			if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "å é¤å¤±è´¥ï¼æ æéï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}

			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			if (lngBillKey == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ®idä¸ºç©ºï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}


			oCN.BeginTran();//å¼å§äºå¡
			ds = oCN.RunProcReturn("select * from QC_PatrolProcCheckOtherBillMain where HInterID=" + lngBillKey, "QC_PatrolProcCheckOtherBillMain");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ²¡ææ°æ®ï¼æ æ³å é¤ï¼";
			objJsonResult.data = null;
			return objJsonResult; ;
			}
			string HChecker = Convert.ToString(ds.Tables[0].Rows[0]["HChecker"]);
			if (HChecker != "")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "åæ®å·²ç»å®¡æ ¸,ä¸è½å é¤ï¼";
			objJsonResult.data = null;
			return objJsonResult;
			}
			oCN.RunProc("Delete From QC_PatrolProcCheckOtherBillMain where HInterID = " + lngBillKey);
			oCN.RunProc("Delete From QC_PatrolProcCheckOtherBillSub where HInterID = " + lngBillKey);
			oCN.RunProc("Delete From QC_PatrolProcCheckOtherBillSub_ValueGrid where HInterID = " + lngBillKey);
			oCN.RunProc("Delete From QC_PatrolProcCheckOtherBillSub_Result where HInterID = " + lngBillKey);

			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

			}
			}