JLApi.git - Gitblit

			@@ -34,7 +34,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -42,408 +42,7 @@
			#endregion


			#region[ERP订单查询]
			public static ToMessage ErpOrderSearch(string stu_torgcode, string stu_torgtypecode, string erporderstus, string erpordercode, string partcode, string partname, string partspec, int startNum, string paydatestartdate, string paydateenddate, string paydatestartdate1, string paydateenddate2, string creatuser, int endNum, string prop, string order)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			try
			{
			switch (stu_torgtypecode)
			{
			case "":
			break;
			case "D":
			search += "and L.org_code=@stu_torgcode ";
			dynamicParams.Add("@stu_torgcode", stu_torgcode);
			break;
			case "W":
			search += "and C.org_code=@stu_torgcode ";
			dynamicParams.Add("@stu_torgcode", stu_torgcode);
			break;
			default:
			break;
			}
			if (erporderstus != "" && erporderstus != null)
			{
			search += "and A.status=@erporderstus ";
			dynamicParams.Add("@erporderstus", erporderstus);
			}
			if (erpordercode != "" && erpordercode != null)
			{
			search += "and A.wo like '%'+@erpordercode+'%' ";
			dynamicParams.Add("@erpordercode", erpordercode);
			}
			if (partcode != "" && partcode != null)
			{
			search += "and A.materiel_code like '%'+@partcode+'%' ";
			dynamicParams.Add("@partcode", partcode);
			}
			if (partname != "" && partname != null)
			{
			search += "and B.partname like '%'+@partname+'%' ";
			dynamicParams.Add("@partname", partname);
			}
			if (partspec != "" && partspec != null)
			{
			search += "and B.partspec like '%'+@partspec+'%' ";
			dynamicParams.Add("@partspec", partspec);
			}
			if (paydatestartdate != "" && paydatestartdate != null)
			{
			search += "and A.planstartdate between @paydatestartdate and @paydateenddate ";
			dynamicParams.Add("@paydatestartdate", paydatestartdate + " 00:00:00");
			dynamicParams.Add("@paydateenddate", paydateenddate + " 23:59:59");
			}
			if (paydatestartdate1 != "" && paydatestartdate1 != null)
			{
			search += "and A.planenddate between @paydatestartdate1 and @paydateenddate2 ";
			dynamicParams.Add("@paydatestartdate1", paydatestartdate1);
			dynamicParams.Add("@paydateenddate2", paydateenddate2 + " 23:59:59");
			}
			if (creatuser != "" && creatuser != null)
			{
			search += "and U.username like '%'+@creatuser+'%' ";
			dynamicParams.Add("@creatuser", creatuser);
			}

			if (search == "")
			{
			search = "and 1=1 ";
			}
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select A.id, A.status,A.wo,A.materiel_code as partcode,B.partname,B.partspec,A.qty,A.relse_qty,A.wkshp_code,C.org_name as wkshp_name,
			A.stck_code,D.name as stck_name,saleOrderDeliveryDate,A.planstartdate,A.planenddate,U.username as createuser,A.createdate
			from TKimp_Ewo A
			left join TMateriel_Info B on A.materiel_code=B.partcode
			left join TOrganization C on A.wkshp_code=C.org_code
			left join T_Sec_Stck D on A.stck_code=D.code
			left join TUser U on A.createuser=U.usercode
			left join TOrganization L on C.parent_id=L.id
			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[ERP订单下达]
			public static ToMessage MarkSaveErpOrder(string erporderid, string erpordercode, string partcode, string wkshopcode, string warehousecode, string erpqty, string markqty, string ordernum, string relse_qty, string saleOrderDeliveryDate, string username)
			{
			var sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();

			try
			{
			list.Clear();
			//获取拆单数量:向下取整
			decimal cdqty = Math.Floor(decimal.Parse(markqty) / decimal.Parse(ordernum));
			//定义累计下单数量
			decimal sumqty = 0;
			//定义最新生成的工单号
			string wo = "";
			//定义工单流水号
			int num = 0;
			//循环下单单数(生成对应几张MES工单)
			for (int i = 1; i <= Convert.ToInt32(ordernum); i++)
			{
			sumqty += cdqty;
			//获取最大单据号
			if (i == 1) //首单获取工单号
			{
			sql = @"select isnull(max(cast(substring(wo_code,charindex('_',wo_code)+1,len(wo_code)-charindex('_',wo_code)) as numeric)),0)+1 as worknumb
			from TK_Wrk_Man where m_po=@erpordercode";
			dynamicParams.Add("@erpordercode", erpordercode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			num = Convert.ToInt32(data.Rows[0]["WORKNUMB"].ToString());
			wo = erpordercode + "_" + num;
			}
			else
			{
			num = num + 1;
			wo = erpordercode + "_" + num;
			}
			if (i == Convert.ToInt32(ordernum)) //最后一单时
			{
			sql = @"insert into TK_Wrk_Man(wo_code,wotype,status,wkshp_code,plan_qty,stck_code,materiel_code,sourceid,m_po,lm_user,lm_date,saleOrderDeliveryDate) values(@wo_code,@wotype,@status,@wkshp_code,@plan_qty,@stck_code,@materiel_code,@sourceid,@m_po,@username,@CreateDate,@saleOrderDeliveryDate)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			wo_code = wo,
			wotype = "PO",
			status = "NEW",
			wkshp_code = wkshopcode,
			plan_qty = cdqty + (decimal.Parse(markqty) - sumqty), //末单下单数量=切分数量+(下单数量-累计切分下单数量)
			stck_code = warehousecode,
			materiel_code = partcode,
			sourceid = erporderid,
			m_po = erpordercode,
			username = username,
			CreateDate = DateTime.Now.ToString(),
			saleOrderDeliveryDate = Convert.ToDateTime(saleOrderDeliveryDate)
			}
			});
			sumqty = sumqty + (decimal.Parse(markqty) - sumqty);
			}
			else
			{

			sql = @"insert into TK_Wrk_Man(wo_code,wotype,status,wkshp_code,plan_qty,stck_code,materiel_code,sourceid,m_po,lm_user,lm_date,saleOrderDeliveryDate) values(@wo_code,@wotype,@status,@wkshp_code,@plan_qty,@stck_code,@materiel_code,@sourceid,@m_po,@username,@CreateDate,@saleOrderDeliveryDate)";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			wo_code = wo,
			wotype = "PO",
			status = "NEW",
			wkshp_code = wkshopcode,
			plan_qty = cdqty,
			stck_code = warehousecode,
			materiel_code = partcode,
			sourceid = erporderid,
			m_po = erpordercode,
			username = username,
			CreateDate = DateTime.Now.ToString(),
			saleOrderDeliveryDate = Convert.ToDateTime(saleOrderDeliveryDate)
			}
			});
			}
			}
			if (decimal.Parse(erpqty) == decimal.Parse(markqty) + decimal.Parse(relse_qty)) //如果ERP订单=下单数量+已下单数量,则更新ERP订单表状态为CREATED:已创建
			{
			sql = @"update TKimp_Ewo set status='CREATED',saleOrderDeliveryDate=@saleOrderDeliveryDate,relse_qty=relse_qty+@sumqty where wo=@wo and id=@erporderid";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			wo = erpordercode,
			erporderid = erporderid,
			sumqty = sumqty,
			saleOrderDeliveryDate = Convert.ToDateTime(saleOrderDeliveryDate)
			}
			});
			}
			else //更新ERP订单表状态为CREATING:创建中
			{
			sql = @"update TKimp_Ewo set status='CREATING',saleOrderDeliveryDate=@saleOrderDeliveryDate,relse_qty=relse_qty+@sumqty where wo=@wo and id=@erporderid";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			wo = erpordercode,
			erporderid = erporderid,
			sumqty = sumqty,
			saleOrderDeliveryDate = Convert.ToDateTime(saleOrderDeliveryDate)
			}
			});
			}
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "下达MES工单成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "下达MES工单成功失败!";
			mes.data = null;
			}
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[ERP订单关闭]
			public static ToMessage ClosedErpOrder(string erporderid, string erpordercode, string username)
			{
			var sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			sql = @"select * from TK_Wrk_Man where m_po=@erpordercode and status<> 'CLOSED'";
			dynamicParams.Add("@erpordercode", erpordercode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前订单有下达未关闭的MES工单,订单不允许关闭,请先删除或关闭相关工单!";
			mes.data = null;
			}
			else
			{
			//关闭订单
			sql = @"update TKimp_Ewo set status='CLOSED' where wo=@wo and id=@erporderid";
			list.Add(new
			{
			str = sql,
			parm = new
			{
			wo = erpordercode,
			erporderid = erporderid
			}
			});
			}
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			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[MES工单查询]
			public static ToMessage MesOrderSearch(string stu_torgcode, string stu_torgtypecode, string mesorderstus, string mesordercode, string sourceorder, string ordertype, string partcode, string partname, string partspec, int startNum, string creatuser, string createdate, int endNum, string prop, string order)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			try
			{
			switch (stu_torgtypecode)
			{
			case "":
			break;
			case "D":
			search += "and L.org_code=@stu_torgcode ";
			dynamicParams.Add("@stu_torgcode", stu_torgcode);
			break;
			case "W":
			search += "and C.org_code=@stu_torgcode ";
			dynamicParams.Add("@stu_torgcode", stu_torgcode);
			break;
			default:
			break;
			}
			if (mesorderstus != "" && mesorderstus != null)
			{
			search += "and A.status=@mesorderstus ";
			dynamicParams.Add("@mesorderstus", mesorderstus);
			}
			if (mesordercode != "" && mesordercode != null)
			{
			search += "and A.wo_code like '%'+@mesordercode+'%' ";
			dynamicParams.Add("@mesordercode", mesordercode);
			}
			if (sourceorder != "" && sourceorder != null)
			{
			search += "and A.m_po like '%'+@sourceorder+'%' ";
			dynamicParams.Add("@sourceorder", sourceorder);
			}
			if (ordertype != "" && ordertype != null)
			{
			search += "and A.wotype like '%'+@ordertype+'%' ";
			dynamicParams.Add("@ordertype", ordertype);
			}
			if (partcode != "" && partcode != null)
			{
			search += "and A.materiel_code like '%'+@partcode+'%' ";
			dynamicParams.Add("@partcode", partcode);
			}
			if (partname != "" && partname != null)
			{
			search += "and B.partname like '%'+@partname+'%' ";
			dynamicParams.Add("@partname", partname);
			}
			if (partspec != "" && partspec != null)
			{
			search += "and B.partspec like '%'+@partspec+'%' ";
			dynamicParams.Add("@partspec", partspec);
			}
			if (createdate != "" && createdate != null)
			{
			search += "and CONVERT(varchar(100),A.lm_date,23)=@createdate ";
			dynamicParams.Add("@createdate", createdate);
			}
			if (creatuser != "" && creatuser != null)
			{
			search += "and U.username like '%'+@creatuser+'%' ";
			dynamicParams.Add("@creatuser", creatuser);
			}

			if (search == "")
			{
			search = "and 1=1 ";
			}
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select A.id, A.status,A.wotype,A.wo_code,A.materiel_code as partcode,B.partname,B.partspec,A.plan_qty,A.wkshp_code,C.org_name as wkshp_name,
			A.route_code,E.name as route_name,A.stck_code,F.name as stck_name,A.plan_startdate,A.plan_enddate,A.piroque,A.sourceid,A.m_po,U.username as lm_user,A.lm_date
			from TK_Wrk_Man A
			left join TMateriel_Info B on A.materiel_code=B.partcode
			left join TOrganization C on A.wkshp_code=C.org_code
			left join T_Sec_Stck D on A.stck_code=D.code
			left join TFlw_Rout E on A.route_code=E.code
			left join T_Sec_Stck F on A.stck_code=F.code
			left join TUser U on A.lm_user=U.usercode
			left join TOrganization L on C.parent_id=L.id
			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[MES报废补单工单查询]
			public static ToMessage MesBadOrderSearch(string mesordercode, string sourceorder, string partcode, string partname, string partspec, int startNum, string creatuser, string createdate, int endNum, string prop, string order)
			@@ -507,7 +106,7 @@
			where A.is_delete<>'1' and A.status='START' and A.wotype='PO' and S.bad_qty>0 " + 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();
			}
			@@ -515,7 +114,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -538,14 +137,14 @@
			dynamicParams.Add("@torg_code", wkshopcode);
			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;
			@@ -587,14 +186,14 @@
			dynamicParams.Add("@partcode", partcode);
			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;
			@@ -615,14 +214,14 @@
			dynamicParams.Add("@partcode", routecode);
			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;
			@@ -640,14 +239,14 @@
			dynamicParams.Add("@partnumber", partnumber);
			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;
			@@ -662,7 +261,7 @@
			try
			{
			mes.code = "200";
			mes.Message = "";
			mes.message = "";
			mes.data = null;
			//判断工艺路线对应工序是否都有关联工作站
			sql = @"select B.step_code,C.eqp_code from TFlw_Rout A
			@@ -678,7 +277,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工艺路线对应工序【" + dtck.Rows[i]["step_code"].ToString() + "】，未关联设备，请关联所有工序对应设备!";
			mes.message = "当前工艺路线对应工序【" + dtck.Rows[i]["step_code"].ToString() + "】，未关联设备，请关联所有工序对应设备!";
			mes.data = null;
			return mes;
			}
			@@ -705,7 +304,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工艺路线对应工序【" + dtck.Rows[i]["step_code"].ToString() + "】，设备不可用!";
			mes.message = "当前工艺路线对应工序【" + dtck.Rows[i]["step_code"].ToString() + "】，设备不可用!";
			mes.data = null;
			return mes;
			}
			@@ -732,7 +331,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "节拍工价中：当前产品【" + partcode + "】，对应工艺路线【" + routecode + "】未设置(或未设置全)或工价小于等于0!";
			mes.message = "节拍工价中：当前产品【" + partcode + "】，对应工艺路线【" + routecode + "】未设置(或未设置全)或工价小于等于0!";
			mes.data = null;
			return mes;
			}
			@@ -743,7 +342,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -763,14 +362,14 @@
			FROM TK_Wrk_Man where wo_code like '%SGPO%'";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data.Rows[0]["numct"].ToString();
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -795,7 +394,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "工单对应工艺路线没有绑定工序!";
			mes.message = "工单对应工艺路线没有绑定工序!";
			mes.data = null;
			return mes;
			}
			@@ -813,7 +412,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "工单对应的产品没有建立BOM或BOM未审核！";
			mes.message = "工单对应的产品没有建立BOM或BOM未审核！";
			mes.data = null;
			return mes;
			}
			@@ -906,14 +505,14 @@
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "MES工单新建派发成功!";
			mes.message = "MES工单新建派发成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "MES工单新建派发失败!";
			mes.message = "MES工单新建派发失败!";
			mes.data = null;
			}
			}
			@@ -930,7 +529,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "工单对应的产品没有建立BOM或BOM未审核！";
			mes.message = "工单对应的产品没有建立BOM或BOM未审核！";
			mes.data = null;
			return mes;
			}
			@@ -1026,14 +625,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;
			}
			}
			@@ -1042,7 +641,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1100,7 +699,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "工单执行中或已关闭，不允许删除!";
			mes.message = "工单执行中或已关闭，不允许删除!";
			mes.data = null;
			}
			bool aa = DapperHelper.DoTransaction(list);
			@@ -1108,14 +707,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;
			}
			}
			@@ -1123,7 +722,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1149,14 +748,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;
			}
			}
			@@ -1164,7 +763,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1187,14 +786,14 @@
			dynamicParams.Add("@wo_code", wo_code);
			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;
			@@ -1220,7 +819,7 @@
			ordercode = arra[0]; //获取指定字符串前面的字符
			mes.code = "300";
			mes.count = 0;
			mes.Message = "请扫描工序二维码!";
			mes.message = "请扫描工序二维码!";
			mes.data = null;
			return mes;
			}
			@@ -1242,7 +841,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工序任务为外协工序任务,请前往外协操作页签执行!";
			mes.message = "当前工序任务为外协工序任务,请前往外协操作页签执行!";
			mes.data = null;
			return mes;
			}
			@@ -1261,7 +860,7 @@
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			return mes;
			}
			@@ -1269,7 +868,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工序任务无可执行设备!";
			mes.message = "当前工序任务无可执行设备!";
			mes.data = null;
			return mes;
			}
			@@ -1278,7 +877,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1303,7 +902,7 @@
			ordercode = arra[0]; //获取指定字符串前面的字符
			mes.code = "300";
			mes.count = 0;
			mes.Message = "请扫描工序二维码!";
			mes.message = "请扫描工序二维码!";
			mes.data = null;
			return mes;
			}
			@@ -1325,7 +924,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工序任务为自制工序任务,请前往自制操作页签执行!";
			mes.message = "当前工序任务为自制工序任务,请前往自制操作页签执行!";
			mes.data = null;
			return mes;
			}
			@@ -1344,7 +943,7 @@
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data;
			return mes;
			}
			@@ -1352,7 +951,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工序无可执行外协供方!";
			mes.message = "当前工序无可执行外协供方!";
			mes.data = null;
			return mes;
			}
			@@ -1361,7 +960,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1387,7 +986,7 @@
			ordercode = arra[0]; //获取指定字符串前面的字符
			mes.code = "300";
			mes.count = 0;
			mes.Message = "请扫描工序二维码!";
			mes.message = "请扫描工序二维码!";
			mes.data = null;
			return mes;
			}
			@@ -1414,7 +1013,7 @@
			//{
			// mes.code = "300";
			// mes.count = 0;
			// mes.Message = "二维码信息为空!";
			// mes.message = "二维码信息为空!";
			// mes.data = null;
			// return mes;
			//}
			@@ -1430,7 +1029,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工序任务为外协工序任务,请前往外协操作页签执行!";
			mes.message = "当前工序任务为外协工序任务,请前往外协操作页签执行!";
			mes.data = null;
			return mes;
			}
			@@ -1466,7 +1065,7 @@
			{
			mes.code = "200";
			mes.count = total;
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data.ToList();
			return mes;
			}
			@@ -1474,7 +1073,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "无可执行的生产任务,任务已完成或已关闭!";
			mes.message = "无可执行的生产任务,任务已完成或已关闭!";
			mes.data = null;
			return mes;
			}
			@@ -1483,7 +1082,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1509,7 +1108,7 @@
			ordercode = arra[0]; //获取指定字符串前面的字符
			mes.code = "300";
			mes.count = 0;
			mes.Message = "请扫描工序二维码!";
			mes.message = "请扫描工序二维码!";
			mes.data = null;
			return mes;
			}
			@@ -1535,7 +1134,7 @@
			//{
			// mes.code = "300";
			// mes.count = 0;
			// mes.Message = "二维码信息为空!";
			// mes.message = "二维码信息为空!";
			// mes.data = null;
			// return mes;
			//}
			@@ -1551,7 +1150,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工序任务为自制工序任务,请前往自制操作页签执行!";
			mes.message = "当前工序任务为自制工序任务,请前往自制操作页签执行!";
			mes.data = null;
			return mes;
			}
			@@ -1587,7 +1186,7 @@
			{
			mes.code = "200";
			mes.count = total;
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data.ToList();
			return mes;
			}
			@@ -1595,7 +1194,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "无可执行的生产任务,任务已完成或已关闭!";
			mes.message = "无可执行的生产任务,任务已完成或已关闭!";
			mes.data = null;
			return mes;
			}
			@@ -1604,7 +1203,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1630,7 +1229,7 @@
			ordercode = arra[0]; //获取指定字符串前面的字符
			mes.code = "300";
			mes.count = 0;
			mes.Message = "请扫描工序二维码!";
			mes.message = "请扫描工序二维码!";
			mes.data = null;
			return mes;
			}
			@@ -1663,7 +1262,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工序任务不存在,无效条码!";
			mes.message = "当前工序任务不存在,无效条码!";
			mes.data = null;
			return mes;
			}
			@@ -1698,7 +1297,7 @@
			{
			mes.code = "200";
			mes.count = total;
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = data.ToList();
			return mes;
			}
			@@ -1706,7 +1305,7 @@
			{
			mes.code = "301";
			mes.count = 0;
			mes.Message = "无可执行的生产任务,任务已完成或已关闭!";
			mes.message = "无可执行的生产任务,任务已完成或已关闭!";
			mes.data = null;
			return mes;
			}
			@@ -1715,7 +1314,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1744,7 +1343,7 @@
			ordercode = arra[0]; //获取指定字符串前面的字符
			mes.code = "300";
			mes.count = 0;
			mes.Message = "请扫描工序二维码!";
			mes.message = "请扫描工序二维码!";
			mes.data = null;
			return mes;
			}
			@@ -1801,7 +1400,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前扫码工序任务不存在!";
			mes.message = "当前扫码工序任务不存在!";
			mes.data = null;
			return mes;
			}
			@@ -1817,14 +1416,14 @@
			list.Add("data2", dt);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = list;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "无可执行的生产任务,任务已完成或已关闭!";
			mes.message = "无可执行的生产任务,任务已完成或已关闭!";
			mes.data = null;
			}
			}
			@@ -1832,7 +1431,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1857,7 +1456,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "请扫描工序条码!";
			mes.message = "请扫描工序条码!";
			mes.data = null;
			return mes;
			}
			@@ -1869,10 +1468,10 @@
			switch (OperType)
			{
			case "ZZ":
			mes = ScanStartReport.ZZEncodingSeach(stu_torgcode, ordercode, stepcode);
			mes = ScanStartReport.ZZEncodingSeach(ordercode, stepcode);
			break;
			case "WX":
			mes = ScanStartReport.WXEncodingSeach(stu_torgcode, SelectType, ordercode, stepcode);
			mes = ScanStartReport.WXEncodingSeach(SelectType, ordercode, stepcode);
			break;
			default:
			break;
			@@ -1882,7 +1481,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "二维码信息为空!";
			mes.message = "二维码信息为空!";
			mes.data = null;
			return mes;
			}
			@@ -1891,7 +1490,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1925,7 +1524,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "二维码信息为空!";
			mes.message = "二维码信息为空!";
			mes.data = null;
			return mes;
			}
			@@ -1939,14 +1538,14 @@
			dynamicParams.Add("@stepcode", stepcode);
			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;
			@@ -1987,14 +1586,14 @@
			where 1=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;
			@@ -2014,14 +1613,14 @@
			dynamicParams.Add("@usergroupcode", usergroupcode);
			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;
			@@ -2046,14 +1645,14 @@
			dynamicParams.Add("@usercode", usercode);
			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;
			@@ -2086,7 +1685,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "二维码信息为空!";
			mes.message = "二维码信息为空!";
			mes.data = null;
			return mes;
			}
			@@ -2097,14 +1696,14 @@
			dynamicParams.Add("@stepcode", stepcode);
			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;
			@@ -2137,7 +1736,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "二维码信息为空!";
			mes.message = "二维码信息为空!";
			mes.data = null;
			return mes;
			}
			@@ -2148,14 +1747,14 @@
			dynamicParams.Add("@stepcode", stepcode);
			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;
			@@ -2181,7 +1780,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工序任务已开工!";
			mes.message = "当前工序任务已开工!";
			mes.data = null;
			return mes;
			}
			@@ -2206,14 +1805,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;
			}
			}
			@@ -2221,7 +1820,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2264,7 +1863,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "操作失败,当前报工产线应为：" + da.Rows[0]["NAME"].ToString() + "!";
			mes.message = "操作失败,当前报工产线应为：" + da.Rows[0]["NAME"].ToString() + "!";
			mes.data = null;
			return mes;
			}
			@@ -2406,14 +2005,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;
			}
			}
			@@ -2421,7 +2020,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2483,14 +2082,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;
			}
			}
			@@ -2498,7 +2097,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2549,7 +2148,7 @@
			string wxstring = (string.Join(",", dr.Select(x => x.ToString()).ToArray()));
			mes.code = "300";
			mes.count = 0;
			mes.Message = "操作失败,当前收料外协供方与发料外协供应商不匹配,应为：【" + wxstring + "】!";
			mes.message = "操作失败,当前收料外协供方与发料外协供应商不匹配,应为：【" + wxstring + "】!";
			mes.data = null;
			return mes;
			}
			@@ -2557,7 +2156,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "操作失败,当前收料数量+不良数量,不能大于发料数量:" + da.Rows[0]["FQTY"].ToString() + "!";
			mes.message = "操作失败,当前收料数量+不良数量,不能大于发料数量:" + da.Rows[0]["FQTY"].ToString() + "!";
			mes.data = null;
			return mes;
			}
			@@ -2565,7 +2164,7 @@
			//{
			// mes.code = "300";
			// mes.count = 0;
			// mes.Message = "操作失败,当前收料外协供方应为：" + da.Rows[0]["NAME"].ToString() + "!";
			// mes.message = "操作失败,当前收料外协供方应为：" + da.Rows[0]["NAME"].ToString() + "!";
			// mes.data = null;
			// return mes;
			//}
			@@ -2577,7 +2176,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "操作失败,当前收料数量+不良数量,不能大于待收数量:" + (sum_fqty - sum_sqty) + "!";
			mes.message = "操作失败,当前收料数量+不良数量,不能大于待收数量:" + (sum_fqty - sum_sqty) + "!";
			mes.data = null;
			return mes;
			}
			@@ -2675,14 +2274,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;
			}
			}
			@@ -2690,7 +2289,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2845,14 +2444,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;
			}
			}
			@@ -2860,7 +2459,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -2886,7 +2485,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "请扫描工序条码!";
			mes.message = "请扫描工序条码!";
			mes.data = null;
			return mes;
			}
			@@ -2904,7 +2503,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工单已关闭,不允许检验操作!";
			mes.message = "当前工单已关闭,不允许检验操作!";
			mes.data = null;
			return mes;
			}
			@@ -2918,7 +2517,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "不是本车间生产任务,不允许检验操作!";
			mes.message = "不是本车间生产任务,不允许检验操作!";
			mes.data = null;
			return mes;
			}
			@@ -2953,14 +2552,14 @@
			list.Add("chekstand", data1);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = list;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前产品【" + data.Rows[0]["partname"].ToString() + "】,对应工序【" + data.Rows[0]["stepname"].ToString() + "】，未指定质检方案!";
			mes.message = "当前产品【" + data.Rows[0]["partname"].ToString() + "】,对应工序【" + data.Rows[0]["stepname"].ToString() + "】，未指定质检方案!";
			mes.data = null;
			return mes;
			}
			@@ -2969,7 +2568,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工序任务无报工产出!";
			mes.message = "当前工序任务无报工产出!";
			mes.data = null;
			return mes;
			}
			@@ -2978,7 +2577,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "生产任务不存在!";
			mes.message = "生产任务不存在!";
			mes.data = null;
			return mes;
			}
			@@ -2987,7 +2586,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "二维码信息为空!";
			mes.message = "二维码信息为空!";
			mes.data = null;
			return mes;
			}
			@@ -2996,7 +2595,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3023,14 +2622,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;
			}
			}
			@@ -3038,7 +2637,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3127,14 +2726,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;
			}
			}
			@@ -3142,7 +2741,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3242,7 +2841,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();
			}
			@@ -3250,7 +2849,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3279,14 +2878,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;
			}
			}
			@@ -3294,7 +2893,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3323,14 +2922,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;
			}
			}
			@@ -3338,7 +2937,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3358,14 +2957,14 @@
			from TBas_wkshift_info";
			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;
			@@ -3388,7 +2987,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "编码已存在,不能重复!";
			mes.message = "编码已存在,不能重复!";
			mes.data = null;
			return mes;
			}
			@@ -3400,7 +2999,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "名称已存在,不能重复!";
			mes.message = "名称已存在,不能重复!";
			mes.data = null;
			return mes;
			}
			@@ -3433,14 +3032,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;
			}
			}
			@@ -3448,7 +3047,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3471,7 +3070,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除失败！,该方案已经被产能规划资源引用!";
			mes.message = "删除失败！,该方案已经被产能规划资源引用!";
			mes.data = null;
			return mes;
			}
			@@ -3493,14 +3092,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;
			}
			}
			@@ -3508,7 +3107,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3586,7 +3185,7 @@
			where C.description='W' " + 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();
			}
			@@ -3594,7 +3193,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3623,14 +3222,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;
			}
			}
			@@ -3646,14 +3245,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;
			}
			}
			@@ -3662,7 +3261,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3690,14 +3289,14 @@
			list.Add(cmp);
			}
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = list;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3746,14 +3345,14 @@
			list.Add(cmp);
			}
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = list;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -3773,7 +3372,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "默认方案选择不能为空!";
			mes.message = "默认方案选择不能为空!";
			mes.data = null;
			return mes;
			}
			@@ -3781,7 +3380,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "工作日历选择不能为空!";
			mes.message = "工作日历选择不能为空!";
			mes.data = null;
			return mes;
			}
			@@ -3807,14 +3406,14 @@
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "操作成功!";
			mes.message = "操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "操作失败!";
			mes.message = "操作失败!";
			mes.data = null;
			}

			@@ -3877,7 +3476,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "修改失败！,日期：" + dt4.Rows[g]["TIME_START"] + "有【" + dt4.Rows[g]["STATUS"] + "】工单：" + dt4.Rows[g]["WO_CODE"] + "";
			mes.message = "修改失败！,日期：" + dt4.Rows[g]["TIME_START"] + "有【" + dt4.Rows[g]["STATUS"] + "】工单：" + dt4.Rows[g]["WO_CODE"] + "";
			mes.data = null;
			return mes;
			}
			@@ -3930,14 +3529,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;
			}
			}
			@@ -3946,7 +3545,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -4023,7 +3622,7 @@
			where E.isbott = 'Y' and A.status='NOSCHED' and A.isaps='Y' " + 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();
			}
			@@ -4031,7 +3630,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -4054,7 +3653,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "要求交付时间不能小于当前系统时间！";
			mes.message = "要求交付时间不能小于当前系统时间！";
			mes.data = null;
			return list;
			}
			@@ -4085,7 +3684,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "设备不可用！";
			mes.message = "设备不可用！";
			mes.data = null;
			return list;
			}
			@@ -4094,7 +3693,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "工艺路线未关联设备！";
			mes.message = "工艺路线未关联设备！";
			mes.data = null;
			return list;
			}
			@@ -4128,7 +3727,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "排产设备车间与工单创建的车间不同！";
			mes.message = "排产设备车间与工单创建的车间不同！";
			mes.data = null;
			return list;
			}
			@@ -4146,7 +3745,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "排程设备" + listData[j].eqp_id.ToString() + "稼动率不能为0或为空！";
			mes.message = "排程设备" + listData[j].eqp_id.ToString() + "稼动率不能为0或为空！";
			mes.data = null;
			return list;
			}
			@@ -4154,7 +3753,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "排程设备" + listData[j].eqp_id.ToString() + "未设置节拍！";
			mes.message = "排程设备" + listData[j].eqp_id.ToString() + "未设置节拍！";
			mes.data = null;
			return list;
			}
			@@ -4210,7 +3809,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工单加工产品对应工艺路线设备未设置产能或未设置生产节拍！";
			mes.message = "当前工单加工产品对应工艺路线设备未设置产能或未设置生产节拍！";
			mes.data = null;
			}
			}
			@@ -4220,7 +3819,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "设备没有关联车间！";
			mes.message = "设备没有关联车间！";
			mes.data = null;
			}
			return list;
			@@ -4229,7 +3828,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return list;
			@@ -4295,7 +3894,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "要求交付时间不能小于当前系统时间！";
			mes.message = "要求交付时间不能小于当前系统时间！";
			mes.data = null;
			return list;
			}
			@@ -4326,7 +3925,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "设备不可用！";
			mes.message = "设备不可用！";
			mes.data = null;
			return list;
			}
			@@ -4335,7 +3934,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "工艺路线未关联设备！";
			mes.message = "工艺路线未关联设备！";
			mes.data = null;
			return list;
			}
			@@ -4369,7 +3968,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "排产设备车间与工单创建的车间不同！";
			mes.message = "排产设备车间与工单创建的车间不同！";
			mes.data = null;
			return list;
			}
			@@ -4388,7 +3987,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "排程设备" + listData[j].eqp_id.ToString() + "稼动率不能为0或为空！";
			mes.message = "排程设备" + listData[j].eqp_id.ToString() + "稼动率不能为0或为空！";
			mes.data = null;
			return list;
			}
			@@ -4396,7 +3995,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "排程设备" + listData[j].eqp_id.ToString() + "未设置节拍！";
			mes.message = "排程设备" + listData[j].eqp_id.ToString() + "未设置节拍！";
			mes.data = null;
			return list;
			}
			@@ -4452,7 +4051,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工单加工产品对应工艺路线设备未设置产能或未设置生产节拍！";
			mes.message = "当前工单加工产品对应工艺路线设备未设置产能或未设置生产节拍！";
			mes.data = null;
			}
			}
			@@ -4462,7 +4061,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "设备没有关联车间！";
			mes.message = "设备没有关联车间！";
			mes.data = null;
			}
			}
			@@ -4472,7 +4071,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return list;
			@@ -4551,7 +4150,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前排程任务已经派发,提交取消！";
			mes.message = "当前排程任务已经派发,提交取消！";
			mes.data = null;
			return mes;
			}
			@@ -4559,7 +4158,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前排程任务已经排程,提交取消！";
			mes.message = "当前排程任务已经排程,提交取消！";
			mes.data = null;
			return mes;
			}
			@@ -4590,7 +4189,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "先预排,再点击提交！";
			mes.message = "先预排,再点击提交！";
			mes.data = null;
			return mes;
			}
			@@ -4613,7 +4212,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "生成设备任务汇总表出错，排产失败！";
			mes.message = "生成设备任务汇总表出错，排产失败！";
			mes.data = null;
			return mes;
			}
			@@ -4662,13 +4261,13 @@
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "提交排程成功！";
			mes.message = "提交排程成功！";
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "提交排程失败！";
			mes.message = "提交排程失败！";
			mes.data = null;
			}
			}
			@@ -4676,7 +4275,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -4713,14 +4312,14 @@
			dynamicParams.Add("@ordercode", ordercode);
			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;
			@@ -4770,14 +4369,14 @@
			dynamicParams.Add("@wkshopcode", wkshopcode);
			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;
			@@ -4854,7 +4453,7 @@
			) as AA where AA.good_qty>AA.inhouseqty " + search;
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = data;
			}
			@@ -4862,7 +4461,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -5085,14 +4684,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;
			}

			@@ -5101,7 +4700,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -5133,7 +4732,7 @@
			if (data0.Rows.Count <= 0)
			{
			mes.code = "300";
			mes.Message = "无效条码!";
			mes.message = "无效条码!";
			mes.data = null;
			return mes;
			}
			@@ -5156,7 +4755,7 @@
			if (data1.Rows.Count <= 0)
			{
			mes.code = "300";
			mes.Message = "当前条码已入库!";
			mes.message = "当前条码已入库!";
			mes.data = null;
			return mes;
			}
			@@ -5190,13 +4789,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;
			}
			}
			@@ -5204,7 +4803,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;