public static int UpdateUserCategory(string tableName, int id, int pid, int uid, string name, string pinyin = null, string pinyinabbr = null, string ename = null) { if (pinyin == null) { pinyin = HZ.ToPinYin(name, true); } if (pinyinabbr == null) { pinyinabbr = PinYin.GetInitial(name); } if (ename == null) { ename = pinyin; } //check pid & uid if (pid != 0 && !DBH.GetBoolean(QA.DBCS_CMS, CommandType.Text, "SELECT COUNT(id) FROM " + tableName + " WHERE pid=@pid AND uid=@uid", new SqlParameter("@pid", pid), new SqlParameter("@uid", uid))) { return(-1); } return(EB <UserCategoryEntity> .Update(QA.DBCS_CMS, new UserCategoryEntity() { id = id, uid = uid, pid = pid, name = name, pinyin = pinyin, pinyinabbr = pinyinabbr, ename = ename }, tableName)); }
public static int CreateUserCategory(string tableName, int pid, int uid, string name, string pinyin = null, string pinyinabbr = null, string ename = null) { if (pinyin == null) { pinyin = HZ.ToPinYin(name, true); } if (pinyinabbr == null) { pinyinabbr = PinYin.GetInitial(name); } if (ename == null) { ename = pinyin; } return(EB <UserCategoryEntity> .Create(QA.DBCS_CMS, new UserCategoryEntity() { uid = uid, pid = pid, name = name, pinyin = pinyin, pinyinabbr = pinyinabbr, ename = ename }, tableName)); }
public static int RenameUserCategory(string tableName, int id, string name) { string pinyin = HZ.ToPinYin(name, true); string pinyinabbr = PinYin.GetInitial(name); return(DBH.ExecuteText(QA.DBCS_CMS, "UPDATE " + tableName + " SET name=@name,pinyin=@pinyin,pinyinabbr=@pinyinabbr,ename=@ename WHERE id=@id", new SqlParameter("@name", name), new SqlParameter("@pinyin", pinyin), new SqlParameter("@pinyinabbr", pinyinabbr), new SqlParameter("@ename", pinyin), new SqlParameter("@id", id))); }
/// <summary> /// 获取用户的个性域名 /// </summary> /// <param name="name"></param> /// <returns></returns> public static string GetWWW(string name) { string www = HZ.ToPinYin(name); if (www.Length > 20) { PinYin.GetInitial(name); } if (Keyword.Reserve(www) || UserData.ExistWWW(www)) { int i = 1; string w = www + "_" + i; while (Keyword.Reserve(w) || UserData.ExistWWW(w)) { i++; w = www + "_" + i; } www = w; } return(www); }