/// <summary>
/// 验证会员登录名称和密码
/// </summary>
/// <param name="login"></param>
/// <returns></returns>
public DataSet Logon(MarriageLogin login)
{
SqlParameter[] parms =
{
data.MakeInParam("@UserName", SqlDbType.VarChar, 100, login.UserName),
data.MakeInParam("@PassWord", SqlDbType.VarChar, 30, login.PassWord),
};
return(data.RunProcReturn("Select * from tb_User where UserName=@UserName and PassWord=@PassWord", parms, "tb_User"));
}
/// <summary>
/// 添加会员注册信息（档案）
/// </summary>
/// <param name="login"></param>
/// <returns></returns>
public int Login(MarriageLogin login)
{
SqlParameter[] parms =
{
data.MakeInParam("@UserName", SqlDbType.VarChar, 100, login.UserName),
data.MakeInParam("@PassWord", SqlDbType.VarChar, 30, login.PassWord),
data.MakeInParam("@NickName", SqlDbType.VarChar, 30, login.NickName),
data.MakeInParam("@Sex", SqlDbType.VarChar, 10, login.Sex),
data.MakeInParam("@BirthDay", SqlDbType.VarChar, 20, login.BirthDay),
data.MakeInParam("@Address", SqlDbType.VarChar, 150, login.Address),
data.MakeInParam("@Stature", SqlDbType.VarChar, 10, login.Stature),
data.MakeInParam("@Avoirdupois", SqlDbType.VarChar, 10, login.Avoirdupois),
data.MakeInParam("@Education", SqlDbType.VarChar, 10, login.Education),
data.MakeInParam("@Earning", SqlDbType.VarChar, 20, login.Earning),
data.MakeInParam("@Nation", SqlDbType.VarChar, 10, login.Nation),
data.MakeInParam("@BloodType", SqlDbType.VarChar, 6, login.BloodType),
data.MakeInParam("@Looks", SqlDbType.VarChar, 50, login.Looks),
data.MakeInParam("@Metier", SqlDbType.VarChar, 20, login.Metier),
data.MakeInParam("@Housing", SqlDbType.VarChar, 20, login.Housing),
data.MakeInParam("@BuyCar", SqlDbType.VarChar, 20, login.BuyCar),
data.MakeInParam("@Marriage", SqlDbType.VarChar, 20, login.Marriage),
data.MakeInParam("@HaveBaby", SqlDbType.VarChar, 6, login.HaveBaby),
data.MakeInParam("@HavingBaby", SqlDbType.VarChar, 200, login.HavingBaby),
data.MakeInParam("@Smoke", SqlDbType.VarChar, 6, login.Smoke),
data.MakeInParam("@Drink", SqlDbType.VarChar, 6, login.Drink),
data.MakeInParam("@UseLanguage", SqlDbType.VarChar, 50, login.UseLanguage),
data.MakeInParam("@SexLike", SqlDbType.VarChar, 500, login.SexLike),
data.MakeInParam("@FriendCome", SqlDbType.VarChar, 150, login.FriendCome),
data.MakeInParam("@FriendAgeStar", SqlDbType.Int, 4, login.FriendAgeStar),
data.MakeInParam("@FriendAgeEnd", SqlDbType.Int, 4, login.FriendAgeEnd),
data.MakeInParam("@FriendStatureStar", SqlDbType.Int, 4, login.FriendStatureStar),
data.MakeInParam("@FriendStatureEnd", SqlDbType.Int, 4, login.FriendStatureEnd),
data.MakeInParam("@FriendMarriage", SqlDbType.VarChar, 10, login.FriendMarriage),
};
int i = data.RunProc("INSERT INTO tb_User (UserName, PassWord,NickName, Sex, BirthDay," +
" Address, Stature, Avoirdupois, Education, Earning, " +
"Nation, BloodType, Looks, Metier,Housing ,BuyCar ,Marriage ,HaveBaby ," +
"HavingBaby ,Smoke ,Drink ,UseLanguage ,SexLike," +
"FriendCome,FriendAgeStar,FriendAgeEnd,FriendStatureStar,FriendStatureEnd,FriendMarriage" +
") VALUES (@UserName, @PassWord, @NickName, @Sex, @BirthDay, @Address, @Stature, @Avoirdupois, @Education, @Earning, " +
"@Nation, @BloodType, @Looks, @Metier,@Housing ,@BuyCar ,@Marriage ,@HaveBaby ,@HavingBaby ,@Smoke ,@Drink ,@UseLanguage ,@SexLike," +
"@FriendCome,@FriendAgeStar,@FriendAgeEnd,@FriendStatureStar,@FriendStatureEnd,@FriendMarriage)", parms);
return(i);
}
/// <summary>
/// 修改会员档案信息
/// </summary>
/// <param name="login"></param>
/// <returns></returns>
public int LoginUpdate(MarriageLogin login)
{
SqlParameter[] parms =
{
data.MakeInParam("@UserName", SqlDbType.VarChar, 100, login.UserName),
data.MakeInParam("@PassWord", SqlDbType.VarChar, 30, login.PassWord),
data.MakeInParam("@NickName", SqlDbType.VarChar, 30, login.NickName),
//data.MakeInParam("@Sex",SqlDbType.VarChar,10,login.Sex),
//data.MakeInParam("@BirthDay",SqlDbType.VarChar,20,login.BirthDay),
data.MakeInParam("@Address", SqlDbType.VarChar, 150, login.Address),
data.MakeInParam("@Stature", SqlDbType.VarChar, 10, login.Stature),
data.MakeInParam("@Avoirdupois", SqlDbType.VarChar, 10, login.Avoirdupois),
data.MakeInParam("@Education", SqlDbType.VarChar, 10, login.Education),
data.MakeInParam("@Earning", SqlDbType.VarChar, 20, login.Earning),
data.MakeInParam("@Nation", SqlDbType.VarChar, 10, login.Nation),
data.MakeInParam("@BloodType", SqlDbType.VarChar, 6, login.BloodType),
data.MakeInParam("@Looks", SqlDbType.VarChar, 50, login.Looks),
data.MakeInParam("@Metier", SqlDbType.VarChar, 20, login.Metier),
data.MakeInParam("@Housing", SqlDbType.VarChar, 20, login.Housing),
data.MakeInParam("@BuyCar", SqlDbType.VarChar, 20, login.BuyCar),
data.MakeInParam("@Marriage", SqlDbType.VarChar, 20, login.Marriage),
data.MakeInParam("@HaveBaby", SqlDbType.VarChar, 6, login.HaveBaby),
data.MakeInParam("@HavingBaby", SqlDbType.VarChar, 200, login.HavingBaby),
data.MakeInParam("@Smoke", SqlDbType.VarChar, 6, login.Smoke),
data.MakeInParam("@Drink", SqlDbType.VarChar, 6, login.Drink),
data.MakeInParam("@UseLanguage", SqlDbType.VarChar, 50, login.UseLanguage),
data.MakeInParam("@SexLike", SqlDbType.VarChar, 500, login.SexLike),
data.MakeInParam("@FriendCome", SqlDbType.VarChar, 150, login.FriendCome),
data.MakeInParam("@FriendAgeStar", SqlDbType.Int, 4, login.FriendAgeStar),
data.MakeInParam("@FriendAgeEnd", SqlDbType.Int, 4, login.FriendAgeEnd),
data.MakeInParam("@FriendStatureStar", SqlDbType.Int, 4, login.FriendStatureStar),
data.MakeInParam("@FriendStatureEnd", SqlDbType.Int, 4, login.FriendStatureEnd),
data.MakeInParam("@FriendMarriage", SqlDbType.VarChar, 10, login.FriendMarriage),
};
int i = data.RunProc("Update tb_User set " + (login.PassWord == "" ? "" : "PassWord=@PassWord,") + "NickName=@NickName, Address=@Address," +
" Stature=@Stature, Avoirdupois=@Avoirdupois, Education=@Education, Earning=@Earning, " +
"Nation= @Nation, BloodType= @BloodType, Looks= @Looks, Metier= @Metier,Housing = @Housing ," +
"BuyCar =@BuyCar ,Marriage =@Marriage ,HaveBaby =@HaveBaby ,HavingBaby =@HavingBaby ," +
"Smoke =@Smoke ,Drink =@Drink ,UseLanguage = @UseLanguage,SexLike = @SexLike," +
"FriendCome =@FriendCome ,FriendAgeStar =@FriendAgeStar ,FriendAgeEnd =@FriendAgeEnd ," +
"FriendStatureStar =@FriendStatureStar ,FriendStatureEnd =@FriendStatureEnd ,FriendMarriage =@FriendMarriage where UserName=@UserName", parms);
return(i);
}
/// <summary>
/// 按指定条件查询会员信息
/// </summary>
/// <param name="login"></param>
/// <returns></returns>
public DataSet SelcetUserResult(MarriageLogin login, bool checkPhoto)
{
//设置sql语句需要的参数
SqlParameter[] parms =
{
data.MakeInParam("@Sex", SqlDbType.VarChar, 4, login.Sex),
data.MakeInParam("@FriendAgeStar", SqlDbType.Int, 4, login.FriendAgeStar),
data.MakeInParam("@FriendAgeEnd", SqlDbType.Int, 4, login.FriendAgeEnd),
data.MakeInParam("@Address", SqlDbType.VarChar, 100, "%" + login.Address + "%"),
};
if (checkPhoto) //显示查询结果有相片交友信息
//根据参数执行sql语句
{
return(data.RunProcReturn("select * from tb_User where Sex=@Sex and DATEDIFF(year, Birthday, getdate()) >= @FriendAgeStar and DATEDIFF(year, Birthday, getdate()) <= @FriendAgeEnd and Address like @Address and photoPath <> '~/JiaoYou/Photo/nophoto.gif'", parms, "tb_User"));
}
else
{
return(data.RunProcReturn("select * from tb_User where Sex=@Sex and DATEDIFF(year, Birthday, getdate()) >= @FriendAgeStar and DATEDIFF(year, Birthday, getdate()) <= @FriendAgeEnd and Address like @Address", parms, "tb_User"));
}
}
