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;
			@@ -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,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;
			@@ -515,14 +515,14 @@
			sql = @"select code,name,descr from TStepCheckItem";
			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;
			@@ -603,7 +603,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "修改失败,当前质检方案已生成对应检验记录!";
			mes.message = "修改失败,当前质检方案已生成对应检验记录!";
			mes.data = null;
			return mes;
			}
			@@ -679,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;
			}
			}
			@@ -694,7 +694,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -717,7 +717,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除失败,当前质检方案已生成对应检验记录!";
			mes.message = "删除失败,当前质检方案已生成对应检验记录!";
			mes.data = null;
			return mes;
			}
			@@ -735,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;
			}
			}
			@@ -750,7 +750,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -775,7 +775,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "请扫描工序条码!";
			mes.message = "请扫描工序条码!";
			mes.data = null;
			return mes;
			}
			@@ -814,14 +814,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;
			}
			@@ -830,7 +830,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前工序任务无报工产出!";
			mes.message = "当前工序任务无报工产出!";
			mes.data = null;
			return mes;
			}
			@@ -839,7 +839,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "生产任务不存在!";
			mes.message = "生产任务不存在!";
			mes.data = null;
			return mes;
			}
			@@ -848,7 +848,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "二维码信息为空!";
			mes.message = "二维码信息为空!";
			mes.data = null;
			return mes;
			}
			@@ -857,7 +857,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -884,14 +884,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;
			}
			}
			@@ -899,7 +899,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -986,14 +986,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;
			}
			}
			@@ -1001,7 +1001,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1068,7 +1068,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();
			}
			@@ -1076,7 +1076,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1098,14 +1098,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;
			}
			}
			@@ -1113,7 +1113,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			@@ -1223,7 +1223,7 @@
			data.TableName = "Table"; //设置DataTable的名称
			string msg = DownLoad.DataTableToExcel(data, "工序检验记录");
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.message = "查询成功!";
			mes.count = total;
			mes.data = msg;
			}
			@@ -1231,7 +1231,7 @@
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;