ZQHApi.git - Gitblit

			@@ -127,7 +127,8 @@
			//获取最大单据号
			if (i == 1) //首单获取工单号
			{
			sql = @"select isnull(max(substring(wo_code,charindex('_',wo_code)+1,len(wo_code)-charindex('_',wo_code))),0)+1 as worknumb from TK_Wrk_Man where m_po=@erpordercode";
			sql = @"select isnull(max(cast(substring(wo_code,charindex('_',wo_code)+1,len(wo_code)-charindex('_',wo_code)) as numeric)),0)+1 as worknumb
			from TK_Wrk_Man where m_po=@erpordercode";
			dynamicParams.Add("@erpordercode", erpordercode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			num = Convert.ToInt32(data.Rows[0]["WORKNUMB"].ToString());
			@@ -559,7 +560,6 @@
			}
			#endregion


			#region【生产管理、工单新增、编辑时,选择排程是时获取物料清单版本号】
			public static ToMessage JobCreationSonAddVison(string partnumber)
			{
			@@ -640,6 +640,33 @@
			}
			}
			}
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[MES工单新增、获取工单号]
			public static ToMessage AddMesOrderCodeSearch()
			{
			string sql = "";
			string wo_code = "";
			var dynamicParams = new DynamicParameters();
			try
			{
			//获取单据号
			sql = @"SELECT 'SGPO'+CONVERT(varchar(12) , getdate(), 112 )+'_'+cast(isnull(max(cast(substring(wo_code,charindex('_',wo_code)+1,len(wo_code)-charindex('_',wo_code)) as numeric)),0)+1 as varchar) as numct
			FROM TK_Wrk_Man where wo_code like '%SGPO%'";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data.Rows[0]["numct"].ToString();
			}
			catch (Exception e)
			{
			@@ -1077,6 +1104,171 @@
			#endregion


			#region[生产开报工扫码获取当前工序对应的设备(自制)]
			public static ToMessage MesOrderStepEqpSearch(string orderstepqrcode)
			{
			var sql = "";
			string search = "";//定义一个查询参数,查询条件有前端传入
			string ordercode = "";
			string stepcode = "";
			var dynamicParams = new DynamicParameters();
			try
			{
			if (orderstepqrcode != "" && orderstepqrcode != null)
			{
			string[] arra = orderstepqrcode.Split(';');
			if (arra.Length == 1) //工单号二维码
			{
			ordercode = arra[0]; //获取指定字符串前面的字符
			mes.code = "300";
			mes.count = 0;
			mes.Message = "请扫描工序二维码!";
			mes.data = null;
			return mes;
			}
			if (arra.Length == 2) //工单号+工序号二维码
			{
			ordercode = arra[0]; //获取指定字符串前面的字符
			stepcode = arra[1]; //获取指定字符串前面的字符
			}
			}
			if (stepcode != "")
			{
			//查找当前工序属性
			sql = @"select * from TStep where stepcode=@stepcode";
			dynamicParams.Add("@stepcode", stepcode);
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			if (data0.Rows.Count > 0)
			{
			if (data0.Rows[0]["FLWTYPE"].ToString() == "W")
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工序任务为外协工序任务,请前往外协操作页签执行!";
			mes.data = null;
			return mes;
			}
			}
			}
			//根据条件查询工单工序设备(自制工序)
			sql = @"select B.eqp_code,E.name as eqp_name from TK_Wrk_Step A
			inner join TFlw_Rteqp B on A.step_code=B.step_code
			left join TEqpInfo E on B.eqp_code=E.code
			where B.style='E' and A.wo_code=@ordercode and A.step_code=@stepcode
			order by B.eqp_code";
			dynamicParams.Add("@ordercode", ordercode);
			dynamicParams.Add("@stepcode", stepcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "查询成功!";
			mes.data = data;
			return mes;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工序任务无可执行设备!";
			mes.data = null;
			return mes;
			}
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[生产开报工扫码获取当前工序对应的供方(外协)]
			public static ToMessage MesOrderWxStepEqpSearch(string orderstepqrcode)
			{
			var sql = "";
			string search = "";
			string ordercode = "";
			string stepcode = "";
			var dynamicParams = new DynamicParameters();
			try
			{
			if (orderstepqrcode != "" && orderstepqrcode != null)
			{
			string[] arra = orderstepqrcode.Split(';');
			if (arra.Length == 1) //工单号二维码
			{
			ordercode = arra[0]; //获取指定字符串前面的字符
			mes.code = "300";
			mes.count = 0;
			mes.Message = "请扫描工序二维码!";
			mes.data = null;
			return mes;
			}
			if (arra.Length == 2) //工单号+工序号二维码
			{
			ordercode = arra[0]; //获取指定字符串前面的字符
			stepcode = arra[1]; //获取指定字符串前面的字符
			}
			}
			if (stepcode != "")
			{
			//查找当前工序属性
			sql = @"select * from TStep where stepcode=@stepcode";
			dynamicParams.Add("@stepcode", stepcode);
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			if (data0.Rows.Count > 0)
			{
			if (data0.Rows[0]["FLWTYPE"].ToString() == "Z")
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工序任务为自制工序任务,请前往自制操作页签执行!";
			mes.data = null;
			return mes;
			}
			}
			}
			//根据条件查询工单工序外协供方(外协工序)
			sql = @"select B.eqp_code as customercode,C.name as customername from TK_Wrk_Step A
			inner join TFlw_Rteqp B on A.step_code=B.step_code
			left join TCustomer C on B.eqp_code=C.code
			where B.style='W' and A.wo_code=@ordercode and A.step_code=@stepcode
			order by B.eqp_code";
			dynamicParams.Add("@ordercode", ordercode);
			dynamicParams.Add("@stepcode", stepcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "查询成功!";
			mes.data = data;
			return mes;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工序无可执行外协供方!";
			mes.data = null;
			return mes;
			}
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[生产开报工扫码获取工单对应工序任务(自制)]
			public static ToMessage MesOrderStepSearch(string orderstepqrcode, int startNum, int endNum, string prop, string order)