/// <summary>
/// 获取某一个实体
/// </summary>
/// <param name="StudentId">标识</param>
/// <returns>返回Entity</returns>
public static Entity.Join_Student Join_StudentEntityGet(int StudentId)
{
Entity.Join_Student info = new Entity.Join_Student();
DataTable dt = SqlDB.ExecuteDataset(strCon, CommandType.Text, "SELECT * FROM [Join_Student] WHERE StudentId = " + StudentId + ";").Tables[0];
if (dt.Rows.Count > 0)
{
info.StudentId = Basic.Utils.StrToInt(dt.Rows[0]["StudentId"].ToString(), 0);
info.StudentBank = dt.Rows[0]["StudentBank"].ToString();
info.StudentPass = dt.Rows[0]["StudentPass"].ToString();
info.StudenName = dt.Rows[0]["StudenName"].ToString();
info.StudentName = dt.Rows[0]["StudentName"].ToString();
info.Sex = Basic.Utils.StrToInt(dt.Rows[0]["Sex"].ToString(), 0);
info.CellTel = dt.Rows[0]["CellTel"].ToString();
info.CellPhone = dt.Rows[0]["CellPhone"].ToString();
info.CellPhoneCheck = Basic.Utils.StrToInt(dt.Rows[0]["CellPhoneCheck"].ToString(), 0);
info.Address = dt.Rows[0]["Address"].ToString();
info.SchoolName = dt.Rows[0]["SchoolName"].ToString();
info.IdNumber = dt.Rows[0]["IdNumber"].ToString();
info.CheckIdNumber = Basic.Utils.StrToInt(dt.Rows[0]["CheckIdNumber"].ToString(), 0);
info.IdNumberPic = dt.Rows[0]["IdNumberPic"].ToString();
info.BirthDate = dt.Rows[0]["BirthDate"].ToString();
info.RegisterWay = Basic.Utils.StrToInt(dt.Rows[0]["RegisterWay"].ToString(), 0);
info.RegisterOrigin = dt.Rows[0]["RegisterOrigin"].ToString();
info.DldId = Basic.Utils.StrToInt(dt.Rows[0]["DldId"].ToString(), 0);
info.UserCategory = Basic.Utils.StrToInt(dt.Rows[0]["UserCategory"].ToString(), 0);
info.PositionCase = dt.Rows[0]["PositionCase"].ToString();
info.IsPause = Basic.Utils.StrToInt(dt.Rows[0]["IsPause"].ToString(), 0);
info.Mail = dt.Rows[0]["Mail"].ToString();
info.QQ = dt.Rows[0]["QQ"].ToString();
info.About = dt.Rows[0]["About"].ToString();
info.Company = dt.Rows[0]["Company"].ToString();
info.MSN = dt.Rows[0]["MSN"].ToString();
info.ArtDialog = Basic.Utils.StrToInt(dt.Rows[0]["ArtDialog"].ToString(), 0);
info.FuQinPhone = dt.Rows[0]["FuQinPhone"].ToString();
info.MuQinPhone = dt.Rows[0]["MuQinPhone"].ToString();
info.WenLi = Basic.Utils.StrToInt(dt.Rows[0]["WenLi"].ToString(), 0);
info.BanJi = dt.Rows[0]["BanJi"].ToString();
info.BanZhuRen = dt.Rows[0]["BanZhuRen"].ToString();
info.ProvinceId = Basic.Utils.StrToInt(dt.Rows[0]["ProvinceId"].ToString(), 0);
info.CityId = Basic.Utils.StrToInt(dt.Rows[0]["CityId"].ToString(), 0);
info.CountyId = Basic.Utils.StrToInt(dt.Rows[0]["CountyId"].ToString(), 0);
info.IsAutoCreat = Basic.Utils.StrToInt(dt.Rows[0]["IsAutoCreat"].ToString(), 0);
info.BanZhuRenMobile = dt.Rows[0]["BanZhuRenMobile"].ToString();
info.StudentLevel = Basic.Utils.StrToInt(dt.Rows[0]["StudentLevel"].ToString(), 0);
info.GKYear = Basic.Utils.StrToInt(dt.Rows[0]["GKYear"].ToString(), 0);
info.RegisterTime = Basic.Utils.StrToDateTime(dt.Rows[0]["RegisterTime"].ToString());
return(info);
}
else
{
return(null);
}
}
/// <summary>
/// 调用存储过程修改一个
/// </summary>
/// <param name="info">实体对象</param>
/// <returns>更新成功返回ture，否则返回false</returns>
public static bool Join_StudentEdit(Entity.Join_Student info)
{
SqlParameter[] prams =
{
SqlDB.MakeInParam("@StudentId", SqlDbType.Int, 4, info.StudentId),
SqlDB.MakeInParam("@StudentBank", SqlDbType.VarChar, 50, info.StudentBank),
SqlDB.MakeInParam("@StudentPass", SqlDbType.VarChar, 50, info.StudentPass),
SqlDB.MakeInParam("@StudenName", SqlDbType.VarChar, 50, info.StudenName),
SqlDB.MakeInParam("@StudentName", SqlDbType.NVarChar, 50, info.StudentName),
SqlDB.MakeInParam("@Sex", SqlDbType.Int, 4, info.Sex),
SqlDB.MakeInParam("@CellTel", SqlDbType.VarChar, 50, info.CellTel),
SqlDB.MakeInParam("@CellPhone", SqlDbType.VarChar, 50, info.CellPhone),
SqlDB.MakeInParam("@CellPhoneCheck", SqlDbType.Int, 4, info.CellPhoneCheck),
SqlDB.MakeInParam("@Address", SqlDbType.VarChar, 100, info.Address),
SqlDB.MakeInParam("@SchoolName", SqlDbType.NVarChar, 150, info.SchoolName),
SqlDB.MakeInParam("@IdNumber", SqlDbType.VarChar, 18, info.IdNumber),
SqlDB.MakeInParam("@CheckIdNumber", SqlDbType.Int, 4, info.CheckIdNumber),
SqlDB.MakeInParam("@IdNumberPic", SqlDbType.NVarChar, 150, info.IdNumberPic),
SqlDB.MakeInParam("@BirthDate", SqlDbType.Char, 10, info.BirthDate),
SqlDB.MakeInParam("@RegisterWay", SqlDbType.Int, 4, info.RegisterWay),
SqlDB.MakeInParam("@RegisterOrigin", SqlDbType.VarChar, 500, info.RegisterOrigin),
SqlDB.MakeInParam("@DldId", SqlDbType.Int, 4, info.DldId),
SqlDB.MakeInParam("@UserCategory", SqlDbType.Int, 4, info.UserCategory),
SqlDB.MakeInParam("@PositionCase", SqlDbType.VarChar, 500, info.PositionCase),
SqlDB.MakeInParam("@RegisterTime", SqlDbType.DateTime, 8, info.RegisterTime),
SqlDB.MakeInParam("@IsPause", SqlDbType.Int, 4, info.IsPause),
SqlDB.MakeInParam("@Mail", SqlDbType.NVarChar, 150, info.Mail),
SqlDB.MakeInParam("@QQ", SqlDbType.NVarChar, 50, info.QQ),
SqlDB.MakeInParam("@About", SqlDbType.NVarChar, 0, info.About),
SqlDB.MakeInParam("@Company", SqlDbType.NVarChar, 50, info.Company),
SqlDB.MakeInParam("@MSN", SqlDbType.NVarChar, 50, info.MSN),
SqlDB.MakeInParam("@ArtDialog", SqlDbType.Int, 4, info.ArtDialog),
SqlDB.MakeInParam("@FuQinPhone", SqlDbType.NVarChar, 50, info.FuQinPhone),
SqlDB.MakeInParam("@MuQinPhone", SqlDbType.NVarChar, 50, info.MuQinPhone),
SqlDB.MakeInParam("@WenLi", SqlDbType.Int, 4, info.WenLi),
SqlDB.MakeInParam("@BanJi", SqlDbType.NVarChar, 100, info.BanJi),
SqlDB.MakeInParam("@BanZhuRen", SqlDbType.NVarChar, 100, info.BanZhuRen),
SqlDB.MakeInParam("@ProvinceId", SqlDbType.Int, 4, info.ProvinceId),
SqlDB.MakeInParam("@CityId", SqlDbType.Int, 4, info.CityId),
SqlDB.MakeInParam("@CountyId", SqlDbType.Int, 4, info.CountyId),
SqlDB.MakeInParam("@IsAutoCreat", SqlDbType.Int, 4, info.IsAutoCreat),
SqlDB.MakeInParam("@BanZhuRenMobile", SqlDbType.NVarChar, 100, info.BanZhuRenMobile),
SqlDB.MakeInParam("@StudentLevel", SqlDbType.Int, 4, info.StudentLevel),
SqlDB.MakeInParam("@GKYear", SqlDbType.Int, 4, info.GKYear),
};
int intReturnValue = 0;
intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "Join_StudentEdit", prams);
if (intReturnValue == 1)
{
return(true);
}
return(false);
}
/// <summary>
/// 暂停该值
/// </summary>
/// <param name="StudentId">自增id的值</param>
/// <returns>暂停成功返回ture，否则返回false</returns>
public static bool Join_StudentPause(Entity.Join_Student info)
{
int intReturnValue = 0;
intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.Text, "UPDATE [Join_Student] SET IsPause = " + info.IsPause + " WHERE StudentId = " + info.StudentId);
if (intReturnValue == 1)
{
return(true);
}
return(false);
}
/*使用账号和密码 检测 Join_Student 表*/
string Join_Student(string strBank, string strPwd)
{
//判定是否是注册账号
Entity.Join_Student infoStudent = DAL.TengXB.Join_Student.Join_StudentEntityGetBank(strBank, strPwd);
if (infoStudent != null) //是注册账号
{
//UserInfo
user.StudentId = infoStudent.StudentId; //UserInfo
user.ProvinceId = infoStudent.ProvinceId; //UserInfo
user.KeLei = infoStudent.WenLi; //UserInfo
user.GKYear = infoStudent.GKYear; //UserInfo
//JsonCallBack
infoJson.StudentName = infoStudent.StudentName; //学生姓名
infoJson.Bank = infoStudent.StudentBank; //账号
infoJson.Level = 1; //会员等级：普通注册用户
infoJson.Status = 4; //账号状态：注册用户
infoJson.ProvinceName = GetProvinceName(infoStudent.ProvinceId); //省份
//判定是否关闭
if (infoStudent.IsPause == 1)
{
infoJson.Status = 2;//账号状态：注册用户被关闭
}
else
{
//判定是否绑定高考卡了
Entity.GaoKaoCard infoGaoKaoCard = DAL.GaoKaoCard.GaoKaoCardEntityGetByStudentId(infoStudent.StudentId);
if (infoGaoKaoCard != null)
{
infoJson.Status = 3;
infoJson.Level = infoGaoKaoCard.CardLevel;
}
}
return(GetJson(infoJson));
}
else
{
//不是注册用户
return("");
}
}
/* intCardLevel：3表示高考卡；4表示会员卡 */
int ValidJoin_Student(int intCardLevel, int intStudentId, DateTime dtRegisterDate)
{
int provinceid = 0;
//判定该卡是否完善个人信息了
Entity.Join_Student infoStudent = DAL.Join_Student.Join_StudentEntityGet(intStudentId);
if (infoStudent != null) //已经完善过个人信息了
{
provinceid = infoStudent.ProvinceId;
user.KeLei = infoStudent.WenLi; //UserInfo
user.GKYear = infoStudent.GKYear; //UserInfo
user.StudentId = infoStudent.StudentId; //UserInfo
infoJson.StudentName = infoStudent.StudentName; //学生姓名
//一张完善过个人信息的正常的高考卡
infoJson.Status = intCardLevel;//高考卡3 会员卡4
}
else
{
//Student表中不存在数据 这时候 说明需要先去完善个人信息
infoJson.Status = 1;
}
//已经完善过个人信息的会员卡的话，需要去判定是否绑定了高考卡
if (infoJson.Status == 4)
{
Entity.GaoKaoCard infoGaoKaoCard = DAL.GaoKaoCard.GaoKaoCardEntityGetByStudentId(intStudentId);
if (infoGaoKaoCard != null)
{
infoJson.Status = 3;
infoJson.Level = infoGaoKaoCard.CardLevel;
}
}
return(provinceid);
}
