JTAPI.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)
			{
			@@ -239,20 +278,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 +301,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;
			}
			}
			@@ -383,8 +461,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)
			@@ -607,7 +685,7 @@
			string imgPath1 = "", imgPath2 = "", AbsolutePath = "";
			HttpPostedFile file = files[i];
			string imgName = DateTime.Now.ToString("yyyyMMddhhmmss") + i.ToString();
			string keyname = files.AllKeys[i].ToString();
			string keyname = files.AllKeys[i].ToString().Substring(0, files.AllKeys[i].ToString().IndexOf(";"));
			if (keyname == "files1")
			{
			imgPath1 = "/DeviceImage/image1/" + imgName + file.FileName; //通过此对象获取文件名
			@@ -618,7 +696,6 @@
			imgPath2 = "/DeviceImage/image2/" + imgName + file.FileName; //通过此对象获取文件名
			AbsolutePath = System.Web.HttpContext.Current.Server.MapPath(imgPath2);
			}

			file.SaveAs(AbsolutePath); //将上传的东西保存
			//循环写维修记录对应图片表
			sql = @"insert into TEqp_RepairImage(source_wo,wo_type,img1url,img2url)
			@@ -931,7 +1008,7 @@
			mn.flag = data.Rows[i]["FLAG"].ToString();
			mn.children = new List<AnDnDateSub>();
			//根据呼叫类型id查找绑定人员
			sql = @"select U.usercode,U.username
			sql = @"select U.usercode,U.username,U.rid
			from TAnDon_Roul_ConFigUser A
			inner join TUser U on A.usercode=U.usercode
			where A.ando_cogfigid=@id";
			@@ -942,6 +1019,8 @@
			for (int j = 0; j < data0.Rows.Count; j++)
			{
			AnDnDateSub sn = new AnDnDateSub();
			sn.rid= data0.Rows[j]["RID"].ToString();//rid
			sn.alias = data0.Rows[j]["RID"].ToString() + data0.Rows[j]["USERCODE"].ToString(); //别名
			sn.usercode = data0.Rows[j]["USERCODE"].ToString();
			sn.username = data0.Rows[j]["USERNAME"].ToString();
			mn.children.Add(sn);
			@@ -1037,6 +1116,7 @@
			eqp_code = eqpcode,
			type = code,
			resp_user = json[i].children[j].usercode,
			alias= json[i].children[j].alias,
			status = "N"
			}
			});
			@@ -1044,7 +1124,7 @@
			}
			}
			//极光推送
			//mes = JPushManage.ExecutePushByUserId(username, wkshpcode, eqpcode, json);
			mes = JPushManage.ExecutePushByUserId(username, wkshpcode, eqpcode, json);
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			@@ -1083,7 +1163,7 @@
			try
			{
			//获取对应设备及所属车间的安灯呼叫记录
			sql = @"select A.eqp_code,B.name as eqp_name,T.org_name,A.type as typecode,D.name as typename
			sql = @"select A.eqp_code,B.name as eqp_name,T.org_code as wksp_code,T.org_name as wksp_name,A.type as typecode,D.name as typename
			from TAnDon_Task_Info A
			left join TEqpInfo B on A.eqp_code=B.code
			left join TOrganization T on B.wksp_code=T.org_code
			@@ -1125,7 +1205,7 @@
			try
			{
			list.Clear();
			for (int i = 1; i <= json.Count; i++)
			for (int i = 0; i <json.Count; i++)
			{
			string code = json[i].code.ToString();
			string name = json[i].name.ToString();