/// <summary> /// 语言名传语言id /// </summary> /// <param name="name">多个name用“/”隔开</param> /// <returns>转换后的语言id</returns> public static string LangToId(string name) { using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext()) { List <int> languages = new List <int>(); foreach (string item in name.Split('/')) { tbl_Language tblLang = _db.tbl_Language.SingleOrDefault(p => p.lang_Name == item); if (tblLang == null) { languages.Add(_db.InsertLang(item)); } else { languages.Add(_db.tbl_Language.SingleOrDefault(p => p.lang_Name == item).lang_Id); } } return(string.Join("/", languages)); } }
/// <summary> /// /// </summary> /// <param name="_IsDefault"></param> /// <param name="_LangCode"></param> /// <param name="_LangImage"></param> /// <param name="_LangName"></param> /// <returns></returns> public static bool InsertLanguage(bool _IsDefault, string _LangCode, string _LangImage, string _LangName) { bool _Check = false; tbl_Language lng = new tbl_Language(); lng.IsDefault = _IsDefault; lng.LangCode = _LangCode; lng.LangImage = _LangImage; lng.LangName = _LangName; try { if (_IsDefault) { //Clear is default status from other record, then insert with new default. ClearLanguageDefaul(); } Enidc.Web.DataHelper.Insert<tbl_Language>(lng); _Check = true; } catch (Exception ex) { throw new Exception(ex.ToString()); } return _Check; }
public static tbl_Language GetLanguageDefault() { tbl_Language lang = new tbl_Language(); using (enidcDataContext db = Enidc.Web.DataHelper.getEnIdcData()) { try { lang = db.tbl_Languages.SingleOrDefault(i => i.IsDefault.Equals(true)); return lang; } catch { return lang; } }//end using }
/// <summary> /// /// </summary> /// <param name="_LanguageCode"></param> /// <returns></returns> public static tbl_Language GetLanguageByCode(string _LanguageCode) { tbl_Language lng = new tbl_Language(); using (enidcDataContext db = Enidc.Web.DataHelper.getEnIdcData()) { try { lng = db.tbl_Languages.SingleOrDefault(i => i.LangCode.Equals(_LanguageCode)); return lng; } catch { return lng; } } }
partial void Deletetbl_Language(tbl_Language instance);
partial void Updatetbl_Language(tbl_Language instance);
partial void Inserttbl_Language(tbl_Language instance);