JLApi.git - Gitblit

			@@ -68,7 +68,7 @@
			}
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select A.status,A.usestatus,A.code,A.name,A.spec,A.warehousecode,S.name as warehousename,
			var sql = @"select A.status,A.usestatus,A.code,A.name,A.spec,A.warehousecode,S.name as warehousename,A.location_code,L.name as location_name,
			A.surp_life,(select isnull(sum(usecount_life),0) from TMould_UpDownReord R where R.mould_code=A.code) as serlife,
			A.resi_life,(case when isnull(M.mouldcode,'')='' then 'N' else 'Y' end) as is_part,
			STUFF((SELECT ',' + B.partcode
			@@ -78,6 +78,7 @@
			A.lm_user as usercode,U.username,A.lm_date
			from TMouldInfo A
			left join TSecStck S on A.warehousecode=S.code
			left join TSecLoca L on A.location_code=L.code
			left join (
			select distinct mouldcode from TMouldInfoPart
			) M on A.code=M.mouldcode
			@@ -85,7 +86,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();
			}
			@@ -93,7 +94,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -101,7 +102,7 @@
			#endregion

			#region[模具清单新增编辑]
			public static ToMessage AddUpdateMouldManger(string mouldcode, string mouldname, string mouldspec, string surplife, string resilife, string status, string mouldpart, string opertype, User us)
			public static ToMessage AddUpdateMouldManger(string mouldcode, string mouldname, string mouldspec,string warehousecode,string location_code, string surplife, string resilife, string status, string mouldpart, string opertype, User us)
			{
			var sql = "";
			var dynamicParams = new DynamicParameters();
			@@ -111,8 +112,8 @@
			if (opertype == "Add")
			{
			//写入模具清单表
			sql = @"insert into TMouldInfo(code,name,spec,status,surp_life,resi_life,lm_user,lm_date)
			values(@code,@name,@spec,@status,@surp_life,@resi_life,@lm_user,@lm_date)";
			sql = @"insert into TMouldInfo(code,name,spec,status,surp_life,resi_life,lm_user,lm_date,warehousecode,location_code)
			values(@code,@name,@spec,@status,@surp_life,@resi_life,@lm_user,@lm_date,@warehousecode,@location_code)";
			list.Add(new
			{
			str = sql,
			@@ -124,6 +125,8 @@
			status = status,
			surp_life = surplife,
			resi_life = resilife,
			warehousecode=warehousecode,
			location_code=location_code,
			lm_user = us.usercode,
			lm_date = DateTime.Now.ToString()
			}
			@@ -153,14 +156,14 @@
			LogHelper.DbOperateLog(us.usercode, "新增", "模具:" + mouldcode, 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;
			}
			}
			@@ -168,7 +171,7 @@
			{
			//修改模具清单表
			sql = @"update TMouldInfo set name=@name,spec=@spec,status=@status,
			surp_life=@surp_life,resi_life=@resi_life,lm_user=@lm_user,lm_date=@lm_date where code=@code";
			surp_life=@surp_life,resi_life=@resi_life,lm_user=@lm_user,lm_date=@lm_date,warehousecode=@warehousecode,location_code=@location_code where code=@code";
			list.Add(new
			{
			str = sql,
			@@ -180,6 +183,8 @@
			status = status,
			surp_life = surplife,
			resi_life = resilife,
			warehousecode = warehousecode,
			location_code = location_code,
			lm_user = us.usercode,
			lm_date = DateTime.Now.ToString()
			}
			@@ -219,14 +224,14 @@
			LogHelper.DbOperateLog(us.usercode, "修改", "模具:" + mouldcode, 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;
			}
			}
			@@ -235,7 +240,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -249,6 +254,7 @@
			string search = "";
			try
			{
			dynamicParams.Add("@mouldcode", mouldcode);
			if (opendate != "" && opendate != null)
			{
			search += "and AA.operdate between @opendate and @closedate ";
			@@ -257,47 +263,49 @@
			}
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select * from (
			var sql = @"select top 100 percent AA.*,U.username as operusername from (
			select '点检' as opertype,chk_user as operuser,chk_date as operdate,chk_result as operresult
			from TMouldchk_Proc_Main where mould_code='001'
			from TMouldchk_Proc_Main where mould_code=@mouldcode
			union all
			select '保养' as opertype,maint_user as operuser,maint_date as operdate,maint_result as operresult
			from TMouldmaint_Proc_Main where mould_code='001'
			from TMouldmaint_Proc_Main where mould_code=@mouldcode
			union all
			select '待维修' as opertype,request_person as operuser,request_date as operdate,'维修申请' as operresult
			from TMould_RepairRequest where mould_code='001'
			from TMould_RepairRequest where mould_code=@mouldcode
			union all
			select '已维修' as opertype,repair_person as operuser,repair_date as operdate,'维修完成' as operresult
			from TMould_RepairRequest A
			inner join TMould_Repair B on A.docu_code=B.source_wo
			where A.mould_code='001' and B.repair_person<>''
			where A.mould_code=@mouldcode and B.repair_person<>''
			union all
			select '已验证' as opertype,verify_person as operuser,verify_date as operdate,B.verify_result as operresult
			from TMould_RepairRequest A
			inner join TMould_Repair B on A.docu_code=B.source_wo
			where A.mould_code='001' and B.verify_person<>''
			where A.mould_code=@mouldcode and B.verify_person<>''
			union all
			select '已上机' as opertype,lm_user as operuser,lm_date as operdate,eqp_code as operresult
			from TMould_UpDownReord where mould_code='001' and type='UP'
			from TMould_UpDownReord where mould_code=@mouldcode and type='UP'
			union all
			select '已下机' as opertype,lm_user as operuser,lm_date as operdate,eqp_code as operresult
			from TMould_UpDownReord where mould_code='001' and type='DOWN'
			from TMould_UpDownReord where mould_code=@mouldcode and type='DOWN'
			union all
			select '已入库' as opertype,lm_user as operuser,lm_date as operdate,warehouse_code as operresult
			from TMould_InOutReord where mould_code='001' and type='IN'
			from TMould_InOutReord where mould_code=@mouldcode and type='IN'
			union all
			select '已出库' as opertype,lm_user as operuser,lm_date as operdate,warehouse_code as operresult
			from TMould_InOutReord where mould_code='001' and type='OUT'
			from TMould_InOutReord where mould_code=@mouldcode and type='OUT'
			union all
			select '已外借' as opertype,lm_user as operuser,lm_date as operdate,description as operresult
			from TMould_LendOutReord where mould_code='001' and type='OUT'
			from TMould_LendOutReord where mould_code=@mouldcode and type='OUT'
			union all
			select '已归还' as opertype,lm_user as operuser,lm_date as operdate,description as operresult
			from TMould_LendOutReord where mould_code='001' and type='IN'
			) as AA where 1=1 "+search+" order by AA.operdate desc ";
			from TMould_LendOutReord where mould_code=@mouldcode and type='IN'
			) as AA
			left join TUser U on AA.operuser=U.usercode
			where 1=1 " + search+" order by AA.operdate desc ";
			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();
			}
			@@ -305,7 +313,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -339,7 +347,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前模具存在操作记录,不允许删除!";
			mes.message = "当前模具存在操作记录,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -363,14 +371,14 @@
			LogHelper.DbOperateLog(us.usercode, "删除", "模具:" + mouldcode, 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;
			}

			@@ -379,7 +387,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -422,7 +430,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();
			}
			@@ -430,7 +438,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -459,14 +467,14 @@
			LogHelper.DbOperateLog(us.usercode, "新增", "模具点检项:" + checkitemcode, 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;
			}
			}
			@@ -487,14 +495,14 @@
			LogHelper.DbOperateLog(us.usercode, "修改", "模具点检项:" + checkitemcode, 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;
			}
			}
			@@ -503,7 +511,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -528,7 +536,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前点检项目已关联标准,不允许删除!";
			mes.message = "当前点检项目已关联标准,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -543,14 +551,14 @@
			LogHelper.DbOperateLog(us.usercode, "删除", "模具点检项:" + checkitemcode, 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;
			}

			@@ -559,7 +567,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -602,7 +610,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();
			}
			@@ -610,7 +618,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -641,7 +649,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "无点检标准信息!";
			mes.message = "无点检标准信息!";
			mes.data = null;
			return mes;
			}
			@@ -654,14 +662,14 @@
			rout.Data = data0;

			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = rout;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -708,14 +716,14 @@
			LogHelper.DbOperateLog(us.usercode, "新增", "模具点检标准:" + json.code, 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;
			}
			}
			@@ -755,14 +763,14 @@
			LogHelper.DbOperateLog(us.usercode, "修改", "模具点检标准:" + json.code, 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;
			}
			}
			@@ -771,7 +779,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -793,7 +801,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前点检标准已生成点检记录,不允许删除!";
			mes.message = "当前点检标准已生成点检记录,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -813,14 +821,14 @@
			LogHelper.DbOperateLog(us.usercode, "删除", "模具点检标准:" + checkstand_code, 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;
			}
			}
			@@ -828,7 +836,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -861,13 +869,13 @@
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.Message = "无模具资料!";
			mes.message = "无模具资料!";
			mes.data = null;
			}
			}
			@@ -875,7 +883,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -931,14 +939,14 @@
			LogHelper.DbOperateLog(us.usercode, "模具点检标准关联模具", "模具点检标准:" + checkstand_code, 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;
			}
			}
			@@ -946,7 +954,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -989,7 +997,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();
			}
			@@ -997,7 +1005,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1026,14 +1034,14 @@
			LogHelper.DbOperateLog(us.usercode, "新增", "模具保养项:" + maiitemcode, 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;
			}
			}
			@@ -1054,14 +1062,14 @@
			LogHelper.DbOperateLog(us.usercode, "修改", "模具保养项:" + maiitemcode, 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;
			}
			}
			@@ -1070,7 +1078,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1095,7 +1103,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前保养项目已关联标准,不允许删除!";
			mes.message = "当前保养项目已关联标准,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -1110,14 +1118,14 @@
			LogHelper.DbOperateLog(us.usercode, "删除", "模具保养项:" + maiitemcode, 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;
			}

			@@ -1126,7 +1134,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1169,7 +1177,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();
			}
			@@ -1177,7 +1185,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1208,7 +1216,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "无点检标准信息!";
			mes.message = "无点检标准信息!";
			mes.data = null;
			return mes;
			}
			@@ -1221,14 +1229,14 @@
			rout.Data = data0;

			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = rout;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1275,14 +1283,14 @@
			LogHelper.DbOperateLog(us.usercode, "新增", "模具保养标准:" + json.code, 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;
			}
			}
			@@ -1322,14 +1330,14 @@
			LogHelper.DbOperateLog(us.usercode, "修改", "模具保养标准:" + json.code, 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;
			}
			}
			@@ -1338,7 +1346,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1360,7 +1368,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前保养标准已生成点检记录,不允许删除!";
			mes.message = "当前保养标准已生成点检记录,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -1380,14 +1388,14 @@
			LogHelper.DbOperateLog(us.usercode, "删除", "模具保养标准:" + repairstand_code, 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;
			}
			}
			@@ -1395,7 +1403,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1428,13 +1436,13 @@
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.Message = "无模具资料!";
			mes.message = "无模具资料!";
			mes.data = null;
			}
			}
			@@ -1442,7 +1450,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1498,14 +1506,14 @@
			LogHelper.DbOperateLog(us.usercode, "模具保养标准关联模具", "模具保养标准:" + repairstand_code, 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;
			}
			}
			@@ -1513,7 +1521,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1537,13 +1545,13 @@
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.Message = "当前模具编码不存在或不可用!";
			mes.message = "当前模具编码不存在或不可用!";
			mes.data = data;
			}
			}
			@@ -1551,7 +1559,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1574,13 +1582,13 @@
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.Message = "当前模具未指定点检标准!";
			mes.message = "当前模具未指定点检标准!";
			mes.data = data;
			}
			}
			@@ -1588,7 +1596,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1615,13 +1623,13 @@
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.Message = "当前模具未设置点检标准绑定点检项目!";
			mes.message = "当前模具未设置点检标准绑定点检项目!";
			mes.data = data;
			}
			}
			@@ -1629,7 +1637,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1660,7 +1668,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "点检项信息不能为空!";
			mes.message = "点检项信息不能为空!";
			mes.data = null;
			return mes;
			}
			@@ -1710,14 +1718,14 @@
			LogHelper.DbOperateLog(us.usercode, "模具点检", "模具:" + json.code, 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;
			}
			}
			@@ -1725,7 +1733,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1749,13 +1757,13 @@
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.Message = "当前模具编码不存在或不可用!";
			mes.message = "当前模具编码不存在或不可用!";
			mes.data = data;
			}
			}
			@@ -1763,7 +1771,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1786,13 +1794,13 @@
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.Message = "当前模具未指定保养标准!";
			mes.message = "当前模具未指定保养标准!";
			mes.data = data;
			}
			}
			@@ -1800,7 +1808,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1827,13 +1835,13 @@
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.Message = "当前模具未设置保养标准绑定保养项目!";
			mes.message = "当前模具未设置保养标准绑定保养项目!";
			mes.data = data;
			}
			}
			@@ -1841,7 +1849,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1872,7 +1880,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "保养项信息不能为空!";
			mes.message = "保养项信息不能为空!";
			mes.data = null;
			return mes;
			}
			@@ -1922,14 +1930,14 @@
			LogHelper.DbOperateLog(us.usercode, "模具保养", "模具:" + json.code, 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;
			}
			}
			@@ -1937,7 +1945,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1965,14 +1973,14 @@
			if (dt.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = dt;
			return mes;
			}
			else
			{
			mes.code = "300";
			mes.Message = "暂无数据或无效的模具二维码信息!";
			mes.message = "暂无数据或无效的模具二维码信息!";
			mes.data = null;
			return mes;
			}
			@@ -1982,7 +1990,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2051,14 +2059,14 @@
			}
			list.Add(moud);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = list;
			return mes;
			}
			else
			{
			mes.code = "300";
			mes.Message = "暂无数据或无效的模具二维码信息!";
			mes.message = "暂无数据或无效的模具二维码信息!";
			mes.data = null;
			return mes;
			}
			@@ -2067,7 +2075,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2092,17 +2100,17 @@
			{
			case "0": //在库
			mes.code = "300";
			mes.Message = "当前模具在库状态,请先出库操作!";
			mes.message = "当前模具在库状态,请先出库操作!";
			mes.data = null;
			return mes;
			case "2": //上机
			mes.code = "300";
			mes.Message = "当前模具上机状态,请先下机操作!";
			mes.message = "当前模具上机状态,请先下机操作!";
			mes.data = null;
			return mes;
			case "7": //外借
			mes.code = "300";
			mes.Message = "当前模具外借状态,请先归还操作!";
			mes.message = "当前模具外借状态,请先归还操作!";
			mes.data = null;
			return mes;
			default:
			@@ -2112,7 +2120,7 @@
			else
			{
			mes.code = "300";
			mes.Message = "无效的模具二维码信息!";
			mes.message = "无效的模具二维码信息!";
			mes.data = null;
			return mes;
			}
			@@ -2128,13 +2136,13 @@
			if (rows.Length > 0)
			{
			mes.code = "300";
			mes.Message = "当前模具已维修申请,待维修!";
			mes.message = "当前模具已维修申请,待维修!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.Message = "当前模具已维修,待确认验证!";
			mes.message = "当前模具已维修,待确认验证!";
			mes.data = null;
			}
			}
			@@ -2149,13 +2157,13 @@
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.Message = "当前模具编码不存在或不可用!";
			mes.message = "当前模具编码不存在或不可用!";
			mes.data = data;
			}
			}
			@@ -2164,7 +2172,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2258,14 +2266,14 @@
			LogHelper.DbOperateLog(us.usercode, "模具维修申请", "模具:" + mouldcode, 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;
			}
			}
			@@ -2273,7 +2281,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2306,13 +2314,13 @@
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.Message = "暂无维修申请记录!";
			mes.message = "暂无维修申请记录!";
			mes.data = data;
			}
			}
			@@ -2320,7 +2328,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2418,14 +2426,14 @@
			LogHelper.DbOperateLog(us.usercode, "模具维修", "模具:" + mouldcode, 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;
			}
			}
			@@ -2433,7 +2441,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2465,13 +2473,13 @@
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			}
			else
			{
			mes.code = "300";
			mes.Message = "暂无维修记录!";
			mes.message = "暂无维修记录!";
			mes.data = data;
			}
			}
			@@ -2479,7 +2487,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2515,13 +2523,13 @@
			}
			dict.Add("repair_content", data.Rows[0]["repair_content"].ToString()); //维修内容
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = dict;
			}
			else
			{
			mes.code = "300";
			mes.Message = "暂无维修记录!";
			mes.message = "暂无维修记录!";
			mes.data = null;
			}
			}
			@@ -2529,7 +2537,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2604,14 +2612,14 @@
			LogHelper.DbOperateLog(us.usercode, "模具维修验证", "模具:" + mouldcode, 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;
			}
			}
			@@ -2619,7 +2627,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2648,22 +2656,22 @@
			{
			case "0": //在库
			mes.code = "300";
			mes.Message = "当前模具在库状态,不符合上机操作!";
			mes.message = "当前模具在库状态,不符合上机操作!";
			mes.data = null;
			return mes;
			case "2": //上机
			mes.code = "300";
			mes.Message = "当前模具上机状态,不符合上机操作!";
			mes.message = "当前模具上机状态,不符合上机操作!";
			mes.data = null;
			return mes;
			case "7": //外借
			mes.code = "300";
			mes.Message = "当前模具外借状态,不符合上机操作!";
			mes.message = "当前模具外借状态,不符合上机操作!";
			mes.data = null;
			return mes;
			default:
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = dt;
			break;
			}
			@@ -2671,7 +2679,7 @@
			else
			{
			mes.code = "300";
			mes.Message = "模具故障或维修中,不允许上机!";
			mes.message = "模具故障或维修中,不允许上机!";
			mes.data = null;
			return mes;
			}
			@@ -2679,7 +2687,7 @@
			else
			{
			mes.code = "300";
			mes.Message = "无效的模具二维码信息!";
			mes.message = "无效的模具二维码信息!";
			mes.data = null;
			return mes;
			}
			@@ -2689,7 +2697,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2709,14 +2717,14 @@
			)";
			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;
			@@ -2759,14 +2767,14 @@
			LogHelper.DbOperateLog(us.usercode, "模具上机", "模具:" + mouldcode, 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;
			}
			}
			@@ -2774,7 +2782,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2810,14 +2818,14 @@
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			return mes;
			}
			else
			{
			mes.code = "300";
			mes.Message = "当前模具未上机,不符合下机操作!";
			mes.message = "当前模具未上机,不符合下机操作!";
			mes.data = null;
			return mes;
			}
			@@ -2825,7 +2833,7 @@
			else
			{
			mes.code = "300";
			mes.Message = "模具故障或维修中,不符合下机操作!";
			mes.message = "模具故障或维修中,不符合下机操作!";
			mes.data = null;
			return mes;
			}
			@@ -2833,7 +2841,7 @@
			else
			{
			mes.code = "300";
			mes.Message = "无效的模具二维码信息!";
			mes.message = "无效的模具二维码信息!";
			mes.data = null;
			return mes;
			}
			@@ -2843,7 +2851,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2901,14 +2909,14 @@
			LogHelper.DbOperateLog(us.usercode, "模具下机", "模具:" + mouldcode, 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;
			}
			}
			@@ -2916,7 +2924,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2945,22 +2953,22 @@
			{
			case "0": //在库
			mes.code = "300";
			mes.Message = "当前模具在库状态,不符合外借操作!";
			mes.message = "当前模具在库状态,不符合外借操作!";
			mes.data = null;
			return mes;
			case "2": //上机
			mes.code = "300";
			mes.Message = "当前模具上机状态,不符合外借操作!";
			mes.message = "当前模具上机状态,不符合外借操作!";
			mes.data = null;
			return mes;
			case "7": //外借
			mes.code = "300";
			mes.Message = "当前模具外借状态,不符合外借操作!";
			mes.message = "当前模具外借状态,不符合外借操作!";
			mes.data = null;
			return mes;
			default:
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = dt;
			break;
			}
			@@ -2968,7 +2976,7 @@
			else
			{
			mes.code = "300";
			mes.Message = "模具故障或维修中,不允许外借!";
			mes.message = "模具故障或维修中,不允许外借!";
			mes.data = null;
			return mes;
			}
			@@ -2976,7 +2984,7 @@
			else
			{
			mes.code = "300";
			mes.Message = "无效的模具二维码信息!";
			mes.message = "无效的模具二维码信息!";
			mes.data = null;
			return mes;
			}
			@@ -2986,7 +2994,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3029,14 +3037,14 @@
			LogHelper.DbOperateLog(us.usercode, "模具外借", "模具:" + mouldcode, 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;
			}
			}
			@@ -3044,7 +3052,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3079,14 +3087,14 @@
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			return mes;
			}
			else
			{
			mes.code = "300";
			mes.Message = "当前模具未外借,不符合归还操作!";
			mes.message = "当前模具未外借,不符合归还操作!";
			mes.data = null;
			return mes;
			}
			@@ -3094,7 +3102,7 @@
			else
			{
			mes.code = "300";
			mes.Message = "模具故障或维修中,不符合归还操作!";
			mes.message = "模具故障或维修中,不符合归还操作!";
			mes.data = null;
			return mes;
			}
			@@ -3102,7 +3110,7 @@
			else
			{
			mes.code = "300";
			mes.Message = "无效的模具二维码信息!";
			mes.message = "无效的模具二维码信息!";
			mes.data = null;
			return mes;
			}
			@@ -3112,7 +3120,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3159,14 +3167,14 @@
			LogHelper.DbOperateLog(us.usercode, "模具归还", "模具:" + mouldcode, 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;
			}
			}
			@@ -3174,7 +3182,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3203,22 +3211,22 @@
			{
			case "0": //在库
			mes.code = "300";
			mes.Message = "当前模具在库状态,不符合入库操作!";
			mes.message = "当前模具在库状态,不符合入库操作!";
			mes.data = null;
			return mes;
			case "2": //上机
			mes.code = "300";
			mes.Message = "当前模具上机状态,不符合入库操作!";
			mes.message = "当前模具上机状态,不符合入库操作!";
			mes.data = null;
			return mes;
			case "7": //外借
			mes.code = "300";
			mes.Message = "当前模具外借状态,不符合入库操作!";
			mes.message = "当前模具外借状态,不符合入库操作!";
			mes.data = null;
			return mes;
			default:
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = dt;
			break;
			}
			@@ -3226,7 +3234,7 @@
			else
			{
			mes.code = "300";
			mes.Message = "模具故障或维修中,不允许入库操作!";
			mes.message = "模具故障或维修中,不允许入库操作!";
			mes.data = null;
			return mes;
			}
			@@ -3234,7 +3242,7 @@
			else
			{
			mes.code = "300";
			mes.Message = "无效的模具二维码信息!";
			mes.message = "无效的模具二维码信息!";
			mes.data = null;
			return mes;
			}
			@@ -3244,7 +3252,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3252,7 +3260,7 @@
			#endregion

			#region[模具入库提交]
			public static ToMessage MouldInWareHouseSave(string mouldcode, string warehousecode, string description, User us)
			public static ToMessage MouldInWareHouseSave(string mouldcode, string warehousecode,string locationcode, string description, User us)
			{
			var sql = "";
			List<object> list = new List<object>();
			@@ -3261,8 +3269,8 @@
			{
			list.Clear();
			//写入模具出入库记录表(入库操作)
			sql = @"insert into TMould_InOutReord(mould_code,type,warehouse_code,description,lm_user,lm_date)
			values(@mould_code,@type,@warehouse_code,@description,@lm_user,@lm_date)";
			sql = @"insert into TMould_InOutReord(mould_code,type,warehouse_code,location_code,description,lm_user,lm_date)
			values(@mould_code,@type,@warehouse_code,@location_code,@description,@lm_user,@lm_date)";
			list.Add(new
			{
			str = sql,
			@@ -3271,6 +3279,7 @@
			mould_code = mouldcode,
			type = "IN",
			warehouse_code = warehousecode,
			location_code = locationcode,
			description = description,
			lm_user = us.usercode,
			lm_date = DateTime.Now.ToString()
			@@ -3278,8 +3287,8 @@
			});

			//回写模具清单,使用状态(入库),仓库编码
			sql = @"update TMouldInfo set usestatus='0',warehousecode=@warehousecode where code=@mouldcode";
			list.Add(new { str = sql, parm = new { mouldcode = mouldcode, warehousecode = warehousecode } });
			sql = @"update TMouldInfo set usestatus='0',warehousecode=@warehousecode,location_code=@location_code where code=@mouldcode";
			list.Add(new { str = sql, parm = new { mouldcode = mouldcode, warehousecode = warehousecode, location_code = locationcode } });

			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			@@ -3288,14 +3297,14 @@
			LogHelper.DbOperateLog(us.usercode, "模具入库", "模具:" + mouldcode, 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;
			}
			}
			@@ -3303,7 +3312,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3329,23 +3338,24 @@
			{
			//判断当前模具是否在外借状态
			sql = @"select M.code as mould_code,M.name as mould_name,M.spec as mould_spec,
			M.surp_life,M.resi_life,M.warehousecode,C.name as warehousename
			M.surp_life,M.resi_life,M.warehousecode,C.name as warehousename,M.location_code,L.name as location_name
			from TMouldInfo M
			left join TSecStck C on M.warehousecode=C.code
			left join TSecLoca L on M.location_code=L.code
			where M.code=@mouldcode and M.usestatus='0'";
			dynamicParams.Add("@mouldcode", mouldcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			return mes;
			}
			else
			{
			mes.code = "300";
			mes.Message = "当前模具未在库,不符合出库操作!";
			mes.message = "当前模具未在库,不符合出库操作!";
			mes.data = null;
			return mes;
			}
			@@ -3353,7 +3363,7 @@
			else
			{
			mes.code = "300";
			mes.Message = "模具故障或维修中,不符合出库操作!";
			mes.message = "模具故障或维修中,不符合出库操作!";
			mes.data = null;
			return mes;
			}
			@@ -3361,7 +3371,7 @@
			else
			{
			mes.code = "300";
			mes.Message = "无效的模具二维码信息!";
			mes.message = "无效的模具二维码信息!";
			mes.data = null;
			return mes;
			}
			@@ -3371,7 +3381,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3379,7 +3389,7 @@
			#endregion

			#region[模具出库提交]
			public static ToMessage MouldOutWareHouseSave(string mouldcode, string warehousecode, string description, User us)
			public static ToMessage MouldOutWareHouseSave(string mouldcode, string warehousecode,string locationcode, string description, User us)
			{
			var sql = "";
			List<object> list = new List<object>();
			@@ -3388,8 +3398,8 @@
			{
			list.Clear();
			//写入模具出入库记录表(出库操作)
			sql = @"insert into TMould_InOutReord(mould_code,type,warehouse_code,description,lm_user,lm_date)
			values(@mould_code,@type,@warehouse_code,@description,@lm_user,@lm_date)";
			sql = @"insert into TMould_InOutReord(mould_code,type,warehouse_code,location_code,description,lm_user,lm_date)
			values(@mould_code,@type,@warehouse_code,@location_code,@description,@lm_user,@lm_date)";
			list.Add(new
			{
			str = sql,
			@@ -3398,6 +3408,7 @@
			mould_code = mouldcode,
			type = "OUT",
			warehouse_code = warehousecode,
			location_code= locationcode,
			description = description,
			lm_user = us.usercode,
			lm_date = DateTime.Now.ToString()
			@@ -3405,8 +3416,8 @@
			});

			//回写模具清单,使用状态(出库),清除仓库编码
			sql = @"update TMouldInfo set usestatus='1',warehousecode=@warehousecode where code=@mouldcode";
			list.Add(new { str = sql, parm = new { mouldcode = mouldcode, warehousecode ="" } });
			sql = @"update TMouldInfo set usestatus='1',warehousecode=@warehousecode,location_code=@location_code where code=@mouldcode";
			list.Add(new { str = sql, parm = new { mouldcode = mouldcode, warehousecode ="", location_code="" } });

			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			@@ -3415,14 +3426,14 @@
			LogHelper.DbOperateLog(us.usercode, "模具出库", "模具:" + mouldcode, 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;
			}
			}
			@@ -3430,7 +3441,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3497,7 +3508,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();
			}
			@@ -3505,7 +3516,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3527,14 +3538,14 @@
			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;
			@@ -3631,7 +3642,7 @@
			data.TableName = "Table"; //设置DataTable的名称
			string msg = DownLoad.DataTableToExcel(data, "模具点检记录报表");
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = msg;
			}
			@@ -3639,7 +3650,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3695,14 +3706,9 @@
			search += "and A.maint_result=@repairresult ";
			dynamicParams.Add("@repairresult", repairresult);
			}
			if (search == "")
			{
			search = "and 1=1 ";
			}
			//search = search.Substring(3);//截取索引2后面的字符
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select A.bywo,A.mould_code,E.name as mould_name,E.spec as mould_spec,M.code as stanedcode,M.name as stanedname,
			var sql = @"select A.id,A.bywo,A.mould_code,E.name as mould_name,E.spec as mould_spec,M.code as stanedcode,M.name as stanedname,
			U.username as maint_user,A.maint_result,A.maint_date
			from TMouldmaint_Proc_Main A
			left join TMouldInfo E on A.mould_code=E.code
			@@ -3711,7 +3717,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();
			}
			@@ -3719,7 +3725,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3741,14 +3747,14 @@
			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;
			@@ -3803,10 +3809,6 @@
			search += "and A.maint_result=@repairresult ";
			dynamicParams.Add("@repairresult", repairresult);
			}
			if (search == "")
			{
			search = "and 1=1 ";
			}
			//search = search.Substring(3);//截取索引2后面的字符
			// --------------查询指定数据--------------
			var total = 0; //总条数
			@@ -3850,7 +3852,7 @@
			data.TableName = "Table"; //设置DataTable的名称
			string msg = DownLoad.DataTableToExcel(data, "模具保养记录报表");
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = msg;
			}
			@@ -3858,7 +3860,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3921,11 +3923,6 @@
			dynamicParams.Add("@vrifcatopendate", vrifcatopendate + " 00:00:00");
			dynamicParams.Add("@vrifcatclosedate", vrifcatclosedate + " 23:59:59");
			}

			if (search == "")
			{
			search = "and 1=1 ";
			}
			//search = search.Substring(3);//截取索引2后面的字符
			// --------------查询指定数据--------------
			var total = 0; //总条数
			@@ -3941,7 +3938,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();
			}
			@@ -3949,7 +3946,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -4011,14 +4008,14 @@
			repair.repairimage = data3;
			Dict.Add("data2", repair);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = Dict;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -4080,11 +4077,6 @@
			dynamicParams.Add("@vrifcatopendate", vrifcatopendate + " 00:00:00");
			dynamicParams.Add("@vrifcatclosedate", vrifcatclosedate + " 23:59:59");
			}

			if (search == "")
			{
			search = "and 1=1 ";
			}
			//search = search.Substring(3);//截取索引2后面的字符
			// --------------查询指定数据--------------
			var total = 0; //总条数
			@@ -4103,7 +4095,7 @@
			data.TableName = "Table"; //设置DataTable的名称
			string msg = DownLoad.DataTableToExcel(data, "模具维修记录报表");
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = msg;
			}
			@@ -4111,7 +4103,442 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion


			#region[模具上下机记录查询]
			public static ToMessage MouldUpDownMachinesSearch(string mouldcode, string mouldname, string mouldspec, string type, string devicecode, string operuser, string opendate, string closedate, int startNum, int endNum, string prop, string order)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			try
			{
			if (mouldcode != "" && mouldcode != null)
			{
			search += "and A.mould_code like '%'+@mouldcode+'%' ";
			dynamicParams.Add("@mouldcode", mouldcode);
			}
			if (mouldname != "" && mouldname != null)
			{
			search += "and M.name like '%'+@mouldname+'%' ";
			dynamicParams.Add("@mouldname", mouldname);
			}
			if (mouldspec != "" && mouldspec != null)
			{
			search += "and M.spec like '%'+@mouldspec+'%' ";
			dynamicParams.Add("@mouldspec", mouldspec);
			}
			if (type != "" && type != null)
			{
			search += "and A.type=@type ";
			dynamicParams.Add("@type", type);
			}
			if (devicecode != "" && devicecode != null)
			{
			search += "and A.eqp_code=@devicecode ";
			dynamicParams.Add("@devicecode", devicecode);
			}
			if (operuser != "" && operuser != null)
			{
			search += "and U.username like '%'+@operuser+'%' ";
			dynamicParams.Add("@operuser", operuser);
			}
			if (opendate != "" && opendate != null)
			{
			search += "and A.lm_date between @opendate and @closedate ";
			dynamicParams.Add("@opendate", opendate + " 00:00:00");
			dynamicParams.Add("@closedate", closedate + " 23:59:59");
			}
			//search = search.Substring(3);//截取索引2后面的字符
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select A.mould_code,M.name as mould_name,M.spec as mould_spec,
			(case when A.type='UP' then '上机' else '下机' end) as type,A.usecount_life,
			A.eqp_code,E.name as eqp_name,U.username as lm_user,A.lm_date
			from TMould_UpDownReord A
			left join TMouldInfo M on A.mould_code=M.code
			left join TEqpInfo E on A.eqp_code=E.code
			left join TUser U on A.lm_user=U.usercode
			where 1=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[模具上下机记导出Excel]
			public static ToMessage MouldUpDownMachinesOutExcel(string mouldcode, string mouldname, string mouldspec, string type, string devicecode, string operuser, string opendate, string closedate)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			try
			{
			if (mouldcode != "" && mouldcode != null)
			{
			search += "and A.mould_code like '%'+@mouldcode+'%' ";
			dynamicParams.Add("@mouldcode", mouldcode);
			}
			if (mouldname != "" && mouldname != null)
			{
			search += "and M.name like '%'+@mouldname+'%' ";
			dynamicParams.Add("@mouldname", mouldname);
			}
			if (mouldspec != "" && mouldspec != null)
			{
			search += "and M.spec like '%'+@mouldspec+'%' ";
			dynamicParams.Add("@mouldspec", mouldspec);
			}
			if (type != "" && type != null)
			{
			search += "and A.type=@type ";
			dynamicParams.Add("@type", type);
			}
			if (devicecode != "" && devicecode != null)
			{
			search += "and A.eqp_code=@devicecode ";
			dynamicParams.Add("@devicecode", devicecode);
			}
			if (operuser != "" && operuser != null)
			{
			search += "and U.username like '%'+@operuser+'%' ";
			dynamicParams.Add("@operuser", operuser);
			}
			if (opendate != "" && opendate != null)
			{
			search += "and A.lm_date between @opendate and @closedate ";
			dynamicParams.Add("@opendate", opendate + " 00:00:00");
			dynamicParams.Add("@closedate", closedate + " 23:59:59");
			}
			//search = search.Substring(3);//截取索引2后面的字符
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select A.mould_code as '模具编码',M.name as '模具名称',M.spec as '模具规格',
			(case when A.type='UP' then '上机' else '下机' end) as '操作类型',A.usecount_life as '本次使用',
			A.eqp_code as '设备编码',E.name as '设备名称',U.username as '操作人员',A.lm_date as '操作时间'
			from TMould_UpDownReord A
			left join TMouldInfo M on A.mould_code=M.code
			left join TEqpInfo E on A.eqp_code=E.code
			left join TUser U on A.lm_user=U.usercode
			where 1=1 " + search;
			DataTable data = DapperHelper.selectdata(sql, dynamicParams);
			data.TableName = "Table"; //设置DataTable的名称
			string msg = DownLoad.DataTableToExcel(data, "模具上下机记录报表");
			mes.code = "200";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = msg;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion


			#region[模具借还记录查询]
			public static ToMessage MouldCirculateMachinesSearch(string mouldcode, string mouldname, string mouldspec, string type, string operuser, string opendate, string closedate, int startNum, int endNum, string prop, string order)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			try
			{
			if (mouldcode != "" && mouldcode != null)
			{
			search += "and A.mould_code like '%'+@mouldcode+'%' ";
			dynamicParams.Add("@mouldcode", mouldcode);
			}
			if (mouldname != "" && mouldname != null)
			{
			search += "and M.name like '%'+@mouldname+'%' ";
			dynamicParams.Add("@mouldname", mouldname);
			}
			if (mouldspec != "" && mouldspec != null)
			{
			search += "and M.spec like '%'+@mouldspec+'%' ";
			dynamicParams.Add("@mouldspec", mouldspec);
			}
			if (type != "" && type != null)
			{
			search += "and A.type=@type ";
			dynamicParams.Add("@type", type);
			}
			if (operuser != "" && operuser != null)
			{
			search += "and U.username like '%'+@operuser+'%' ";
			dynamicParams.Add("@operuser", operuser);
			}
			if (opendate != "" && opendate != null)
			{
			search += "and A.lm_date between @opendate and @closedate ";
			dynamicParams.Add("@opendate", opendate + " 00:00:00");
			dynamicParams.Add("@closedate", closedate + " 23:59:59");
			}
			//search = search.Substring(3);//截取索引2后面的字符
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select A.mould_code,M.name as mould_name,M.spec as mould_spec,
			(case when A.type='OUT' then '外借' else '归还' end) as type,
			A.description,U.username as lm_user,A.lm_date
			from TMould_LendOutReord A
			left join TMouldInfo M on A.mould_code=M.code
			left join TUser U on A.lm_user=U.usercode
			where 1=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 MouldCirculateMachinesOutExcel(string mouldcode, string mouldname, string mouldspec, string type, string operuser, string opendate, string closedate)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			try
			{
			if (mouldcode != "" && mouldcode != null)
			{
			search += "and A.mould_code like '%'+@mouldcode+'%' ";
			dynamicParams.Add("@mouldcode", mouldcode);
			}
			if (mouldname != "" && mouldname != null)
			{
			search += "and M.name like '%'+@mouldname+'%' ";
			dynamicParams.Add("@mouldname", mouldname);
			}
			if (mouldspec != "" && mouldspec != null)
			{
			search += "and M.spec like '%'+@mouldspec+'%' ";
			dynamicParams.Add("@mouldspec", mouldspec);
			}
			if (type != "" && type != null)
			{
			search += "and A.type=@type ";
			dynamicParams.Add("@type", type);
			}
			if (operuser != "" && operuser != null)
			{
			search += "and U.username like '%'+@operuser+'%' ";
			dynamicParams.Add("@operuser", operuser);
			}
			if (opendate != "" && opendate != null)
			{
			search += "and A.lm_date between @opendate and @closedate ";
			dynamicParams.Add("@opendate", opendate + " 00:00:00");
			dynamicParams.Add("@closedate", closedate + " 23:59:59");
			}
			//search = search.Substring(3);//截取索引2后面的字符
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select A.mould_code as '模具编码',M.name as '模具名称',M.spec as '规格型号',
			(case when A.type='OUT' then '外借' else '归还' end) as '操作类型',
			A.description as '描述',U.username as '操作人员',A.lm_date as '操作时间'
			from TMould_LendOutReord A
			left join TMouldInfo M on A.mould_code=M.code
			left join TUser U on A.lm_user=U.usercode
			where 1=1 " + search;
			DataTable data = DapperHelper.selectdata(sql, dynamicParams);
			data.TableName = "Table"; //设置DataTable的名称
			string msg = DownLoad.DataTableToExcel(data, "模具借还记录报表");
			mes.code = "200";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = msg;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion


			#region[模具出入库记录查询]
			public static ToMessage MouldInOutMachinesSearch(string mouldcode, string mouldname, string mouldspec, string type, string warehousecode, string locationcode, string operuser, string opendate, string closedate, int startNum, int endNum, string prop, string order)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			try
			{
			if (mouldcode != "" && mouldcode != null)
			{
			search += "and A.mould_code like '%'+@mouldcode+'%' ";
			dynamicParams.Add("@mouldcode", mouldcode);
			}
			if (mouldname != "" && mouldname != null)
			{
			search += "and M.name like '%'+@mouldname+'%' ";
			dynamicParams.Add("@mouldname", mouldname);
			}
			if (mouldspec != "" && mouldspec != null)
			{
			search += "and M.spec like '%'+@mouldspec+'%' ";
			dynamicParams.Add("@mouldspec", mouldspec);
			}
			if (type != "" && type != null)
			{
			search += "and A.type=@type ";
			dynamicParams.Add("@type", type);
			}
			if (warehousecode != "" && warehousecode != null)
			{
			search += "and A.warehouse_code=@warehousecode ";
			dynamicParams.Add("@warehousecode", warehousecode);
			}
			if (locationcode != "" && locationcode != null)
			{
			search += "and A.location_code=@locationcode ";
			dynamicParams.Add("@locationcode", locationcode);
			}
			if (operuser != "" && operuser != null)
			{
			search += "and U.username like '%'+@operuser+'%' ";
			dynamicParams.Add("@operuser", operuser);
			}
			if (opendate != "" && opendate != null)
			{
			search += "and A.lm_date between @opendate and @closedate ";
			dynamicParams.Add("@opendate", opendate + " 00:00:00");
			dynamicParams.Add("@closedate", closedate + " 23:59:59");
			}
			//search = search.Substring(3);//截取索引2后面的字符
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select A.mould_code,M.name as mould_name,M.spec as mould_spec,A.warehouse_code,S.name as warehouse_name,
			A.location_code,L.name as location_name,(case when A.type='OUT' then '出库' else '入库' end) as type,
			A.description,U.username as lm_user,A.lm_date
			from TMould_InOutReord A
			left join TMouldInfo M on A.mould_code=M.code
			left join TSecStck S on A.warehouse_code=S.code
			left join TSecLoca L on A.location_code=L.code
			left join TUser U on A.lm_user=U.usercode
			where 1=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 MouldInOutMachinesOutExcel(string mouldcode, string mouldname, string mouldspec, string type, string warehousecode, string locationcode, string operuser, string opendate, string closedate)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			try
			{
			if (mouldcode != "" && mouldcode != null)
			{
			search += "and A.mould_code like '%'+@mouldcode+'%' ";
			dynamicParams.Add("@mouldcode", mouldcode);
			}
			if (mouldname != "" && mouldname != null)
			{
			search += "and M.name like '%'+@mouldname+'%' ";
			dynamicParams.Add("@mouldname", mouldname);
			}
			if (mouldspec != "" && mouldspec != null)
			{
			search += "and M.spec like '%'+@mouldspec+'%' ";
			dynamicParams.Add("@mouldspec", mouldspec);
			}
			if (type != "" && type != null)
			{
			search += "and A.type=@type ";
			dynamicParams.Add("@type", type);
			}
			if (warehousecode != "" && warehousecode != null)
			{
			search += "and A.warehouse_code=@warehousecode ";
			dynamicParams.Add("@warehousecode", warehousecode);
			}
			if (locationcode != "" && locationcode != null)
			{
			search += "and A.location_code=@locationcode ";
			dynamicParams.Add("@locationcode", locationcode);
			}
			if (operuser != "" && operuser != null)
			{
			search += "and U.username like '%'+@operuser+'%' ";
			dynamicParams.Add("@operuser", operuser);
			}
			if (opendate != "" && opendate != null)
			{
			search += "and A.lm_date between @opendate and @closedate ";
			dynamicParams.Add("@opendate", opendate + " 00:00:00");
			dynamicParams.Add("@closedate", closedate + " 23:59:59");
			}
			//search = search.Substring(3);//截取索引2后面的字符
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select A.mould_code as 模具编码,M.name as 模具名称,M.spec as 规格型号,A.warehouse_code as 仓库编码,S.name as 仓库名称,
			A.location_code as 库位编码,L.name as 库位名称,(case when A.type='OUT' then '出库' else '入库' end) as 操作类型,
			A.description as 描述,U.username as 操作人,A.lm_date as 操作时间
			from TMould_InOutReord A
			left join TMouldInfo M on A.mould_code=M.code
			left join TSecStck S on A.warehouse_code=S.code
			left join TSecLoca L on A.location_code=L.code
			left join TUser U on A.lm_user=U.usercode
			where 1=1 " + search;
			DataTable data = DapperHelper.selectdata(sql, dynamicParams);
			data.TableName = "Table"; //设置DataTable的名称
			string msg = DownLoad.DataTableToExcel(data, "模具出入库记录报表");
			mes.code = "200";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = msg;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;