protected string GetStoreidBySavdptid(String savdptid) { var qry = from e in WmsDc.wms_set where e.setid == "008" && e.isvld == 'y' && e.val1 == savdptid.Trim() select e; wms_set st = qry.FirstOrDefault(); if (st != null) { return(st.val3.Trim()); } return(null); }
protected String GetDescByCode(string code) { var qry = from e in set996 where e.setid.Trim() == "996" && e.isvld == 'y' && e.val1.Trim() == code select e; wms_set st = qry.FirstOrDefault(); if (st != null) { return(st.brief.Trim()); } return("{0}"); }