JLApi.git - Gitblit

			@@ -2375,20 +2375,18 @@


			#region[设备类型查询]
			public static ToMessage DeviceTypeSearch(int startNum, int endNum, string prop, string order)
			public static ToMessage DeviceTypeSearch()
			{
			var dynamicParams = new DynamicParameters();
			try
			{
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select id, code,name,remark
			var sql = @"select id, code,name
			from TEqpType";
			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.count = data.Rows.Count;
			mes.data = data;
			}
			catch (Exception e)
			{
			@@ -2402,7 +2400,7 @@
			#endregion

			#region[设备类型新增]
			public static ToMessage AddUpdateDeviceType(List<ObjectDataCont> json, User us)
			public static ToMessage AddUpdateDeviceType(string OperType, List<ObjectDataCont> json, User us)
			{
			var sql = "";
			List<object> list = new List<object>();
			@@ -2410,39 +2408,117 @@
			try
			{
			list.Clear();
			//循环写入设备类型表
			for (int i = 0; i < json.Count; i++)
			if (OperType == "Add")
			{
			sql = @"insert into TEqpType(code,name,lm_user,lm_date,remark) values(@code,@name,@username,@createdate,@description)";
			list.Add(new
			//判断设备类型是否重复
			sql = @"select * from TEqpType where code=@devtypecode";
			dynamicParams.Add("@devtypecode", json[0].code);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			str = sql,
			parm = new
			mes.code = "300";
			mes.count = 0;
			mes.Message = "设备类型编码已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			//判断设备类型名称是否重复
			sql = @"select * from TEqpType where name=@devtypename";
			dynamicParams.Add("@devtypename", json[0].name);
			var data1 = DapperHelper.selectdata(sql, dynamicParams);
			if (data1.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "设备类型名称已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			//循环写入设备类型表
			for (int i = 0; i < json.Count; i++)
			{
			sql = @"insert into TEqpType(code,name,lm_user,lm_date,remark) values(@code,@name,@username,@createdate,@description)";
			list.Add(new
			{
			code = json[i].code,
			name = json[i].name,
			username = us.usercode,
			createdate = DateTime.Now.ToString(),
			description = json[i].description
			}
			});
			str = sql,
			parm = new
			{
			code = json[i].code,
			name = json[i].name,
			username = us.usercode,
			createdate = DateTime.Now.ToString(),
			description = json[i].description
			}
			});
			}

			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了设备类型:" + string.Join(",", json.Select(m => m.code)), us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "操作失败!";
			mes.data = null;
			}
			}
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			if (OperType == "Update")
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了设备类型:" + string.Join(",", json.Select(m => m.code)), us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "操作失败!";
			mes.data = null;
			//判断设备名称是否重复
			sql = @"select * from TEqpType where code<>@devtypecode and name=@devtypename";
			dynamicParams.Add("@devtypecode", json[0].code);
			dynamicParams.Add("@devtypename", json[0].name);
			var data1 = DapperHelper.selectdata(sql, dynamicParams);
			if (data1.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "设备类型名称已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			for (int i = 0; i < json.Count; i++)
			{
			sql = @"update TEqpType set name=@devtypename,remark=@remark,lm_user=@lm_user,lm_date=@lm_date
			where code=@devtypecode";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			devtypecode = json[i].code,
			devtypename = json[i].name,
			remark = json[i].description,
			lm_user= us.usercode,
			lm_date = DateTime.Now.ToString()
			}
			});
			}
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了设备类型:" + string.Join(",", json.Select(m => m.code)), us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "操作失败!";
			mes.data = null;
			}
			}
			}
			catch (Exception e)
			@@ -2686,7 +2762,7 @@
			#endregion

			#region[设备信息删除]
			public static ToMessage DeleteDeviceManger(string devicecode,User us)
			public static ToMessage DeleteDeviceManger(string devicecode, User us)
			{
			var sql = "";
			List<object> list = new List<object>();