LKApi.git - Gitblit

			@@ -1699,9 +1699,8 @@


			#region[安灯系统/自定义安灯呼叫类型查询]
			public static ToMessage AnDengTypeSearch(int startNum, int endNum, string prop, string order)
			public static ToMessage AnDengTypeSearch()
			{
			var dynamicParams = new DynamicParameters();
			try
			{
			// --------------查询指定数据--------------
			@@ -1709,11 +1708,11 @@
			var sql = @"select id, code,name
			from TAnDonType
			where is_delete<>'1' ";
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.count = total;
			mes.data = data.ToList();
			mes.data = data;
			}
			catch (Exception e)
			{
			@@ -1844,20 +1843,12 @@
			dynamicParams.Add("@wkshopcode", wkshopcode);
			dynamicParams.Add("@calltypecode", calltypecode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "暂无响应人员!";
			mes.data = null;
			}

			mes.code = "200";
			mes.count = 0;
			mes.Message = "查询成功!";
			mes.data = data;

			}
			catch (Exception e)
			{
			@@ -1877,13 +1868,14 @@
			var dynamicParams = new DynamicParameters();
			try
			{
			sql = @"select B.user_code as code,U.username as name,(case when C.usercode is null then 'N' else 'Y' end) flag from TUserRoleRelation B
			left join(
			select B.usercode from TAnDon_Roul_ConFig A
			inner join TAnDon_Roul_ConFigUser B on A.id=B.ando_cogfigid
			where A.wkshp_code=@wkshopcode and A.andotype_code=@calltypecode
			) C on B.user_code=C.usercode
			left join TUser U on B.user_code=U.usercode";
			sql = @"select A.usercode,A.username,(case when B.usercode<>'' then 'Y' else 'N' end) as flag
			from TUser A
			left join (
			select B.usercode from TAnDon_Roul_ConFig A
			inner join TAnDon_Roul_ConFigUser B on A.id=B.ando_cogfigid
			where A.wkshp_code=@wkshopcode and A.andotype_code=@calltypecode
			) B on A.usercode=B.usercode
			where A.userclassid='0'";
			dynamicParams.Add("@wkshopcode", wkshopcode);
			dynamicParams.Add("@calltypecode", calltypecode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			@@ -1928,30 +1920,19 @@
			dynamicParams.Add("@wkshopcode", wkshopcode);
			dynamicParams.Add("@calltypecode", calltypecode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mid = Convert.ToInt32(data.Rows[0]["ID"].ToString());
			if (json == null \|\| json.Rows.Count <= 0)
			if (data.Rows.Count > 0)
			{
			//清除安灯、设备任务配置表数据
			sql = @"delete TAnDon_Roul_ConFig where id=@mid";
			list.Add(new { str = sql, parm = new { mid = mid } });
			mid = Convert.ToInt32(data.Rows[0]["ID"].ToString());
			//清除安灯、设备任务配置关联人员表数据
			sql = @"delete TAnDon_Roul_ConFigUser where ando_cogfigid=@mid";
			list.Add(new { str = sql, parm = new { mid = mid } });
			}
			else
			else
			{
			//清除安灯、设备任务配置表数据
			sql = @"delete TAnDon_Roul_ConFig where id=@mid";
			list.Add(new { str = sql, parm = new { mid = mid } });
			//清除安灯、设备任务配置关联人员表数据
			sql = @"delete TAnDon_Roul_ConFigUser where ando_cogfigid=@mid";
			list.Add(new { str = sql, parm = new { mid = mid } });


			//获取主表最大ID
			sql = @"select ISNULL(IDENT_CURRENT('TK_Wrk_Record')+1,1) as id";
			sql = @"select ISNULL(IDENT_CURRENT('TAnDon_Roul_ConFig')+1,1) as id";
			var dt = DapperHelper.selecttable(sql);

			mid = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
			//写入安灯、设备任务配置表数据
			sql = @"insert into TAnDon_Roul_ConFig(wkshp_code,andotype_code,lm_user,lm_date,enable) values(@wkshp_code,@andotype_code,@lm_user,@lm_date,@enable)";
			list.Add(new
			@@ -1966,12 +1947,12 @@
			enable = enable
			}
			});
			//循环写入安灯、设备任务配置关联人员表
			for (int i = 0; i < json.Rows.Count; i++)
			{
			sql = @"insert into TAnDon_Roul_ConFigUser(ando_cogfigid,user_code) values(@usercode,@role_code)";
			list.Add(new { str = sql, parm = new { ando_cogfigid = mid, role_code = json.Rows[i]["CODE"].ToString() } });
			}
			}
			//循环写入安灯、设备任务配置关联人员表
			for (int i = 0; i < json.Rows.Count; i++)
			{
			sql = @"insert into TAnDon_Roul_ConFigUser(ando_cogfigid,usercode) values(@ando_cogfigid,@role_code)";
			list.Add(new { str = sql, parm = new { ando_cogfigid = mid, role_code = json.Rows[i]["CODE"].ToString() } });
			}
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			@@ -2016,8 +1997,8 @@
			parm = new
			{
			wkshp_code = wkshopcode,
			andengtypecode=calltypecode,
			lm_user=usercode,
			andengtypecode = calltypecode,
			lm_user = usercode,
			lm_date = DateTime.Now.ToString(),
			enable = enable
			}
			@@ -2050,7 +2031,7 @@
			#endregion

			#region[安灯系统/响应人员删除]
			public static ToMessage AnDengResponUserDeleteSeave(string id,string ando_cogfigid)
			public static ToMessage AnDengResponUserDeleteSeave(string id, string ando_cogfigid)
			{
			var sql = "";
			List<object> list = new List<object>();
			@@ -2068,7 +2049,7 @@
			sql = @"delete TAnDon_Roul_ConFigUser where id=@id";
			list.Add(new { str = sql, parm = new { id = id } });
			}
			else
			else
			{
			//根据子表id删除对应子表人员
			sql = @"delete TAnDon_Roul_ConFigUser where id=@id";
			@@ -2103,5 +2084,33 @@
			return mes;
			}
			#endregion


			#region[通过车间编码查找设备信息]
			public static ToMessage WhkspIsEqpSearch(string wkshpcode)
			{
			string sql = "";
			var dynamicParams = new DynamicParameters();
			try
			{
			//获取设备下拉框数据
			sql = @"select code as eqp_code,name as eqp_name
			from TEqpInfo where wksp_code=@wkshpcode and enable='Y' ";
			dynamicParams.Add("@wkshpcode", wkshpcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion
			}
			}