JLApi.git - Gitblit

			@@ -51,7 +51,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();
			}
			@@ -59,7 +59,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -100,14 +100,14 @@
			LogHelper.DbOperateLog(us.usercode, "新增", "缺陷编码:" + defectcode + "缺陷名称:" + defectname, 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;
			}
			}
			@@ -133,14 +133,14 @@
			LogHelper.DbOperateLog(us.usercode, "修改", "缺陷编码:" + defectcode + "缺陷名称:" + defectname, 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;
			}
			}
			@@ -149,7 +149,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -171,7 +171,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前缺陷项已生成报工缺陷记录,不允许删除!";
			mes.message = "当前缺陷项已生成报工缺陷记录,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -186,14 +186,14 @@
			LogHelper.DbOperateLog(us.usercode, "删除", "缺陷编码:" + defectcode, 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;
			}
			}
			@@ -201,7 +201,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -239,7 +239,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();
			}
			@@ -247,7 +247,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -286,14 +286,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;
			}
			}
			@@ -319,14 +319,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;
			}
			}
			@@ -335,7 +335,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -357,7 +357,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前检验项项已生成检验记录,不允许删除!";
			mes.message = "当前检验项项已生成检验记录,不允许删除!";
			mes.data = null;
			return mes;
			}
			@@ -372,14 +372,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;
			}
			}
			@@ -387,7 +387,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -449,8 +449,8 @@
			when A.suitobject='PY'
			then
			STUFF(( SELECT ';' + name
			FROM T_Dict
			where PATINDEX('%;' + RTRIM(T_Dict.code) + ';%',';' + A.suitpart + ';')>0
			FROM TMateriel_Class
			where PATINDEX('%;' + RTRIM(TMateriel_Class.code) + ';%',';' + A.suitpart + ';')>0
			FOR XML PATH('')), 1, 1,'')
			end as suitpartname
			from TStepCheckStandard A
			@@ -460,7 +460,7 @@
			where " + 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();
			}
			@@ -468,7 +468,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -491,14 +491,38 @@
			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;
			}
			#endregion

			#region[工序质检方案新增、编辑获取检验项目下拉列表]
			public static ToMessage QualityStepCheckItemSelect()
			{
			string sql = "";
			try
			{
			//获取工序点检项目数据
			sql = @"select code,name,descr from TStepCheckItem";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -579,7 +603,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "修改失败,当前质检方案已生成对应检验记录!";
			mes.message = "修改失败,当前质检方案已生成对应检验记录!";
			mes.data = null;
			return mes;
			}
			@@ -655,14 +679,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;
			}
			}
			@@ -670,7 +694,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -693,7 +717,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除失败,当前质检方案已生成对应检验记录!";
			mes.message = "删除失败,当前质检方案已生成对应检验记录!";
			mes.data = null;
			return mes;
			}
			@@ -711,14 +735,14 @@
			LogHelper.DbOperateLog(us.usercode, "删除", "质检方案:" + qualityinsptcode, 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;
			}
			}
			@@ -726,7 +750,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -751,7 +775,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "请扫描工序条码!";
			mes.message = "请扫描工序条码!";
			mes.data = null;
			return mes;
			}
			@@ -760,8 +784,33 @@
			ordercode = arra[0]; //获取指定字符串前面的字符
			stepcode = arra[1]; //获取指定字符串前面的字符
			}
			//0.判断当前条码工序任务不存在
			sql = @"select * from TK_Wrk_Step where wo_code=@ordercode and step_code=@step_code";
			dynamicParams.Add("@ordercode", ordercode);
			dynamicParams.Add("@step_code", stepcode);
			var da1 = DapperHelper.selectdata(sql, dynamicParams);
			if (da1.Rows.Count <= 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = "当前条码,工序任务不存在,请联系管理员!";
			mes.data = null;
			return mes;
			}
			//判断当前工单是否关闭
			sql = @"select * from TK_Wrk_Man where wo_code=@ordercode and status='CLOSED'";
			dynamicParams.Add("@ordercode", ordercode);
			var da0 = DapperHelper.selectdata(sql, dynamicParams);
			if (da0.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = "当前工单已关闭,不允许检验操作!";
			mes.data = null;
			return mes;
			}
			//通过扫描二维码信息查找任务信息
			sql = @"select A.wo_code,A.good_qty,M.partcode,M.partname,M.partspec,M.stocktype_code,S.stepcode,S.stepname
			sql = @"select A.wo_code,A.good_qty,M.partcode,M.partname,M.partspec,M.idinventoryclass as stocktype_code,S.stepcode,S.stepname
			from TK_Wrk_Step A
			inner join TK_Wrk_Man P on A.wo_code=P.wo_code
			left join TMateriel_Info M on P.materiel_code=M.partcode
			@@ -790,14 +839,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;
			}
			@@ -806,7 +855,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工序任务无报工产出!";
			mes.message = "当前工序任务无报工产出!";
			mes.data = null;
			return mes;
			}
			@@ -815,7 +864,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "生产任务不存在!";
			mes.message = "生产任务不存在!";
			mes.data = null;
			return mes;
			}
			@@ -824,7 +873,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "二维码信息为空!";
			mes.message = "二维码信息为空!";
			mes.data = null;
			return mes;
			}
			@@ -833,7 +882,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -860,14 +909,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;
			}
			}
			@@ -875,7 +924,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -962,14 +1011,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;
			}
			}
			@@ -977,7 +1026,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1044,7 +1093,7 @@
			where A.check_type in('FirstCheck','PatroCheck','EndCheck') " + 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();
			}
			@@ -1052,7 +1101,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1074,14 +1123,14 @@
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.data = dt;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "无检验明细数据!";
			mes.message = "无检验明细数据!";
			mes.data = null;
			}
			}
			@@ -1089,7 +1138,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1199,7 +1248,7 @@
			data.TableName = "Table"; //设置DataTable的名称
			string msg = DownLoad.DataTableToExcel(data, "工序检验记录");
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = msg;
			}
			@@ -1207,7 +1256,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;