FLTApi.git - Gitblit

			@@ -61,8 +61,46 @@
			}
			#endregion

			#region[日常点检,扫描工位/设备二维码查找点检标准]
			public static ToMessage CheckScanDeviceTemp(string eqpcode)
			{
			string sql = "";
			var dynamicParams = new DynamicParameters();
			try
			{
			//获取对应设备点检标准
			sql = @"select M.code,M.name from TEqpchk_Eqp E
			inner join TEqpchk_Main M on E.eqpchkmain_code=M.code
			where E.eqp_code=@eqpcode order by M.lm_date desc";
			dynamicParams.Add("@eqpcode", eqpcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.Message = "当前设备/工位未指定点检标准!";
			mes.data = data;
			}
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}

			#endregion

			#region[日常点检,选择扫码设备列表带出点检项]
			public static ToMessage SelectScanDeviceQrCodeItem(string eqpcode)
			public static ToMessage SelectScanDeviceQrCodeItem(string eqpcode,string checktempcode)
			{
			string sql = "";
			var dynamicParams = new DynamicParameters();
			@@ -73,9 +111,10 @@
			from TEqpchk_Eqp A
			inner join TEqpchk_Main B on A.eqpchkmain_code=B.code
			inner join TEqpchk_Deta S on B.code=S.eqpchk_main_code
			where A.eqp_code=@eqpcode
			where A.eqp_code=@eqpcode and B.code=@checktempcode
			order by S.seq asc";
			dynamicParams.Add("@eqpcode", eqpcode);
			dynamicParams.Add("@checktempcode", checktempcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			@@ -110,7 +149,7 @@
			try
			{
			list.Clear();
			mes = SeachEncode.EncodingSeach("2040"); //生成单号
			mes = SeachEncode.EncodingSeach("1027"); //PC端设备点检记录生成单号
			if (mes.code == "300")
			{
			return mes;
			@@ -165,9 +204,6 @@
			}
			}); ;
			}
			//回写字典表,更新当前流水号
			sql = @"update T_CodeRules set value=@cunm2 where rightcode=@RightCode";
			list.Add(new { str = sql, parm = new { cunm2 = numvalue, RightCode = "1027" } });

			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			@@ -239,20 +275,18 @@
			}
			#endregion

			#region[日常保养,选择扫码设备列表带出保养项]
			public static ToMessage RepairSelectScanDeviceQrCodeItem(string eqpcode)
			#region[定期保养,扫描工位/设备二维码查找保养标准]
			public static ToMessage RepairScanDeviceTemp(string eqpcode)
			{
			string sql = "";
			var dynamicParams = new DynamicParameters();
			try
			{
			//获取对应设备关联的保养项目
			sql = @"select S.seq,S.code,S.name,S.chk_desc,S.isscan,B.main_cycle
			from TEqpmai_Eqp A
			inner join TEqpmai_Main B on A.eapmai_code=B.code
			inner join TEqpmai_Deta S on B.code=S.eapmai_code
			where A.eqp_code=@eqpcode
			order by S.seq asc";
			//获取对应设备保养标准
			sql = @"select M.code,M.name,main_cycle from TEqpmai_Eqp E
			inner join TEqpmai_Main M on E.eapmai_code=M.code
			where E.eqp_code=@eqpcode
			order by M.lm_date desc";
			dynamicParams.Add("@eqpcode", eqpcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			@@ -264,7 +298,48 @@
			else
			{
			mes.code = "300";
			mes.Message = "当前设备未设置点检标准绑定点检项目!";
			mes.Message = "当前设备/工位未指定保养标准!";
			mes.data = data;
			}
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[日常保养,选择扫码设备列表带出保养项]
			public static ToMessage RepairSelectScanDeviceQrCodeItem(string eqpcode,string repartempcode)
			{
			string sql = "";
			var dynamicParams = new DynamicParameters();
			try
			{
			//获取对应设备关联的保养项目
			sql = @"select S.seq,S.code,S.name,S.chk_desc,S.isscan,B.main_cycle
			from TEqpmai_Eqp A
			inner join TEqpmai_Main B on A.eapmai_code=B.code
			inner join TEqpmai_Deta S on B.code=S.eapmai_code
			where A.eqp_code='SB003' and B.code=@repartempcode
			order by S.seq asc";
			dynamicParams.Add("@eqpcode", eqpcode);
			dynamicParams.Add("@repartempcode", repartempcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.Message = "当前设备未设置保养标准绑定点检项目!";
			mes.data = data;
			}
			}
			@@ -288,7 +363,7 @@
			try
			{
			list.Clear();
			mes = SeachEncode.EncodingSeach("2041"); //生成单号
			mes = SeachEncode.EncodingSeach("1028"); //PC端保养记录生成单号
			if (mes.code == "300")
			{
			return mes;
			@@ -344,9 +419,7 @@
			}
			}); ;
			}
			//回写字典表,更新当前流水号
			sql = @"update T_CodeRules set value=@cunm2 where rightcode=@RightCode";
			list.Add(new { str = sql, parm = new { cunm2 = numvalue, RightCode = "1028" } });

			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			@@ -383,8 +456,8 @@
			var dynamicParams = new DynamicParameters();
			try
			{
			//获取当前扫码设备是否申请维修记录
			sql = @"select * from TEqp_RepairRequest where eqp_code=@eqpcode and status='REPA' or status='COMP'";
			//获取当前扫码设备是否存在已申请或已维修状态数据
			sql = @"select * from TEqp_RepairRequest where eqp_code=@eqpcode and status<>'CONFIR'";
			dynamicParams.Add("@eqpcode", eqpcode);
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			if (data0.Rows.Count > 0)
			@@ -448,10 +521,9 @@
			try
			{
			list.Clear();
			mes = SeachEncode.EncodingSeach("2042"); //生成单号
			mes = SeachEncode.EncodingSeach("1019"); //PC端维修申请记录生成单号
			if (mes.code == "300")
			{
			mes.Message = "生成单号失败,请设置编码为【2042】的编码规则";
			return mes;
			}
			else
			@@ -505,9 +577,6 @@
			source = faultsourcecode
			}
			});
			//回写字典表,更新当前流水号
			sql = @"update T_CodeRules set value=@cunm2 where rightcode=@RightCode";
			list.Add(new { str = sql, parm = new { cunm2 = numvalue, RightCode = "2042" } });

			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			@@ -587,10 +656,9 @@
			try
			{
			list.Clear();
			mes = SeachEncode.EncodingSeach("2043"); //生成单号
			mes = SeachEncode.EncodingSeach("1029"); //PC设备维修记录生成单号
			if (mes.code == "300")
			{
			mes.Message = "生成单号失败,请设置编码为【2043】的编码规则";
			return mes;
			}
			else
			@@ -660,10 +728,6 @@
			//更新维修申请单状态
			sql = @"update TEqp_RepairRequest set status=@status where docu_code=@docu_code and wksp_code=@wkshpcode and eqp_code=@eqpcode";
			list.Add(new { str = sql, parm = new { docu_code = docu_code, wkshpcode = wkshpcode, eqpcode = eqpcode, status = "COMP" } });

			//回写字典表,更新当前流水号
			sql = @"update T_CodeRules set value=@cunm2 where rightcode=@RightCode";
			list.Add(new { str = sql, parm = new { cunm2 = numvalue, RightCode = "2043" } });

			bool aa = DapperHelper.DoTransaction(list);
			if (aa)