public void Insert(UserInfo userInfo) { string sql = string.Format(@"Insert into tb_UserInfo ({0},{1},{2},{3},{4},{5},{6},{7}) values(@{0},@{1},@{2},@{3},@{4},@{5},@{6},@{7})", UserInfo.USERID, UserInfo.PASSWORD, UserInfo.NAME, UserInfo.STATE, UserInfo.GIVENCREDIT, UserInfo.AVAILABLEGIVENCREDIT, UserInfo.SHARERATE, UserInfo.EMAIL); base.ExecuteNonQuery(sql, new SqlParameter(UserInfo.USERID, userInfo.UserId), new SqlParameter(UserInfo.PASSWORD, userInfo.Password), new SqlParameter(UserInfo.NAME, userInfo.Name), new SqlParameter(UserInfo.STATE, (int)userInfo.State), new SqlParameter(UserInfo.GIVENCREDIT, userInfo.GivenCredit), new SqlParameter(UserInfo.AVAILABLEGIVENCREDIT, userInfo.AvailableGivenCredit), new SqlParameter(UserInfo.SHARERATE, userInfo.ShareRate), new SqlParameter(UserInfo.EMAIL, userInfo.Email)); }
public void Update(UserInfo userInfo) { string sql = string.Format(@"UPDATE {0} SET {1}=@{1},{2}=@{2},{3}=@{3},{4}=@{4},{5}=@{5},{6}=@{6},{7}=@{7},{8}=@{8} WHERE {9}=@{9}", UserInfo.TABLENAME, UserInfo.PASSWORD, UserInfo.NAME, UserInfo.STATE, UserInfo.GIVENCREDIT, UserInfo.AVAILABLEGIVENCREDIT, UserInfo.SHARERATE, UserInfo.EMAIL, UserInfo.LASTCHANGEPWD, UserInfo.USERID); base.ExecuteNonQuery(sql, new SqlParameter(UserInfo.USERID, userInfo.UserId), new SqlParameter(UserInfo.PASSWORD, userInfo.Password), new SqlParameter(UserInfo.NAME, userInfo.Name), new SqlParameter(UserInfo.STATE, (int)userInfo.State), new SqlParameter(UserInfo.GIVENCREDIT, userInfo.GivenCredit), new SqlParameter(UserInfo.AVAILABLEGIVENCREDIT, userInfo.AvailableGivenCredit), new SqlParameter(UserInfo.SHARERATE, userInfo.ShareRate), new SqlParameter(UserInfo.EMAIL, userInfo.Email), new SqlParameter(UserInfo.LASTCHANGEPWD, userInfo.LastChangePwd)); }