JLApi.git - Gitblit

			@@ -3292,5 +3292,213 @@
			return mes;
			}
			#endregion


			#region[工序查询]
			public static ToMessage StepSearch(string stepcode, string stepname, string enable, string steptypecode,int startNum, int endNum, string prop, string order)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			try
			{
			if (stepcode != "" && stepcode != null)
			{
			search += "and A.stepcode like '%'+@stepcode+'%' ";
			dynamicParams.Add("@stepcode", stepcode);
			}
			if (stepname != "" && stepname != null)
			{
			search += "and A.stepname like '%'+@stepname+'%' ";
			dynamicParams.Add("@stepname", stepname);
			}
			if (enable != "" && enable != null)
			{
			search += "and A.enable=@enable ";
			dynamicParams.Add("@enable", enable);
			}
			if (steptypecode != "" && steptypecode != null)
			{
			search += "and A.flwtype=@steptypecode ";
			dynamicParams.Add("@steptypecode", steptypecode);
			}
			if (search == "")
			{
			search = "and 1=1 ";
			}
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select A.id,A.stepcode,A.stepname,A.flwtype,A.enable,A.descr,U.username as lm_user,A.lm_date
			from TStep 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 = "查询成功!";
			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[工序新增编辑]
			public static ToMessage AddUpdateStep(string stepid, string stepcode, string stepname, string steptypecode, string enable, string description, User us, string operType)
			{
			var dynamicParams = new DynamicParameters();
			List<object> list = new List<object>();
			var sql = "";
			try
			{
			if (operType == "Add")
			{
			sql = @"select * from TStep where stepcode=@stepcode";
			dynamicParams.Add("@stepcode", stepcode);
			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 = @"insert into TStep(stepcode,stepname,flwtype,enable,descr,lm_user,lm_date)
			values(@stepcode,@stepname,@steptypecode,@enable,@description,@username,@CreateDate)";
			dynamicParams.Add("@stepcode", stepcode);
			dynamicParams.Add("@stepname", stepname);
			dynamicParams.Add("@steptypecode", steptypecode);
			dynamicParams.Add("@enable", enable);
			dynamicParams.Add("@description", description);
			dynamicParams.Add("@username", us.usercode);
			dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
			int cont = DapperHelper.SQL(sql, dynamicParams);
			if (cont > 0)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "新增", "新增了工序:" + stepcode, us.usertype);
			mes.code = "200";
			mes.count = 0;
			mes.Message = "新增操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "新增操作失败!";
			mes.data = null;
			}
			}
			if (operType == "Update")
			{
			list.Clear();
			//如果当前工序使用状态位N(未启用),需判断当前工序是否被工单引用
			if (enable == "N")
			{
			var sql0 = @"select * from TK_Wrk_Step A where A.step_code=@stepcode";
			dynamicParams.Add("@stepcode", stepcode);
			var data = DapperHelper.selectdata(sql0, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "工序有关联工单,不允许修改!";
			mes.data = null;
			return mes;
			}
			}
			sql = @"update TStep set stepname=@stepname,flwtype=@steptypecode,enable=@enable,descr=@description,
			lm_user=@username,lm_date=@CreateDate where id=@stepid";
			list.Add(new { str = sql, parm = new {stepid = stepid, stepname = stepname, steptypecode = steptypecode, enable = enable, description = description, username = us.usercode, CreateDate = DateTime.Now.ToString() } });
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "修改", "修改了工序:" + stepcode, us.usertype);
			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[工序删除]
			public static ToMessage DeleteStep(string stepcode, User us)
			{
			var sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			list.Clear();
			//当前工序是否关联工单
			sql = @"select * from TK_Wrk_Step A where A.step_code=@stepcode";
			dynamicParams.Add("@stepcode", stepcode);
			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 TStep where stepcode=@stepcode";
			list.Add(new { str = sql, parm = new { stepcode = stepcode } });
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			//写入操作记录表
			LogHelper.DbOperateLog(us.usercode, "删除", "删除了工序:" + stepcode, us.usertype);
			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

			}
			}