public static string getPartEdge(string pncode) { string res = string.Empty; try { string sql = "SELECT [PartNO],[EdgeType] FROM [FGA_PLATFORM].[dbo].[ARG_part_edgetype] WHERE PartNO ='" + pncode.Trim() + "'"; DataSet ds = new DataSet(); ds = FGA_DAL.Base.SQLServerHelper_FGA.Query(sql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { List <ARG_BoxLabelModel> luw = new List <ARG_BoxLabelModel>(); foreach (DataRow row in ds.Tables[0].Rows) { ARG_BoxLabelModel ERM = new ARG_BoxLabelModel(row); luw.Add(ERM); } JavaScriptSerializer jssl = new JavaScriptSerializer(); res = jssl.Serialize(luw); } } catch (Exception e) { } return(res); }
public static string getPartAcc(string pncode) { string res = string.Empty; try { string sql = "SELECT pp.Part_No as [Component_Part],pp.Part_Type as [Component_Type] " + "FROM[PlexDB].[dbo].[Part_v_BOM] pb left join[PlexDB].[dbo].[Part_v_Part_Operation] ppo on pb.Part_Key = ppo.Part_Key " + "and pb.Part_Operation_Key = ppo.Part_Operation_Key " + "left join[PlexDB].[dbo].[Part_v_part] pp on pb.Component_Part_Key = pp.Part_Key " + "where pb.part_key = (select part_key from[PlexDB].[dbo].[part_v_part] " + "where part_no = '" + pncode.Trim() + "') and pp.Part_No not like 'BH%' and pp.Part_NO not like 'BU%'" + "and(ppo.Operation_No = '1500' or ppo.Operation_No = '1400') "; DataSet ds = new DataSet(); ds = FGA_DAL.Base.SQLServerHelper_Plex.Query(sql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { List <ARG_BoxLabelModel> luw = new List <ARG_BoxLabelModel>(); foreach (DataRow row in ds.Tables[0].Rows) { ARG_BoxLabelModel ERM = new ARG_BoxLabelModel(row); luw.Add(ERM); } JavaScriptSerializer jssl = new JavaScriptSerializer(); res = jssl.Serialize(luw); } } catch (Exception e) { } return(res); }