DDMesApi.git - Gitblit

			@@ -57,14 +57,13 @@
			flwtype = data.Rows[0]["FLWTYPE"].ToString();//获取工序属性
			isbott = data.Rows[0]["ISBOTT"].ToString();//首道工序
			isend = data.Rows[0]["ISEND"].ToString();//末道工序
			seq = data.Rows[0]["SEQ"].ToString();//工序序号
			rt.seq = data.Rows[0]["SEQ"].ToString();//工序序号

			//获取当前工序下道工序
			sql = @"select A.isbott,A.isend,T.stepcode,T.stepname from TK_Wrk_Step A
			left join TStep T on A.step_code=T.stepcode
			where A.wo_code=ordercode and A.step_code=@stepcode and A.seq=@seq+1 ";
			where A.wo_code=@ordercode and A.seq=@seq+1 ";
			dynamicParams.Add("@ordercode", ordercode);
			dynamicParams.Add("@stepcode", stepcode);
			dynamicParams.Add("@seq", decimal.Parse(data.Rows[0]["SEQ"].ToString()));
			var dt = DapperHelper.selectdata(sql, dynamicParams);
			if (dt.Rows.Count > 0) //有下道工序
			@@ -158,9 +157,8 @@
			sql = @"select A.step_code,S.stepname,S.flwtype from TFlw_Rtdt A
			left join TK_Wrk_Man M on A.rout_code=M.route_code
			left join TStep S on A.step_code=S.stepcode
			where M.wo_code=@wocode and A.step_code=@stepcode and A.seq=@seq-1";
			where M.wo_code=@wocode and A.seq=@seq-1";
			dynamicParams.Add("@wocode", data.Rows[0]["WO_CODE"].ToString());
			dynamicParams.Add("@stepcode", data.Rows[0]["STEPCODE"].ToString());
			dynamicParams.Add("@seq", decimal.Parse(data.Rows[0]["SEQ"].ToString()));
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			if (data0.Rows.Count > 0)
			@@ -179,12 +177,12 @@
			var data2 = DapperHelper.selectdata(sql, dynamicParams);
			if (data2.Rows.Count > 0) //有报工记录
			{
			if (data1.Rows[0]["FLWTYPE"].ToString() == "Z") //自制工序
			if (data0.Rows[0]["FLWTYPE"].ToString() == "Z") //自制工序
			{
			//查找上到工序报工记录
			sql = @"select * from TK_Wrk_Record where wo_code=@ordercode and step_code=@stepcode and style='B'";
			dynamicParams.Add("@ordercode", ordercode);
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEPNAME"].ToString());
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEP_CODE"].ToString());
			var data3 = DapperHelper.selectdata(sql, dynamicParams);
			if (data3.Rows.Count > 0) //上道有报工
			{
			@@ -221,16 +219,16 @@
			return mes;
			}
			}
			if (data1.Rows[0]["FLWTYPE"].ToString() == "W") //委外工序
			if (data0.Rows[0]["FLWTYPE"].ToString() == "W") //委外工序
			{
			//查找上到工序收料记录
			sql = @"select * from TK_Wrk_OutRecord where wo_code=@ordercode and step_code=@stepcode and style='S'";
			dynamicParams.Add("@ordercode", ordercode);
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEPNAME"].ToString());
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEP_CODE"].ToString());
			var data3 = DapperHelper.selectdata(sql, dynamicParams);
			if (data3.Rows.Count > 0) //上道有收料
			{
			decimal sqty = decimal.Parse(data3.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("SQTY"))).Sum().ToString());//上道收料数量
			decimal sqty = data3.AsEnumerable().Select(d => d.Field<decimal>("SQTY")).Sum(); //上道收料数量
			string good_qty = data2.Rows[0]["GOOD_QTY"].ToString();//本道报工数量
			string ng_qty = data2.Rows[0]["NG_QTY"].ToString();// 本道不良数量
			decimal sybqty = sqty - decimal.Parse(good_qty) - decimal.Parse(ng_qty);//本道剩余可报数量=上道收料数量-本道报工数量-本道不良数量
			@@ -266,12 +264,12 @@
			}
			else //本道无报工记录
			{
			if (data1.Rows[0]["FLWTYPE"].ToString() == "Z") //自制工序
			if (data0.Rows[0]["FLWTYPE"].ToString() == "Z") //自制工序
			{
			//查找上到工序报工记录
			sql = @"select * from TK_Wrk_Record where wo_code=@ordercode and step_code=@stepcode and style='B'";
			dynamicParams.Add("@ordercode", ordercode);
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEPNAME"].ToString());
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEP_CODE"].ToString());
			var data3 = DapperHelper.selectdata(sql, dynamicParams);
			if (data3.Rows.Count > 0) //上道有报工
			{
			@@ -296,16 +294,16 @@
			return mes;
			}
			}
			if (data1.Rows[0]["FLWTYPE"].ToString() == "W") //委外工序
			if (data0.Rows[0]["FLWTYPE"].ToString() == "W") //委外工序
			{
			//查找上到工序收料记录
			sql = @"select * from TK_Wrk_OutRecord where wo_code=@ordercode and step_code=@stepcode and style='S'";
			dynamicParams.Add("@ordercode", ordercode);
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEPNAME"].ToString());
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEP_CODE"].ToString());
			var data3 = DapperHelper.selectdata(sql, dynamicParams);
			if (data3.Rows.Count > 0) //上道有收料
			{
			decimal sqty = decimal.Parse(data3.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("SQTY"))).Sum().ToString());//上道收料数量
			decimal sqty = data3.AsEnumerable().Select(d =>d.Field<decimal>("SQTY")).Sum();//上道收料数量
			decimal sybqty = sqty; //本道剩余可报数量=上道收料数量

			rt.planqty = decimal.Parse(data.Rows[0]["PLAN_QTY"].ToString()); //任务数量
			@@ -330,12 +328,12 @@
			}
			else //无开工记录
			{
			if (data1.Rows[0]["FLWTYPE"].ToString() == "Z") //自制工序
			if (data0.Rows[0]["FLWTYPE"].ToString() == "Z") //自制工序
			{
			//查找上到工序报工记录
			sql = @"select * from TK_Wrk_Record where wo_code=@ordercode and step_code=@stepcode and style='B'";
			dynamicParams.Add("@ordercode", ordercode);
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEPNAME"].ToString());
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEP_CODE"].ToString());
			var data2 = DapperHelper.selectdata(sql, dynamicParams);
			if (data2.Rows.Count > 0) //上到工序有报工
			{
			@@ -360,17 +358,17 @@
			return mes;
			}
			}
			if (data1.Rows[0]["FLWTYPE"].ToString() == "W") //委外工序
			if (data0.Rows[0]["FLWTYPE"].ToString() == "W") //委外工序
			{
			//查找上道工序外协收料记录
			sql = @"select * from TK_Wrk_OutRecord where wo_code=@ordercode and step_code=@stepcode and style='S'";
			dynamicParams.Add("@ordercode", ordercode);
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEPNAME"].ToString());
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEP_CODE"].ToString());
			var data2 = DapperHelper.selectdata(sql, dynamicParams);
			if (data2.Rows.Count > 0) //上道工序有收料
			{
			decimal sqty = decimal.Parse(data2.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("SQTY"))).Sum().ToString());//收料数量
			decimal ng_qty = decimal.Parse(data2.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("NG_QTY"))).Sum().ToString());// 不良数量
			decimal sqty = data2.AsEnumerable().Select(d => d.Field<decimal>("SQTY")).Sum();//收料数量
			decimal ng_qty = data2.AsEnumerable().Select(d => d.Field<decimal>("NG_QTY")).Sum();// 不良数量

			rt.planqty = decimal.Parse(data.Rows[0]["PLAN_QTY"].ToString()); //任务数量
			rt.startqty = sqty; //开工数量=(上一道的收料数量)
			@@ -471,14 +469,13 @@
			flwtype = data.Rows[0]["FLWTYPE"].ToString();//获取工序属性
			isbott = data.Rows[0]["ISBOTT"].ToString();//首道工序
			isend = data.Rows[0]["ISEND"].ToString();//末道工序
			seq = data.Rows[0]["SEQ"].ToString();//工序序号
			rt.seq = data.Rows[0]["SEQ"].ToString();//工序序号

			//获取当前工序下道工序
			sql = @"select A.isbott,A.isend,T.stepcode,T.stepname from TK_Wrk_Step A
			left join TStep T on A.step_code=T.stepcode
			where A.wo_code=ordercode and A.step_code=@stepcode and A.seq=@seq+1 ";
			where A.wo_code=@ordercode and A.seq=@seq+1 ";
			dynamicParams.Add("@ordercode", ordercode);
			dynamicParams.Add("@stepcode", stepcode);
			dynamicParams.Add("@seq", decimal.Parse(data.Rows[0]["SEQ"].ToString()));
			var dt = DapperHelper.selectdata(sql, dynamicParams);
			if (dt.Rows.Count > 0) //有下道工序
			@@ -496,7 +493,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "未找到当前工序的上道工序信息,请联系管理员核实!";
			mes.Message = "当前扫码工序任务不存在!";
			mes.data = null;
			return mes;
			}
			@@ -521,8 +518,8 @@
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			if (data0.Rows.Count > 0) //有发料记录
			{
			decimal fqty = decimal.Parse(data0.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("FQTY"))).Sum().ToString());//发料数量
			decimal ng_qty = decimal.Parse(data0.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("NG_QTY"))).Sum().ToString());// 不良数量
			decimal fqty = data0.AsEnumerable().Select(d => d.Field<decimal>("FQTY")).Sum(); //发料数量
			decimal ng_qty =data0.AsEnumerable().Select(d => d.Field<decimal>("NG_QTY")).Sum();// 不良数量
			decimal kfqty = decimal.Parse(data.Rows[0]["PLAN_QTY"].ToString()) - fqty - ng_qty; //剩余可发数量
			if (kfqty <= 0)
			{
			@@ -562,9 +559,8 @@
			sql = @"select A.step_code,S.stepname,S.flwtype from TFlw_Rtdt A
			left join TK_Wrk_Man M on A.rout_code=M.route_code
			left join TStep S on A.step_code=S.stepcode
			where M.wo_code=@wocode and A.step_code=@stepcode and A.seq=@seq-1";
			where M.wo_code=@wocode and A.seq=@seq-1";
			dynamicParams.Add("@wocode", data.Rows[0]["WO_CODE"].ToString());
			dynamicParams.Add("@stepcode", data.Rows[0]["STEPCODE"].ToString());
			dynamicParams.Add("@seq", decimal.Parse(data.Rows[0]["SEQ"].ToString()));
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			if (data0.Rows.Count > 0)
			@@ -581,13 +577,13 @@
			//查找上到工序报工记录
			sql = @"select * from TK_Wrk_Record where wo_code=@ordercode and step_code=@stepcode and style='B'";
			dynamicParams.Add("@ordercode", ordercode);
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEPNAME"].ToString());
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEP_CODE"].ToString());
			var data3 = DapperHelper.selectdata(sql, dynamicParams);
			if (data3.Rows.Count > 0) //上道有报工
			{
			string sgood_qty = data3.Rows[0]["GOOD_QTY"].ToString();//上道报工数量
			decimal sqty = decimal.Parse(data1.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("FQTY"))).Sum().ToString());//本道发料数量
			decimal ng_qty = decimal.Parse(data1.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("NG_QTY"))).Sum().ToString());// 本道不良数量
			decimal sqty = data1.AsEnumerable().Select(d => d.Field<decimal>("FQTY")).Sum();//本道发料数量
			decimal ng_qty = data1.AsEnumerable().Select(d => d.Field<decimal>("NG_QTY")).Sum();// 本道不良数量

			decimal sybqty = decimal.Parse(sgood_qty) - sqty - ng_qty;//本道剩余可发数量=上道报工数量-本道发料数量-本道不良数量
			if (sybqty <= 0)
			@@ -625,13 +621,13 @@
			//查找上到工序收料记录
			sql = @"select * from TK_Wrk_OutRecord where wo_code=@ordercode and step_code=@stepcode and style='S'";
			dynamicParams.Add("@ordercode", ordercode);
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEPNAME"].ToString());
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEP_CODE"].ToString());
			var data3 = DapperHelper.selectdata(sql, dynamicParams);
			if (data3.Rows.Count > 0) //上道有收料
			{
			decimal ssqty = decimal.Parse(data3.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("SQTY"))).Sum().ToString());//上道收料数量
			decimal sqty = decimal.Parse(data1.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("FQTY"))).Sum().ToString());//本道发料数量
			decimal ng_qty = decimal.Parse(data1.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("NG_QTY"))).Sum().ToString());// 本道不良数量
			decimal ssqty = data3.AsEnumerable().Select(d => d.Field<decimal>("SQTY")).Sum();//上道收料数量
			decimal sqty = data1.AsEnumerable().Select(d => d.Field<decimal>("FQTY")).Sum();//本道发料数量
			decimal ng_qty = data1.AsEnumerable().Select(d => d.Field<decimal>("NG_QTY")).Sum();// 本道不良数量

			decimal sybqty = ssqty - sqty - ng_qty;//本道剩余可发数量=上道收料数量-本道发料数量-本道不良数量
			if (sybqty <= 0)
			@@ -672,7 +668,7 @@
			//查找上到工序报工记录
			sql = @"select * from TK_Wrk_Record where wo_code=@ordercode and step_code=@stepcode and style='B'";
			dynamicParams.Add("@ordercode", ordercode);
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEPNAME"].ToString());
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEP_CODE"].ToString());
			var data3 = DapperHelper.selectdata(sql, dynamicParams);
			if (data3.Rows.Count > 0) //上道有报工
			{
			@@ -705,11 +701,11 @@
			//查找上到工序收料记录
			sql = @"select * from TK_Wrk_OutRecord where wo_code=@ordercode and step_code=@stepcode and style='S'";
			dynamicParams.Add("@ordercode", ordercode);
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEPNAME"].ToString());
			dynamicParams.Add("@stepcode", data0.Rows[0]["STEP_CODE"].ToString());
			var data3 = DapperHelper.selectdata(sql, dynamicParams);
			if (data3.Rows.Count > 0) //上道有收料
			{
			decimal ssqty = decimal.Parse(data3.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("SQTY"))).Sum().ToString());//上道收料数量
			decimal ssqty = data3.AsEnumerable().Select(d => d.Field<decimal>("SQTY")).Sum();//上道收料数量

			decimal sybqty = ssqty;//本道剩余可发数量=上道收料数量
			if (sybqty <= 0)
			@@ -784,10 +780,10 @@
			var data1 = DapperHelper.selectdata(sql, dynamicParams);
			if (data1.Rows.Count > 0) //有收料记录
			{
			decimal fqty = decimal.Parse(data0.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("FQTY"))).Sum().ToString());//本道发料数量
			decimal sqty = decimal.Parse(data1.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("SQTY"))).Sum().ToString());//本道收料数量
			decimal ng_qty = decimal.Parse(data1.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("NG_QTY"))).Sum().ToString());//本道不良数量
			decimal ksqty = fqty - sqty - ng_qty; //剩余可发数量=本道发料数量-本道收料数量-本道不良数量
			decimal fqty = data0.AsEnumerable().Select(d => d.Field<decimal>("FQTY")).Sum();//本道发料数量
			decimal sqty = data1.AsEnumerable().Select(d => d.Field<decimal>("SQTY")).Sum();//本道收料数量
			decimal ng_qty = data1.AsEnumerable().Select(d => d.Field<decimal>("NG_QTY")).Sum();//本道不良数量
			decimal ksqty = fqty - sqty - ng_qty; //剩余可发数量=本道发料数量-本道收料数量-本道不良数量
			if (ksqty <= 0)
			{
			mes.code = "300";
			@@ -812,7 +808,7 @@
			}
			else
			{
			decimal fqty = decimal.Parse(data0.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("FQTY"))).Sum().ToString());//本道发料数量
			decimal fqty = data0.AsEnumerable().Select(d => d.Field<decimal>("FQTY")).Sum();//本道发料数量

			rt.planqty = decimal.Parse(data.Rows[0]["PLAN_QTY"].ToString()); //任务数量
			rt.noreportqty = fqty; //未收数量=本道发料数量
			@@ -840,9 +836,8 @@
			sql = @"select A.step_code,S.stepname,S.flwtype from TFlw_Rtdt A
			left join TK_Wrk_Man M on A.rout_code=M.route_code
			left join TStep S on A.step_code=S.stepcode
			where M.wo_code=@wocode and A.step_code=@stepcode and A.seq=@seq-1";
			where M.wo_code=@wocode and A.seq=@seq-1";
			dynamicParams.Add("@wocode", data.Rows[0]["WO_CODE"].ToString());
			dynamicParams.Add("@stepcode", data.Rows[0]["STEPCODE"].ToString());
			dynamicParams.Add("@seq", decimal.Parse(data.Rows[0]["SEQ"].ToString()));
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			if (data0.Rows.Count > 0)
			@@ -861,10 +856,10 @@
			var data2 = DapperHelper.selectdata(sql, dynamicParams);
			if (data2.Rows.Count > 0) //有收料记录
			{
			decimal fqty = decimal.Parse(data1.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("FQTY"))).Sum().ToString());//本道发料数量
			decimal sqty = decimal.Parse(data2.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("SQTY"))).Sum().ToString());//本道收料数量
			decimal ng_qty = decimal.Parse(data2.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("NG_QTY"))).Sum().ToString());//本道不良数量
			decimal ksqty = fqty - sqty - ng_qty; //剩余可发数量=本道发料数量-本道收料数量-本道不良数量
			decimal fqty = data1.AsEnumerable().Select(d => d.Field<decimal>("FQTY")).Sum();//本道发料数量
			decimal sqty = data2.AsEnumerable().Select(d => d.Field<decimal>("SQTY")).Sum();//本道收料数量
			decimal ng_qty = data2.AsEnumerable().Select(d => d.Field<decimal>("NG_QTY")).Sum();//本道不良数量
			decimal ksqty = fqty - sqty - ng_qty; //剩余可发数量=本道发料数量-本道收料数量-本道不良数量
			if (ksqty <= 0)
			{
			mes.code = "300";
			@@ -888,7 +883,7 @@
			}
			else
			{
			decimal fqty = decimal.Parse(data1.AsEnumerable().Select(d => Convert.ToDouble(d.Field<Int32>("FQTY"))).Sum().ToString());//本道发料数量
			decimal fqty = data1.AsEnumerable().Select(d => d.Field<Int32>("FQTY")).Sum();//本道发料数量

			rt.planqty = decimal.Parse(data.Rows[0]["PLAN_QTY"].ToString()); //任务数量
			rt.noreportqty = fqty; //未收数量=本道发料数量