JLApi.git - Gitblit

			@@ -67,7 +67,7 @@
			where A.is_delete<>'1' " + search;
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = data.ToList();
			}
			@@ -75,7 +75,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -97,7 +97,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "操作失败,编码重复!";
			mes.message = "操作失败,编码重复!";
			mes.data = null;
			return mes;
			}
			@@ -116,14 +116,14 @@
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "新增操作成功!";
			mes.message = "新增操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新增操作失败!";
			mes.message = "新增操作失败!";
			mes.data = null;
			}
			}
			@@ -143,14 +143,14 @@
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "修改操作成功!";
			mes.message = "修改操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "修改操作失败!";
			mes.message = "修改操作失败!";
			mes.data = null;
			}
			}
			@@ -159,7 +159,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -182,7 +182,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "外协供方已关联外协工序,不允许删除!";
			mes.message = "外协供方已关联外协工序,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -194,14 +194,14 @@
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "删除成功!";
			mes.message = "删除成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除失败!";
			mes.message = "删除失败!";
			mes.data = null;
			}
			}
			@@ -209,7 +209,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -247,14 +247,14 @@
			where parent.is_delete<>'1' " + search;
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -273,7 +273,7 @@
			where is_delete<>'1' ";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = data;
			}
			@@ -281,7 +281,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -318,14 +318,14 @@
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "操作成功!";
			mes.message = "操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "操作失败!";
			mes.message = "操作失败!";
			mes.data = null;
			}
			}
			@@ -333,7 +333,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -357,7 +357,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前呼叫类型已关联呼叫配置,不允许删除!";
			mes.message = "当前呼叫类型已关联呼叫配置,不允许删除!";
			mes.data = null;
			}
			else
			@@ -369,14 +369,14 @@
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "删除成功!";
			mes.message = "删除成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除失败!";
			mes.message = "删除失败!";
			mes.data = null;
			}
			}
			@@ -385,7 +385,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -409,7 +409,7 @@

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

			}
			@@ -417,7 +417,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -446,14 +446,14 @@
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "暂无响应人员!";
			mes.message = "暂无响应人员!";
			mes.data = null;
			}
			}
			@@ -461,7 +461,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -522,14 +522,14 @@
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "操作成功!";
			mes.message = "操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "操作失败!";
			mes.message = "操作失败!";
			mes.data = null;
			}
			}
			@@ -537,7 +537,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -571,14 +571,14 @@
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "操作成功!";
			mes.message = "操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除失败!";
			mes.message = "删除失败!";
			mes.data = null;
			}
			}
			@@ -586,7 +586,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -626,14 +626,14 @@
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "删除成功!";
			mes.message = "删除成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除失败!";
			mes.message = "删除失败!";
			mes.data = null;
			}
			}
			@@ -641,7 +641,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -662,14 +662,14 @@
			dynamicParams.Add("@wkshpcode", wkshpcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -680,7 +680,7 @@


			#region[组织架构,查询组织信息]
			public static ToMessage STorgData(string storg_code, string storg_name, int startNum, int endNum, string prop, string order)
			public static ToMessage STorgData(string storg_code, string storg_name)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			@@ -696,24 +696,22 @@
			search += "and T.torg_name like '%'+@storg_name+'%' ";
			dynamicParams.Add("@storg_name", storg_name);
			}
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select T.id,T.parent_id,T.torg_code,T.torg_name,T.status,T.leve,T.torg_seq,
			T.lm_user as usercode,U.username,T.lm_date
			from TOrganization T
			left join TUser U on T.lm_user=U.usercode
			where 1=1" + search + "";
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			where 1=1" + search + " order by T.lm_date desc";
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.count = total;
			mes.data = data.ToList();
			mes.message = "查询成功!";
			mes.count = data.Rows.Count;
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -737,7 +735,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新增操作失败,编码重复!";
			mes.message = "新增操作失败,编码重复!";
			mes.data = null;
			return mes;
			}
			@@ -764,17 +762,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了组织:"+ OrganCode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了组织:" + OrganCode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "新增操作成功!";
			mes.message = "新增操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新增操作失败!";
			mes.message = "新增操作失败!";
			mes.data = null;
			}
			}
			@@ -791,7 +789,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新选择的所属组织已使用不允许修改!";
			mes.message = "新选择的所属组织已使用不允许修改!";
			mes.data = null;
			return mes;
			}
			@@ -814,7 +812,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前原有组织或子级被使用不允许修改!";
			mes.message = "当前原有组织或子级被使用不允许修改!";
			mes.data = null;
			return mes;
			}
			@@ -862,17 +860,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了组织:"+ OrganCode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了组织:" + OrganCode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "修改操作成功!";
			mes.message = "修改操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "修改操作失败!";
			mes.message = "修改操作失败!";
			mes.data = null;
			}
			}
			@@ -881,7 +879,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -902,7 +900,7 @@
			if (data0.Rows.Count > 0)
			{
			mes.code = "300";
			mes.Message = "当前组织有下级关联,请先删除下级组织!";
			mes.message = "当前组织有下级关联,请先删除下级组织!";
			return mes;
			}
			sql = @"select * from TUser where storg_code=@orgcode";
			@@ -912,7 +910,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "该组织下有关联的用户,不允许删除!";
			mes.message = "该组织下有关联的用户,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -922,17 +920,17 @@
			if (cont > 0)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "新增", "删除了组织:"+orgcode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "新增", "删除了组织:" + orgcode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "删除操作成功!";
			mes.message = "删除操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除操作失败!";
			mes.message = "删除操作失败!";
			mes.data = null;
			}

			@@ -941,7 +939,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -975,7 +973,7 @@
			where 1=1 " + search + "";
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = data.ToList();
			}
			@@ -983,7 +981,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1007,7 +1005,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新增操作失败,编码重复!";
			mes.message = "新增操作失败,编码重复!";
			mes.data = null;
			return mes;
			}
			@@ -1032,17 +1030,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了岗位:"+ postcode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了岗位:" + postcode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "新增操作成功!";
			mes.message = "新增操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新增操作失败!";
			mes.message = "新增操作失败!";
			mes.data = null;
			}
			}
			@@ -1058,7 +1056,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "该岗位有关联的用户,不允许停用!";
			mes.message = "该岗位有关联的用户,不允许停用!";
			mes.data = null;
			return mes;
			}
			@@ -1083,17 +1081,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了岗位:"+ postcode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了岗位:" + postcode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "修改操作成功!";
			mes.message = "修改操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "修改操作失败!";
			mes.message = "修改操作失败!";
			mes.data = null;
			}
			}
			@@ -1102,7 +1100,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1124,7 +1122,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "该岗位有关联的用户,不允许删除!";
			mes.message = "该岗位有关联的用户,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -1134,17 +1132,17 @@
			if (cont > 0)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了岗位:"+ postcode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了岗位:" + postcode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "删除操作成功!";
			mes.message = "删除操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除操作失败!";
			mes.message = "删除操作失败!";
			mes.data = null;
			}

			@@ -1153,7 +1151,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1213,7 +1211,7 @@
			left join TUser S on U.lm_user=S.usercode " + search + "";
			var data = DapperHelper.GetPagedDataWith<object>(withsql, sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = data.ToList();
			}
			@@ -1221,7 +1219,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1294,7 +1292,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新增操作失败,编码重复!";
			mes.message = "新增操作失败,编码重复!";
			mes.data = null;
			return mes;
			}
			@@ -1325,17 +1323,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了用户:"+ usercode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了用户:" + usercode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "新增操作成功!";
			mes.message = "新增操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新增操作失败!";
			mes.message = "新增操作失败!";
			mes.data = null;
			}
			}
			@@ -1369,17 +1367,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了用户:"+usercode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了用户:" + usercode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "修改操作成功!";
			mes.message = "修改操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "修改操作失败!";
			mes.message = "修改操作失败!";
			mes.data = null;
			}
			}
			@@ -1388,7 +1386,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1411,17 +1409,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了用户:"+ usercode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了用户:" + usercode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "删除用户成功!";
			mes.message = "删除用户成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除用户失败!";
			mes.message = "删除用户失败!";
			mes.data = null;
			}
			}
			@@ -1429,7 +1427,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1463,7 +1461,7 @@
			where 1=1 " + search + "";
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = data.ToList();
			}
			@@ -1471,7 +1469,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1495,7 +1493,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新增操作失败,编码重复!";
			mes.message = "新增操作失败,编码重复!";
			mes.data = null;
			return mes;
			}
			@@ -1520,17 +1518,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了班组:"+ groupcode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了班组:" + groupcode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "新增操作成功!";
			mes.message = "新增操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新增操作失败!";
			mes.message = "新增操作失败!";
			mes.data = null;
			}
			}
			@@ -1546,7 +1544,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "该班组有关联的用户,不允许停用!";
			mes.message = "该班组有关联的用户,不允许停用!";
			mes.data = null;
			return mes;
			}
			@@ -1571,17 +1569,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了班组:"+ groupcode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了班组:" + groupcode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "修改操作成功!";
			mes.message = "修改操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "修改操作失败!";
			mes.message = "修改操作失败!";
			mes.data = null;
			}
			}
			@@ -1590,7 +1588,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1612,7 +1610,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "该班组有关联的用户,不允许删除!";
			mes.message = "该班组有关联的用户,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -1622,17 +1620,17 @@
			if (cont > 0)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了班组:"+ groupcode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了班组:" + groupcode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "删除操作成功!";
			mes.message = "删除操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除操作失败!";
			mes.message = "删除操作失败!";
			mes.data = null;
			}

			@@ -1641,7 +1639,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1681,7 +1679,7 @@
			where 1=1 " + search + "";
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = data.ToList();
			}
			@@ -1689,7 +1687,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1721,7 +1719,7 @@
			if (data.Rows.Count > 0)
			{
			mes.code = "300";
			mes.Message = "同名角色已存在!";
			mes.message = "同名角色已存在!";
			mes.data = null;
			return mes;
			}
			@@ -1750,17 +1748,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了角色:"+ ((List<string>)mes.data)[0].ToString(), us.usertype);
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了角色:" + ((List<string>)mes.data)[0].ToString(), us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "成功!";
			mes.message = "成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "失败!";
			mes.message = "失败!";
			mes.data = null;
			}
			}
			@@ -1776,7 +1774,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "该角色有关联的用户,不允许停用!";
			mes.message = "该角色有关联的用户,不允许停用!";
			mes.data = null;
			return mes;
			}
			@@ -1839,17 +1837,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了角色名称:"+ rolecode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了角色名称:" + rolecode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "成功!";
			mes.message = "成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "失败!";
			mes.message = "失败!";
			mes.data = null;
			}
			}
			@@ -1858,7 +1856,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1882,7 +1880,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "该角色有关联的用户,不允许删除!";
			mes.message = "该角色有关联的用户,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -1896,17 +1894,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了角色:"+ rolecode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了角色:" + rolecode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "成功!";
			mes.message = "成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "失败!";
			mes.message = "失败!";
			mes.data = null;
			}
			}
			@@ -1914,7 +1912,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1997,7 +1995,7 @@
			where 1=1 and U.status='Y' and U.role_code<>'' " + search + "";
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = data.ToList();
			}
			@@ -2005,7 +2003,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2044,17 +2042,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "取消", "取消了角色关联的用户:"+ string.Join(",", user), us.usertype);
			LogHelper.DbOperateLog(us.usercode, "取消", "取消了角色关联的用户:" + string.Join(",", user), us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "成功!";
			mes.message = "成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "失败!";
			mes.message = "失败!";
			mes.data = null;
			}

			@@ -2064,7 +2062,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2102,14 +2100,14 @@
			LogHelper.DbOperateLog(us.usercode, "添加", "添加了角色关联的用户:" + string.Join(",", user), us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "成功!";
			mes.message = "成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "失败!";
			mes.message = "失败!";
			mes.data = null;
			}

			@@ -2119,7 +2117,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2145,14 +2143,14 @@
			{
			mes.code = "200";
			mes.count = list.Count;
			mes.Message = "查询角色成功！";
			mes.message = "查询角色成功！";
			mes.data = list;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "暂无角色！";
			mes.message = "暂无角色！";
			mes.data = null;
			}
			}
			@@ -2160,7 +2158,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2177,14 +2175,14 @@
			//查询所有默认菜单及按钮、数据
			sql = @"select menucode,menuname,parent_id,buttoncodelist
			from TMenu
			where Type=@type";
			where is_show='Y' and Type=@type ";
			dynamicParams.Add("@type", type);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "查询成功！";
			mes.message = "查询成功！";
			mes.data = data;
			return mes;
			}
			@@ -2192,7 +2190,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "暂无菜单！";
			mes.message = "暂无菜单！";
			mes.data = null;
			return mes;
			}
			@@ -2201,7 +2199,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2222,7 +2220,7 @@
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "查询成功！";
			mes.message = "查询成功！";
			mes.data = data;
			return mes;
			}
			@@ -2230,7 +2228,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2256,17 +2254,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "分配", "分配了角色权限:"+"-->角色:"+rolecode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "分配", "分配了角色权限:" + "-->角色:" + rolecode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "成功!";
			mes.message = "成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "失败!";
			mes.message = "失败!";
			mes.data = null;
			}
			}
			@@ -2274,7 +2272,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2293,14 +2291,14 @@
			sql = @"select code,name,idparent,data_sources from TCustomerType ";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2324,7 +2322,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "往来单位分类上级不能是已有往来单位的分类，请重新输入！";
			mes.message = "往来单位分类上级不能是已有往来单位的分类，请重新输入！";
			mes.data = null;
			return mes;
			}
			@@ -2339,7 +2337,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "往来单位分类编码已存在,请重新输入!";
			mes.message = "往来单位分类编码已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -2351,7 +2349,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "往来单位分类名称已存在,请重新输入!";
			mes.message = "往来单位分类名称已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -2375,17 +2373,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了往来单位分类:"+ customerclasscode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了往来单位分类:" + customerclasscode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "新增操作成功!";
			mes.message = "新增操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新增操作失败!";
			mes.message = "新增操作失败!";
			mes.data = null;
			}
			}
			@@ -2400,7 +2398,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "往来单位分类名称已存在,请重新输入!";
			mes.message = "往来单位分类名称已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -2423,17 +2421,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了往来单位分类:"+ customerclasscode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了往来单位分类:" + customerclasscode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "修改操作成功!";
			mes.message = "修改操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "修改操作失败!";
			mes.message = "修改操作失败!";
			mes.data = null;
			}
			}
			@@ -2442,7 +2440,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2466,7 +2464,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前往来单位分类或下级被引用不允许删除！";
			mes.message = "当前往来单位分类或下级被引用不允许删除！";
			mes.data = null;
			return mes;
			}
			@@ -2484,17 +2482,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了往来单位分类:"+ string.Join(",", classcode), us.usertype);
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了往来单位分类:" + string.Join(",", classcode), us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "修改操作成功!";
			mes.message = "修改操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "修改操作失败!";
			mes.message = "修改操作失败!";
			mes.data = null;
			}
			}
			@@ -2502,7 +2500,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2543,7 +2541,7 @@
			var total = 0; //总条数
			data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = data.ToList();
			}
			@@ -2551,7 +2549,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2576,7 +2574,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "往来单位编码已存在,请重新输入!";
			mes.message = "往来单位编码已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -2588,7 +2586,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "往来单位名称已存在,请重新输入!";
			mes.message = "往来单位名称已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -2616,17 +2614,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了往来单位:"+ customercode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了往来单位:" + customercode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "新增操作成功!";
			mes.message = "新增操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新增操作失败!";
			mes.message = "新增操作失败!";
			mes.data = null;
			}
			}
			@@ -2641,7 +2639,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "往来单位名称已存在,请重新输入!";
			mes.message = "往来单位名称已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -2668,17 +2666,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了往来单位:"+ customercode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了往来单位:" + customercode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "修改操作成功!";
			mes.message = "修改操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "修改操作失败!";
			mes.message = "修改操作失败!";
			mes.data = null;
			}
			}
			@@ -2687,7 +2685,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2719,26 +2717,26 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了往来单位:"+ customercode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了往来单位:" + customercode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "删除操作成功!";
			mes.message = "删除操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除操作失败!";
			mes.message = "删除操作失败!";
			mes.data = null;
			}
			}
			catch (Exception e)
			{


			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2774,15 +2772,15 @@
			search += "and S.ishasPosition=@ishasPosition ";
			dynamicParams.Add("@ishasPosition", ishasPosition);
			}
			sql = @"select S.code,S.name,S.status,S.ishasPosition,S.description,S.lm_user as usercode,U.username,S.data_sources
			sql = @"select S.code,S.name,S.status,S.ishasPosition,S.description,S.lm_user as usercode,U.username,S.lm_date,S.data_sources
			from TSecStck S
			left join TUser U on C.lm_user=U.usercode
			left join TUser U on S.lm_user=U.usercode
			where 1=1 " + search;
			// --------------查询指定数据--------------
			var total = 0; //总条数
			data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = data.ToList();
			}
			@@ -2790,7 +2788,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2815,7 +2813,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "仓库编码已存在,请重新输入!";
			mes.message = "仓库编码已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -2827,7 +2825,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "仓库名称已存在,请重新输入!";
			mes.message = "仓库名称已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			@@ -2853,17 +2851,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了仓库:"+ stckcode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了仓库:" + stckcode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "新增操作成功!";
			mes.message = "新增操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新增操作失败!";
			mes.message = "新增操作失败!";
			mes.data = null;
			}
			}
			@@ -2878,12 +2876,12 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "仓库名称已存在,请重新输入!";
			mes.message = "仓库名称已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			//更新仓库
			sql = @"update TCustomer set name=@name,status=@status,ishasPosition=@ishasPosition,description=@description,lm_user=@lm_user,lm_date=@lm_date
			sql = @"update TSecStck set name=@name,status=@status,ishasPosition=@ishasPosition,description=@description,lm_user=@lm_user,lm_date=@lm_date
			where code=@code";
			list.Add(new
			{
			@@ -2899,21 +2897,36 @@
			lm_date = DateTime.Now.ToString()
			}
			});
			if (status == "1") //仓库停用时,下面所有的仓位停用
			{
			//更新库位状态为禁用
			sql = @"update TSecLoca set status=@status where idwarehouse=@code";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			status = status,
			code = stckcode
			}
			});
			}

			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了仓库:"+ stckcode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了仓库:" + stckcode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "修改操作成功!";
			mes.message = "修改操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "修改操作失败!";
			mes.message = "修改操作失败!";
			mes.data = null;
			}
			}
			@@ -2922,7 +2935,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2945,7 +2958,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "仓库已启用货位,不允许删除!";
			mes.message = "仓库已启用货位,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -2964,17 +2977,17 @@
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了仓库:"+ stckcode, us.usertype);
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了仓库:" + stckcode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "删除操作成功!";
			mes.message = "删除操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除操作失败!";
			mes.message = "删除操作失败!";
			mes.data = null;
			}
			}
			@@ -2983,11 +2996,543 @@

			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion


			#region[仓位树型信息]
			public static ToMessage TSecLocaTree()
			{
			string sql = "";
			try
			{
			//获取开启仓位管控的仓库信息
			sql = @"select code,name,'-1' as idparent,'' as warhouse,'0' as depth from TSecStck where ishasPosition='1'
			union all
			select code,name,case when L.idparent is NULL or L.idparent='' then '-1' else L.idparent end as idparent,idwarehouse,depth
			from TSecLoca L ";
			var data = DapperHelper.selecttable(sql);
			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 TSecLocaData(string flag, string stckcode, string locacode, string locaname, int startNum, int endNum, string prop, string order)
			{
			var dynamicParams = new DynamicParameters();
			string search = "", sql = "";
			IEnumerable<object> data;
			try
			{
			if (flag == "-1" && stckcode == null)
			{
			mes.code = "200";
			mes.count = 0;
			mes.message = "暂无数据!";
			mes.data = null;
			return mes;
			}
			string[] classcode = Array.ConvertAll<string, string>(stckcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string分割转string[]
			switch (flag)
			{
			case "-1": //全部
			search += " and L.idparent is null or L.idparent='' and L.idwarehouse in @idwarehouse ";
			dynamicParams.Add("@idwarehouse", classcode);
			break;
			case "0": //仓库
			search += " and L.depth='1' and L.idwarehouse in @idwarehouse ";
			dynamicParams.Add("@idwarehouse", classcode);
			break;
			default: //仓位
			search += " and L.idparent in @idparent";
			dynamicParams.Add("@idparent", classcode);
			break;
			}
			if (locacode != "" && locacode != null)
			{
			search += "and L.code like '%'+@locacode+'%' ";
			dynamicParams.Add("@locacode", locacode);
			}
			if (locaname != "" && locaname != null)
			{
			search += "and L.name like '%'+@locaname+'%' ";
			dynamicParams.Add("@locaname", locaname);
			}
			sql = @"select L.code,L.name,L.status,L.description,L.idwarehouse as stckcode,T.name as stckname,
			L.idparent as parentcode,S.name as parentname,L.data_sources,L.lm_user as usercode,U.username,L.lm_date
			from TSecLoca L
			left join TSecStck T on L.idwarehouse=T.code
			left join TSecLoca S on L.idparent=S.code
			left join TUser U on L.lm_user=U.usercode
			where 1=1 " + search;
			// --------------查询指定数据--------------
			var total = 0; //总条数
			data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = data.ToList();
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[仓位信息新增/编辑保存]
			public static ToMessage TSecLocaAddUpdate(string data_sources, string locacode, string locaname, string stckcode, string parentlocacode, string depth, string status, string description, string OperType, User us)
			{
			string sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			if (OperType == "Add")
			{
			//判断仓位编码是否重复
			sql = @"select * from TSecLoca where code=@locacode";
			dynamicParams.Add("@locacode", locacode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = "仓位编码已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			//判断往来单位名称是否重复
			sql = @"select * from TSecLoca where name=@locaname";
			dynamicParams.Add("@locaname", locaname);
			var data1 = DapperHelper.selectdata(sql, dynamicParams);
			if (data1.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = "仓位已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			if (depth == "1") //层级为1时,置空上级编码
			{
			parentlocacode = "";
			}
			//写入仓位
			sql = @"insert into TSecLoca(code,name,idwarehouse,idparent,status,description,lm_user,lm_date,data_sources,depth)
			values(@code,@name,@idwarehouse,@idparent,@status,@description,@lm_user,@lm_date,@data_sources,@depth)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			code = locacode,
			name = locaname,
			idwarehouse = stckcode,
			idparent = parentlocacode,
			status = status,
			description = description,
			lm_user = us.usercode,
			lm_date = DateTime.Now.ToString(),
			data_sources = data_sources,
			depth = depth
			}
			});
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了仓位:" + locacode, 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;
			}
			}
			if (OperType == "Update")
			{
			//判断上级货位编码是否等于货位编码
			if (locacode == parentlocacode)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = "上级货位不能是库位本身！";
			mes.data = null;
			return mes;
			}
			//判断往来单位名称是否重复
			sql = @"select * from TSecLoca where code<>@code and name=@name";
			dynamicParams.Add("@code", locacode);
			dynamicParams.Add("@name", locaname);
			var data1 = DapperHelper.selectdata(sql, dynamicParams);
			if (data1.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = "仓位名称已存在,请重新输入!";
			mes.data = null;
			return mes;
			}
			if (depth == "1") //层级为1时,置空上级编码
			{
			parentlocacode = "";
			}
			//更新存货分类
			sql = @"update TSecLoca set name=@name,idwarehouse=@idwarehouse,idparent=@idparent,depth=@depth,status=@status,description=@description,lm_user=@lm_user,lm_date=@lm_date
			where code=@code";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			code = locacode,
			name = locaname,
			idwarehouse = stckcode,
			idparent = parentlocacode,
			depth = depth,
			status = status,
			description = description,
			lm_user = us.usercode,
			lm_date = DateTime.Now.ToString()
			}
			});
			if (status == "1") //仓位停用时,下面所有的仓位停用
			{
			//更新库位状态为禁用
			sql = @"update TSecLoca set status=@status where idparent=@code";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			status = status,
			code = locacode
			}
			});
			}
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了仓位:" + locacode, 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)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[仓位信息删除]
			public static ToMessage TSecLocaDelete(string data_sources, string locacode, User us)
			{
			string sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			//判断当前仓位下是否有子项
			sql = @"select * from TSecLoca where idparent=@locacode";
			dynamicParams.Add("@locacode", locacode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = "当前仓位下存在子项,不允许删除!";
			mes.data = null;
			return mes;
			}
			//删除仓位
			sql = @"delete TSecLoca where code=@code and data_sources=@data_sources";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			code = locacode,
			data_sources = data_sources
			}
			});
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了仓位:" + locacode, 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)
			{

			mes.code = "300";
			mes.count = 0;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion


			#region[工序查询]
			public static ToMessage StepSearch(string stepcode, string stepname, string enable, string steptypecode, int startNum, int endNum, string prop, string order)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			try
			{
			if (stepcode != "" && stepcode != null)
			{
			search += "and A.stepcode like '%'+@stepcode+'%' ";
			dynamicParams.Add("@stepcode", stepcode);
			}
			if (stepname != "" && stepname != null)
			{
			search += "and A.stepname like '%'+@stepname+'%' ";
			dynamicParams.Add("@stepname", stepname);
			}
			if (enable != "" && enable != null)
			{
			search += "and A.enable=@enable ";
			dynamicParams.Add("@enable", enable);
			}
			if (steptypecode != "" && steptypecode != null)
			{
			search += "and A.flwtype=@steptypecode ";
			dynamicParams.Add("@steptypecode", steptypecode);
			}
			if (search == "")
			{
			search = "and 1=1 ";
			}
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select A.id,A.stepcode,A.stepname,A.flwtype,A.enable,A.descr,U.username as lm_user,A.lm_date
			from TStep A
			left join TUser U on A.lm_user=U.usercode
			where A.is_delete<>'1' " + search;
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = data.ToList();
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[工序新增编辑]
			public static ToMessage AddUpdateStep(string stepid, string stepcode, string stepname, string steptypecode, string enable, string description, User us, string operType)
			{
			var dynamicParams = new DynamicParameters();
			List<object> list = new List<object>();
			var sql = "";
			try
			{
			if (operType == "Add")
			{
			sql = @"select * from TStep where stepcode=@stepcode";
			dynamicParams.Add("@stepcode", stepcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = "操作失败,编码重复!";
			mes.data = null;
			return mes;
			}
			sql = @"insert into TStep(stepcode,stepname,flwtype,enable,descr,lm_user,lm_date)
			values(@stepcode,@stepname,@steptypecode,@enable,@description,@username,@CreateDate)";
			dynamicParams.Add("@stepcode", stepcode);
			dynamicParams.Add("@stepname", stepname);
			dynamicParams.Add("@steptypecode", steptypecode);
			dynamicParams.Add("@enable", enable);
			dynamicParams.Add("@description", description);
			dynamicParams.Add("@username", us.usercode);
			dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
			int cont = DapperHelper.SQL(sql, dynamicParams);
			if (cont > 0)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了工序:" + stepcode, 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;
			}
			}
			if (operType == "Update")
			{
			list.Clear();
			//如果当前工序使用状态位N(未启用),需判断当前工序是否被工单引用
			if (enable == "N")
			{
			var sql0 = @"select * from TK_Wrk_Step A where A.step_code=@stepcode";
			dynamicParams.Add("@stepcode", stepcode);
			var data = DapperHelper.selectdata(sql0, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = "工序有关联工单,不允许修改!";
			mes.data = null;
			return mes;
			}
			}
			sql = @"update TStep set stepname=@stepname,flwtype=@steptypecode,enable=@enable,descr=@description,
			lm_user=@username,lm_date=@CreateDate where id=@stepid";
			list.Add(new { str = sql, parm = new { stepid = stepid, stepname = stepname, steptypecode = steptypecode, enable = enable, description = description, username = us.usercode, CreateDate = DateTime.Now.ToString() } });
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了工序:" + stepcode, 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)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[工序删除]
			public static ToMessage DeleteStep(string stepcode, User us)
			{
			var sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			list.Clear();
			//当前工序是否关联工单
			sql = @"select * from TK_Wrk_Step A where A.step_code=@stepcode";
			dynamicParams.Add("@stepcode", stepcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = "工序有关联工单,不允许删除!";
			mes.data = null;
			return mes;
			}
			//删除工序
			sql = @"delete TStep where stepcode=@stepcode";
			list.Add(new { str = sql, parm = new { stepcode = stepcode } });
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了工序:" + stepcode, 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)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			}
			}