MES-WEB-API.git

			@@ -105,28 +105,8 @@

			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


			//判断用户是否拥有查看所有客户权限
			if (DBUtility.ClsPub.Security_Log_second("Gy_UserLookAllCus", 1, false, user))
			{
			ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillQuery where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeBillQuery");
			}
			else
			{
			//获取用户编码
			string sql = "select * from Gy_Czygl where Czymc = '" + user + "'";
			ds = oCN.RunProcReturn(sql, "Gy_Czygl");
			string userID = ds.Tables[0].Rows[0]["Czybm"].ToString();

			string sql1 = " and HCusID in (select HCusID from Gy_UserCustomerRelation Where HUserID = '" + userID + "')";
			string sql2 = "select * from h_v_Sc_ProcessExchangeBillQuery where 1 = 1 " + sWhere + sql1 + " order by hmainid desc ";
			ds = oCN.RunProcReturn(sql2, "h_v_Sc_ProcessExchangeBillQuery");
			}





			ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillQuery where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeBillQuery");


			//添加列名
			@@ -153,6 +133,92 @@
			return objJsonResult;
			}
			}

			#region 工序流转卡维护-查询
			/// <summary>
			/// 返回工序流转卡维护列表主表
			///参数：string sql。
			///返回值：object。
			/// </summary>
			[Route("LEMS/Sc_ProcessExchangeBillList_Query")]
			[HttpGet]
			public object Sc_ProcessExchangeBillList_Query(string sWhere, string user, string HBillSubType)
			{
			DataSet ds;
			try
			{
			List<object> columnNameList = new List<object>();
			if (HBillSubType == "SUB")
			{
			//判断是否有查询权限
			if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_SubQuery", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "指引卡无查询权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{

			//判断是否有查询权限
			if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Query", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "流转卡无查询权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			//获取系统参数
			string Ret = "";
			if (oSystemParameter.ShowBill(ref Ret))
			{
			//判断客户为龙山汽配
			if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配")
			{
			//获取需要拼接的字符串
			string sql_splice = DBUtility.ClsPub.SpliceSQL(user, "工序派工单列表");

			sWhere += sql_splice;
			}
			}

			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


			ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeBillList_Query where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeBillList_Query");


			//添加列名
			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 = "异常！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 工序流转卡下查
			/// <summary>
			@@ -326,6 +392,234 @@
			return objJsonResult;
			}
			}

			#region 工序流转卡只显示工序数据
			[Route("LEMS/MES_ProcessExchangeBillList_PG")]
			[HttpGet]
			public object MES_ProcessExchangeBillList_PG(string sWhere, string user, int OperationType)
			{
			DataSet ds;
			try
			{
			List<object> columnNameList = new List<object>();
			//判断是否有查询权限
			if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Query", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "无查询权限!";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (OperationType == 1)
			{
			//获取系统参数
			string Ret = "";
			if (oSystemParameter.ShowBill(ref Ret))
			{
			//判断客户为杭州斯莫尔
			if (oSystemParameter.omodel.WMS_CampanyName == "杭州斯莫尔")
			{
			sWhere += " ";

			}
			else
			{
			sWhere += " ";
			}
			}

			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			ds = oCN.RunProcReturn("select top 1000 * from h_v_Sc_ProcessExchangeArrangementList_PG where 1 = 1 " + sWhere + " order by hmainid desc ", "h_v_Sc_ProcessExchangeArrangementList_PG");
			}
			else
			{
			//获取系统参数
			string Ret = "";
			if (oSystemParameter.ShowBill(ref Ret))
			{
			//判断客户为杭州斯莫尔
			if (oSystemParameter.omodel.WMS_CampanyName == "杭州斯莫尔")
			{


			}
			}

			SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
			ds = oCN.RunProcReturn("select * from h_v_Sc_ProcessExchangeArrangementList_PG where 1 = 1 " + sWhere, "h_v_Sc_ProcessExchangeArrangementList_PG");
			}

			//添加列名
			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 = "异常！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 工序流转卡派工(斯莫尔)
			[Route("LEMS/ProcessExchangeArrangement_Add_PG")]
			[HttpGet]
			public object ProcessExchangeArrangement_Add_PG(string HInterID_S, int HSourceID, long HOrgID, string user)
			{
			DataSet ds;
			try
			{
			if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Edit", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "流转卡无编辑权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			var HNum = HInterID_S.Split(',');

			for (int j = 0; j < HNum.Length; j++)
			{
			long HInterID = long.Parse(HNum[j].Split('\|')[0]);
			long HEntryID = long.Parse(HNum[j].Split('\|')[1]);
			ds = oCN.RunProcReturn(@"select a.HMaterID,b.HProcID,a.HBillNo from Sc_ProcessExchangeBillMain a inner join Sc_ProcessExchangeBillSub b on a.HInterID=b.HInterID
			where a.HInterID=" + HInterID + " and b.HEntryID=" + HEntryID, "Sc_ProcessExchangeBillMain");
			if (ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "查无此工序流转卡！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			oCN.BeginTran();

			oCN.RunProc("update Sc_ProcessExchangeBillSub set HSourceID=" + HSourceID + " where HInterID=" + HInterID + " and HEntryID=" + HEntryID);

			oCN.RunProc("exec h_p_Sc_ICMOBillStatus_Tmp_PG " + HInterID + "," + HEntryID);

			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 = "异常！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 取消派工功能(斯莫尔)
			[Route("LEMS/ProcessExchangeArrangementDel_PG")]
			[HttpGet]
			public object ProcessExchangeArrangementDel_PG(string HInterID_S, int HSourceID, string user)
			{
			DataSet ds;
			DataSet ds1;
			try
			{
			if (!DBUtility.ClsPub.Security_Log("Sc_ProcessExchangeBill_Edit", 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "流转卡无编辑权限！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			var HNum = HInterID_S.Split(',');

			oCN.BeginTran();

			for (int j = 0; j < HNum.Length; j++)
			{

			long HInterID = long.Parse(HNum[j].Split('\|')[0]);
			long HEntryID = long.Parse(HNum[j].Split('\|')[1]);
			ds = oCN.RunProcReturn(@"select a.HMaterID,b.HProcID,a.HBillNo from Sc_ProcessExchangeBillMain a inner join Sc_ProcessExchangeBillSub b on a.HInterID=b.HInterID
			where a.HInterID=" + HInterID + " and b.HEntryID=" + HEntryID, "Sc_ProcessExchangeBillMain");
			if (ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "查无此工序流转卡！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			ds = oCN.RunProcReturn("select * from Sc_ICMOBillStatus_Tmp where HSourceInterID=" + HInterID + " and HSourceEntryID=" + HEntryID + " and HSourceID=" + HSourceID, "Sc_ICMOBillStatus_Tmp");

			if (ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "报工查无数据！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			if (ds.Tables[0].Rows[0]["HICMOStatus"].ToString() != "0")
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "流转卡对应的报工数据不为未开工状态,无法删除！";
			objJsonResult.data = null;
			return objJsonResult;
			}


			oCN.RunProc("update Sc_ProcessExchangeBillSub set HSourceID=0 where HInterID=" + HInterID + " and HEntryID=" + HEntryID);
			oCN.RunProc("delete from Sc_ICMOBillStatus_Tmp where HSourceInterID=" + HInterID + " and HSourceEntryID=" + HEntryID);
			}

			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 = "异常！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 排缸功能
			[Route("LEMS/ProcessExchangeArrangement_Add")]
			@@ -1349,6 +1643,7 @@
			List<object> columnNameList3 = new List<object>();
			List<object> columnNameList4 = new List<object>();
			List<object> columnNameList5 = new List<object>();
			List<object> columnNameList6 = new List<object>();

			string sql = "exec h_p_Sc_ICMOBillList_LookDown " + HInterID;
			ds = oCN.RunProcReturn(sql, "h_p_Xs_SeOrderBill_lookdown");
			@@ -1401,12 +1696,21 @@
			columnNameList5.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			//添加生产订单变更单列名
			foreach (DataColumn col in ds.Tables[6].Columns)
			{
			Type dataType = col.DataType;
			string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			columnNameList6.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			columnNameListSum.Add(columnNameList0);
			columnNameListSum.Add(columnNameList1);
			columnNameListSum.Add(columnNameList2);
			columnNameListSum.Add(columnNameList3);
			columnNameListSum.Add(columnNameList4);
			columnNameListSum.Add(columnNameList5);
			columnNameListSum.Add(columnNameList6);

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			@@ -2880,6 +3184,44 @@
			#endregion


			#region 报表查看权限控制
			/// <summary>
			///参数：string HInterID。
			///返回值：object。
			/// </summary>
			[Route("LMES/getReportByModRightNameCheck")]
			[HttpGet]
			public object getReportByModRightNameCheck(string ModRightNameCheck, string user)
			{
			try
			{
			string s = "";

			//查看权限
			if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, user))
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			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
			}
			}