/// <summary> /// C用户 用户注册 /// </summary> /// <param name="userInfo">用户信息</param> /// <returns></returns> public int AddUser(UserModel userInfo) { //插入账户基本信息 const string sql = @"INSERT INTO user_info(innerid, username, password, nickname, mobile, telephone, email,headportrait, realname, status, provid, cityid, countyid, sex, brithday, qq, signature, totalpoints, qrcode, createrid, createdtime, modifierid, modifiedtime) VALUES (@innerid, @username, @password, @nickname, @mobile, @telephone, @email,@headportrait, @realname, @status, @provid, @cityid, @countyid, @sex, @brithday, @qq, @signature, @totalpoints, @qrcode, @createrid, @createdtime,@modifierid, @modifiedtime);"; using (var conn = Helper.GetConnection()) { try { conn.Execute(sql, userInfo); return 1; } catch (Exception ex) { LoggerFactories.CreateLogger().Write("C用户注册:", TraceEventType.Error, ex); return 0; } } }
/// <summary> /// C用户 修改会员信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateUserInfo(UserModel model) { var sqlStr = new StringBuilder("update user_info set "); sqlStr.Append(Helper.CreateField(model).Trim().TrimEnd(',')); sqlStr.Append(" where innerid = @innerid"); using (var conn = Helper.GetConnection()) { var tran = conn.BeginTransaction(); try { conn.Execute(sqlStr.ToString(), model, tran); tran.Commit(); return 1; } catch (Exception ex) { LoggerFactories.CreateLogger().Write("C用户修改会员信息:", TraceEventType.Error, ex); tran.Rollback(); return 0; } } }