LXAPI.git - Gitblit

			@@ -925,8 +925,8 @@
			string sql0 = @"select ISNULL(IDENT_CURRENT('TBom_Main')+1,1) as id";
			var dt = DapperHelper.selecttable(sql0);
			//写入BOM主表
			sql = @"insert into TBom_Main(materiel_code,quantity,status,version,lm_user,lm_date)
			values(@materiel_code,@quantity,@status,@version,@username,@CreateDate)";
			sql = @"insert into TBom_Main(materiel_code,quantity,status,version,lm_user,lm_date,startdate)
			values(@materiel_code,@quantity,@status,@version,@username,@CreateDate,@startdate)";
			list.Add(new
			{
			str = sql,
			@@ -937,7 +937,8 @@
			status = status,
			version = version,
			username = username,
			CreateDate = DateTime.Now.ToString()
			CreateDate = DateTime.Now.ToString(),
			startdate = startdate
			}
			});
			//写入BOM子表
			@@ -985,12 +986,12 @@
			str = sql,
			parm = new
			{
			id = bomid,
			bomid = bomid,
			materiel_code = parentpartcode,
			quantity = quantity,
			status = status,
			username = username,
			CreateDate = DateTime.Now.ToString()
			lm_user = username,
			lm_date = DateTime.Now.ToString()
			}
			});
			//删除BOM子表
			@@ -1000,7 +1001,7 @@
			str = sql,
			parm = new
			{
			id = bomid
			bomid = bomid
			}
			});
			//写入BOM子表
			@@ -1058,6 +1059,18 @@
			var dynamicParams = new DynamicParameters();
			try
			{
			//判断物料类型是否有关联物料
			sql = @"select materiel_code from TK_Wrk_Man where materiel_code in (select materiel_code from TBom_Main where id=@bomid ) and bom_id=@bomid";
			dynamicParams.Add("@bomid", bomid);
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			if (data0.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前物料清单已被工单关联使用,不允许修改!";
			mes.data = null;
			return mes;
			}
			//获取Bom子表数据
			sql = @"select A.seq,B.partcode,B.partname,B.partspec,B.uom_code,T.name as uom_name,
			A.base_quantity,A.loss_quantity,A.total_quantity,A.pn_type
			@@ -1317,6 +1330,18 @@
			var dynamicParams = new DynamicParameters();
			try
			{
			//判断工艺路路线是否被存货绑定
			sql = @"select * from TMateriel_Route where route_code=@routecode";
			dynamicParams.Add("@routecode", routecode);
			var data_0 = DapperHelper.selectdata(sql, dynamicParams);
			if (data_0.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "存货档案已关联工艺路线，不允许删除!";
			mes.data = null;
			return mes;
			}
			//判断工艺路线是否被工单引用(被引用则不能删除)
			sql = @"select * from TK_Wrk_Man where route_code=@routecode";
			dynamicParams.Add("@routecode", routecode);
			@@ -1327,6 +1352,7 @@
			mes.count = 0;
			mes.Message = "工艺路线已被工单引用，不允许删除!";
			mes.data = null;
			return mes;
			}
			else
			{
			@@ -1340,6 +1366,7 @@
			mes.count = 0;
			mes.Message = "工艺路线已设置节拍工价，请先删除设置!";
			mes.data = null;
			return mes;
			}
			else
			{
			@@ -1353,21 +1380,23 @@
			sql = @"delete TMateriel_Route where route_code=@routecode";
			list.Add(new { str = sql, parm = new { routecode = routecode } });
			}
			}
			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;
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "删除成功!";
			mes.data = null;
			return mes;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "删除失败!";
			mes.data = null;
			return mes;
			}
			}
			}
			catch (Exception e)
			@@ -1376,6 +1405,7 @@
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			return mes;
			}
			return mes;
			}
			@@ -1988,12 +2018,12 @@
			try
			{
			//通过产品编码查找关联的工艺路线信息
			sql = @"select B.stepcode as code,B.stepname as name
			sql = @"select B.stepcode as code,B.stepname as name,B.flwtype as flag
			from TFlw_Rtdt A
			inner join TStep B on A.step_code=B.stepcode
			where A.rout_code=@routecode and B.is_delete<>'1' and A.is_delete<>'1'";
			dynamicParams.Add("@routecode", routecode);
			var data = DapperHelper.select<ObjectData>(sql, dynamicParams);
			var data = DapperHelper.select<StepDefect>(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data;
			@@ -2037,16 +2067,19 @@
			}
			#endregion

			#region[根据工序线编码查找关联设备集合]
			public static ToMessage StepSelectEqpList(string partcode, string routecode, string stepcode, int startNum, int endNum, string prop, string order)
			#region[根据工序线编码查找关联设备/外协供方集合]
			public static ToMessage StepSelectEqpList(string partcode, string routecode, string stepcode,string steptype, int startNum, int endNum, string prop, string order)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			string search = "",sql="";
			int total = 0;
			try
			{
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select B.code as eqpcode,B.name as eqpname,B.wksp_code,T.org_name as wksp_name,A.eqp_value,A.stand_value,A.cavity_qty,A.unprice
			if (steptype == "Z") //自制工序
			{
			total = 0; //总条数
			sql = @"select B.code as eqpcode,B.name as eqpname,B.wksp_code,T.org_name as wksp_name,A.eqp_value,A.stand_value,A.cavity_qty,A.unprice
			from (
			select materiel_code, eqp_code,eqp_value,stand_value,cavity_qty,unprice from TPrteEqp_Stad
			where materiel_code=@partcode and route_code=@routecode and step_code=@stepcode
			@@ -2058,9 +2091,27 @@
			left join TOrganization T on B.wksp_code=T.org_code
			left join TMateriel_Info C on A.materiel_code=C.partcode
			where B.is_delete<>'1' and T.is_delete<>'1' and C.is_delete<>'1' ";
			dynamicParams.Add("@partcode", partcode);
			dynamicParams.Add("@routecode", routecode);
			dynamicParams.Add("@stepcode", stepcode);
			dynamicParams.Add("@partcode", partcode);
			dynamicParams.Add("@routecode", routecode);
			dynamicParams.Add("@stepcode", stepcode);
			}
			else //外协工序
			{
			total = 0; //总条数
			sql = @"select B.code as eqpcode,B.name as eqpname,'' as wksp_code,'' as wksp_name,A.eqp_value,A.stand_value,A.cavity_qty,A.unprice
			from (
			select materiel_code, eqp_code,eqp_value,stand_value,cavity_qty,unprice from TPrteEqp_Stad
			where materiel_code=@partcode and route_code=@routecode and step_code=@stepcode
			union all
			select @partcode as materiel_code,eqp_code,'0' as eqp_value,'0' as stand_value,'0' as cavity_qty,'0' as unprice
			from TFlw_Rteqp where step_code=@stepcode and style='W' and @partcode+eqp_code+step_code not in(select materiel_code+eqp_code+step_code from TPrteEqp_Stad)
			) A
			left join TCustomer B on A.eqp_code=B.code
			where B.is_delete<>'1'";
			dynamicParams.Add("@partcode", partcode);
			dynamicParams.Add("@routecode", routecode);
			dynamicParams.Add("@stepcode", stepcode);
			}
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			@@ -2087,31 +2138,33 @@
			{
			if (partcode != "" && partcode != null)
			{
			search += "and A.materiel_code=@partcode ";
			search += "and AA.materiel_code=@partcode ";
			dynamicParams.Add("@partcode", partcode);
			}
			if (routecode != "" && routecode != null)
			{
			search += "and A.route_code=@routecode ";
			search += "and AA.route_code=@routecode ";
			dynamicParams.Add("@routecode", routecode);
			}
			if (stepcode != "" && stepcode != null)
			{
			search += "and A.step_code=@stepcode ";
			search += "and AA.step_code=@stepcode ";
			dynamicParams.Add("@stepcode", stepcode);
			}
			if (eqpcode != "" && eqpcode != null)
			{
			search += "and A.eqp_code=@eqpcode";
			search += "and AA.eqp_code=@eqpcode";
			dynamicParams.Add("@eqpcode", eqpcode);
			}
			if (search == "")
			{
			search = "and 1=1 ";
			}
			search = search.Substring(3);//截取索引2后面的字符
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select A.materiel_code as partcode,B.partname,B.partspec,A.route_code,C.name as route_name,
			var sql = @"select * from (
			select A.materiel_code as partcode,B.partname,B.partspec,A.route_code,C.name as route_name,
			D.stepcode,D.stepname,A.eqp_code,E.name as eqp_name,E.wksp_code,F.org_name as wksp_name,
			A.eqp_value,A.stand_value,A.cavity_qty,A.unprice
			from TPrteEqp_Stad A
			@@ -2120,7 +2173,19 @@
			left join TStep D on A.step_code=D.stepcode
			left join TEqpInfo E on A.eqp_code=E.code
			left join TOrganization F on E.wksp_code=F.org_code
			where B.is_delete<>'1' and C.is_delete<>'1' and D.is_delete<>'1' and E.is_delete<>'1' and F.is_delete<>'1' " + search;
			left join TCustomer S on A.eqp_code=S.code
			where B.is_delete<>'1' and C.is_delete<>'1' and D.is_delete<>'1' and E.is_delete<>'1' and F.is_delete<>'1'
			union all
			select A.materiel_code as partcode,B.partname,B.partspec,A.route_code,C.name as route_name,
			D.stepcode,D.stepname,S.code,S.name as eqp_name,'' as wksp_code,'' as wksp_name,
			A.eqp_value,A.stand_value,A.cavity_qty,A.unprice
			from TPrteEqp_Stad A
			left join TMateriel_Info B on A.materiel_code=B.partcode
			left join TFlw_Rout C on A.route_code=C.code
			left join TStep D on A.step_code=D.stepcode
			left join TCustomer S on A.eqp_code=S.code
			where B.is_delete<>'1' and C.is_delete<>'1' and D.is_delete<>'1' and S.is_delete<>'1'
			) as AA where" + search;
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";