JTAPI.git - Gitblit

			@@ -1295,7 +1295,7 @@
			{
			is_firststep = "Y";
			}
			else if (Convert.ToInt32(json.Data.Rows[i]["SEQ"].ToString()) == json.Data.Rows.Count) //是否末道工序
			if (Convert.ToInt32(json.Data.Rows[i]["SEQ"].ToString()) == json.Data.Rows.Count) //是否末道工序
			{
			is_laststep = "Y";
			}
			@@ -1339,6 +1339,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);
			@@ -1688,13 +1700,13 @@
			where A.step_code=@stepcode and A.is_delete<>'1' and B.is_delete<>'1'
			) B on T.org_code=B.wksp_code where T.description='W' and is_delete<>'1'
			UNION ALL
			select distinct T.btype as wksp_code,(case T.btype when 'WX' then '外协供方' end ) as wksp_name,'W' as type,(case when B.btype is null then 'N' else 'Y' end) flag
			select distinct T.type as wksp_code,(case when T.type='211' then '供应商' when T.type='228' then '客户/供应商' end ) as wksp_name,'W' as type,(case when B.type is null then 'N' else 'Y' end) flag
			from TCustomer T
			left join(
			select distinct A.eqp_code,B.btype from TFlw_Rteqp A
			select distinct A.eqp_code,B.type from TFlw_Rteqp A
			inner join TCustomer B on A.eqp_code=B.code
			where A.step_code=@stepcode and A.is_delete<>'1' and B.is_delete<>'1'
			) B on T.btype=B.btype where T.btype='WX' and T.is_delete<>'1'";
			where A.step_code=@stepcode and A.is_delete<>'1' and B.is_delete<>'1'
			) B on T.type=B.type where T.type in('211','228') and T.is_delete<>'1'"; //226(客户)
			dynamicParams.Add("@stepcode", stepcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			for (int i = 0; i < data.Rows.Count; i++)
			@@ -1705,7 +1717,7 @@
			rout.type = data.Rows[i]["TYPE"].ToString();
			rout.flag = data.Rows[i]["FLAG"].ToString();
			rout.children = new List<StepEqpCn>();
			if (rout.code == "WX") //外协供方
			if (rout.code == "211"\|\| rout.code == "228") //外协供方
			{
			//根据外协供方标识编码查找外协供方信息(包含已关联标识)
			sql = @"select A.code,A.name,'W' as type,(case when B.eqp_code is null then 'N' else 'Y' end) flag
			@@ -1713,8 +1725,9 @@
			left join(
			select distinct A.eqp_code from TFlw_Rteqp A
			inner join TCustomer B on A.eqp_code=B.code
			where B.btype=@wxcode and A.is_delete<>'1' and B.is_delete<>'1'
			) B on A.code=B.eqp_code where A.btype=@wxcode and A.is_delete<>'1'";
			where A.step_code=@stepcode and B.type=@wxcode and A.is_delete<>'1' and B.is_delete<>'1'
			) B on A.code=B.eqp_code where A.type=@wxcode and A.is_delete<>'1'";
			dynamicParams.Add("@stepcode", stepcode);
			dynamicParams.Add("@wxcode", rout.code);
			var data0 = DapperHelper.selectdata(sql, dynamicParams);
			for (int k = 0; k < data0.Rows.Count; k++)
			@@ -2077,13 +2090,17 @@
			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='E' and @partcode+eqp_code+step_code not in(select materiel_code+eqp_code+step_code from TPrteEqp_Stad)
			select @partcode as materiel_code,C.eqp_code,'0' as eqp_value,'0' as stand_value,'0' as cavity_qty,'0' as unprice
			from TFlw_Rout A
			inner join TFlw_Rtdt B on A.code=B.rout_code
			left join TFlw_Rteqp C on B.step_code=C.step_code
			where A.code=@routecode and B.step_code=@stepcode and style='E' and @partcode+A.code+C.eqp_code+B.step_code
			not in(select materiel_code+route_code+eqp_code+step_code from TPrteEqp_Stad where materiel_code=@partcode and route_code=@routecode and step_code=@stepcode)
			) A
			left join TEqpInfo B on A.eqp_code=B.code
			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' ";
			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);