DDMesApi.git - Gitblit

			@@ -59,7 +59,7 @@
			//循环写入设备类型表
			for (int i = 0; i < json.Count; i++)
			{
			sql = @"insert into TRoleType(code,name,lm_user,lm_date,remark) values(@code,@name,@username,@createdate,@description)";
			sql = @"insert into TEqpType(code,name,lm_user,lm_date,remark) values(@code,@name,@username,@createdate,@description)";
			list.Add(new
			{
			str = sql,
			@@ -112,8 +112,8 @@
			//判断设备类型下是否关联设备组
			sql = @"select * from TEqpGroup where eqptype_code=@devicetypecode and is_delete<>'1'";
			dynamicParams.Add("@devicetypecode", devicetypecode);
			var data = DapperHelper.select<TreeObejct>(sql, dynamicParams);
			if (data.Count > 0)
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			@@ -125,8 +125,8 @@
			//判断设备有无关联设备类型
			sql = @"select * from TEqpInfo where eqptype_code=@devicetypecode and is_delete<>'1'";
			dynamicParams.Add("@devicetypecode", devicetypecode);
			var data0 = DapperHelper.select<TreeObejct>(sql, dynamicParams);
			if (data0.Count > 0)
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			if (data0.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			@@ -288,8 +288,8 @@
			//判断设备组下是否关联设备
			sql = @"select * from TEqpInfo where eqpgroup_code=@devicegroupcode and is_delete<>'1'";
			dynamicParams.Add("@devicegroupcode", devicegroupcode);
			var data = DapperHelper.select<TreeObejct>(sql, dynamicParams);
			if (data.Count > 0)
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			@@ -382,6 +382,33 @@
			}
			#endregion

			#region[所属车间查找所属产线接口]
			public static ToMessage WorkShopSelectLine(string workshopcode)
			{
			string sql = "";
			var dynamicParams = new DynamicParameters();
			List<TreeObejct> list = new List<TreeObejct>();
			try
			{
			//获取角色类型集合(包含绑定标识)
			dynamicParams.Add("@workshop_code", workshopcode);
			var data = DapperHelper.selectProcedure("h_p_T_WorkShopSelectLine", 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

			#region [设备清单查询]
			public static ToMessage DeviceMangerSearch(string deviceCode, string deviceName, string status, string workShop, string deviceType, string deviceGroup, int startNum, int endNum, string prop, string order)
			{
			@@ -401,7 +428,7 @@
			}
			if (status != "" && status != null)
			{
			search += "and A.status=@status ";
			search += "and A.enable=@status ";
			dynamicParams.Add("@status", status);
			}
			if (workShop != "" && workShop != null)
			@@ -426,7 +453,7 @@
			//search = search.Substring(3);//截取索引2后面的字符
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select A.code,A.name,A.eqptype_code,B.name as eqptype_name,A.eqpgroup_code,G.name as eqpgroup_name,A.enable,
			var sql = @"select A.id,A.code,A.name,A.eqptype_code,B.name as eqptype_name,A.eqpgroup_code,G.name as eqpgroup_name,A.enable,
			A.input_date,A.wksp_code,T.org_name as wksp_name,A.Line_code,L.org_name as Line_name,A.opc_uom,A.operation_ration,A.lm_user,A.lm_date
			from TEqpInfo A
			left join TEqpType B on A.eqptype_code=B.code
			@@ -492,7 +519,7 @@
			if (operType == "Update")
			{
			var sql = @"update TEqpInfo set name=@devicename,eqptype_code=@devicetype,eqpgroup_code=@devicegroup,input_date=@importdate,
			wksp_code=@workshop,line_code=@linecode,enable=@status,operation_ration=@ratio,lm_user=@usercode,lm_date=@CreateDate,
			wksp_code=@workshop,line_code=@linecode,enable=@status,operation_ration=@ratio,lm_user=@usercode,lm_date=@CreateDate
			where id=@deviceid";
			dynamicParams.Add("@deviceid", deviceid);
			dynamicParams.Add("@devicename", devicename);