LKApi.git - Gitblit

			@@ -29,23 +29,25 @@
			{
			if (defectcode != "" && defectcode != null)
			{
			search += "and code=@defectcode ";
			search += "and A.code=@defectcode ";
			dynamicParams.Add("@defectcode", defectcode);
			}
			if (defectname != "" && defectname != null)
			{
			search += "and name like '%'+@defectname+'%' ";
			search += "and A.name like '%'+@defectname+'%' ";
			dynamicParams.Add("@defectname", defectname);
			}
			if (defectdescr != "" && defectdescr != null)
			{
			search += "and descr like '%'+@defectdescr+'%' ";
			search += "and A.descr like '%'+@defectdescr+'%' ";
			dynamicParams.Add("@defectdescr", defectdescr);
			}

			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select code,name,descr,lm_user,lm_date from TDefect where is_delete<>'1' " + search;
			var sql = @"select A.code,A.name,A.descr,U.username as lm_user,A.lm_date from TDefect A
			left join TUser U on A.lm_user=U.usercode
			where A.is_delete<>'1' " + search;
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			@@ -61,6 +63,7 @@
			}
			return mes;
			}

			#endregion

			#region[质量管理，缺陷定义新增、编辑提交]
			@@ -208,23 +211,25 @@
			{
			if (stanedcode != "" && stanedcode != null)
			{
			search += "and code=@stanedcode ";
			search += "and A.code=@stanedcode ";
			dynamicParams.Add("@stanedcode", stanedcode);
			}
			if (stanedname != "" && stanedname != null)
			{
			search += "and name like '%'+@stanedname+'%' ";
			search += "and A.name like '%'+@stanedname+'%' ";
			dynamicParams.Add("@stanedname", stanedname);
			}
			if (staneddescr != "" && staneddescr != null)
			{
			search += "and descr like '%'+@staneddescr+'%' ";
			search += "and A.descr like '%'+@staneddescr+'%' ";
			dynamicParams.Add("@staneddescr", staneddescr);
			}

			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select code,name,descr,lm_user,lm_date from TStepCheckStandard where is_delete<>'1' " + search;
			var sql = @"select A.code,A.name,A.descr,U.username as lm_user,A.lm_date from TStepCheckStandard A
			left join TUser U on A.lm_user=U.usercode
			where A.is_delete<>'1' " + search;
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			@@ -255,12 +260,21 @@
			where code=@defectcode and is_delete<>'1'";
			dynamicParams.Add("@defectcode", defectcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);

			RoutEdit rout = new RoutEdit();
			rout.code = data.Rows[0]["CODE"].ToString();
			rout.name = data.Rows[0]["NAME"].ToString();
			rout.description = data.Rows[0]["DESCR"].ToString();

			if (data.Rows.Count > 0)
			{
			rout.code = data.Rows[0]["CODE"].ToString();
			rout.name = data.Rows[0]["NAME"].ToString();
			rout.description = data.Rows[0]["DESCR"].ToString();
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "无工序检验标准信息!";
			mes.data = null;
			return mes;
			}
			//根据工序检验标准编码获取关联的工序检验项目信息
			sql = @"select B.code,B.name,A.stepcheckitem_desc from TStepCheckStandardSub A
			left join TStepCheckItem B on A.stepcheckitem_code=B.code
			@@ -296,6 +310,59 @@
			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;
			}
			#endregion

			#region[工序检验标准删除]
			public static ToMessage DeleteStepCheckStaned(string stanedcode)
			{
			var sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			sql = @"select * from TStepCheckRecord where checkstaned_code=@stanedcode";
			dynamicParams.Add("@stanedcode", stanedcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前检验标准已生成检验记录,不允许删除!";
			mes.data = null;
			return mes;
			}
			//删除工序检验标准主表
			sql = @"delete TStepCheckStandard where code=@stanedcode";
			list.Add(new { str = sql, parm = new { stanedcode = stanedcode } });
			//删除工序检验标准项目子表
			sql = @"delete TStepCheckStandardSub where stepstaned_code=@stanedcode";
			list.Add(new { str = sql, parm = new { stanedcode = stanedcode } });

			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)
			{
			@@ -347,11 +414,11 @@
			if (opertype == "Update")
			{
			//删除工序检验标准子表
			sql = @"delete from TStepCheckStandard where stepstaned_code=@stepstaned_code";
			sql = @"delete from TStepCheckStandard where code=@stepstaned_code";
			list.Add(new { str = sql, parm = new { stepstaned_code = json.code} });
			//修改工序检验标准主表
			sql = @"update TStepCheckStandard set name=@stepstaned_name,descr=@stepstaned_desc where stepstaned_code=@stepstaned_code";
			list.Add(new { str = sql, parm = new { stepstaned_name = json.code, stepstaned_desc=json.description } });
			sql = @"update TStepCheckStandard set name=@stepstaned_name,descr=@stepstaned_desc where code=@stepstaned_code";
			list.Add(new { str = sql, parm = new { stepstaned_code=json.code, stepstaned_name = json.name, stepstaned_desc=json.description } });
			//新增工序检验标准子表
			for (int i = 0; i < json.Data.Rows.Count; i++)
			{
			@@ -400,23 +467,25 @@
			{
			if (itemcode != "" && itemcode != null)
			{
			search += "and code=@itemcode ";
			search += "and A.code=@itemcode ";
			dynamicParams.Add("@itemcode", itemcode);
			}
			if (itemname != "" && itemname != null)
			{
			search += "and name like '%'+@itemname+'%' ";
			search += "and A.name like '%'+@itemname+'%' ";
			dynamicParams.Add("@itemname", itemname);
			}
			if (itemdescr != "" && itemdescr != null)
			{
			search += "and descr like '%'+@itemdescr+'%' ";
			search += "and A.descr like '%'+@itemdescr+'%' ";
			dynamicParams.Add("@itemdescr", itemdescr);
			}

			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select code,name,descr,lm_user,lm_date from TStepCheckItem where is_delete<>'1' " + search;
			var sql = @"select A.code,A.name,A.descr,U.username as lm_user,A.lm_date from TStepCheckItem A
			left join TUser U on A.lm_user=U.usercode
			where A.is_delete<>'1' " + search;
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			@@ -567,5 +636,8 @@
			return mes;
			}
			#endregion



			}
			}