Esempio n. 1
0
        /// <summary>
        /// 调用存储过程修改一个
        /// </summary>
        /// <param name="info">实体对象</param>
        /// <returns>更新成功返回ture,否则返回false</returns>
        public static bool GaoKaoCardEdit(Entity.GaoKaoCard info)
        {
            SqlParameter[] prams =
            {
                SqlDB.MakeInParam("@ID",               SqlDbType.Int,        4, info.ID),
                SqlDB.MakeInParam("@KaHao",            SqlDbType.NVarChar,  50, info.KaHao),
                SqlDB.MakeInParam("@MiMa",             SqlDbType.NVarChar,  50, info.MiMa),
                SqlDB.MakeInParam("@StudentId",        SqlDbType.Int,        4, info.StudentId),
                SqlDB.MakeInParam("@ProvinceId",       SqlDbType.Int,        4, info.ProvinceId),
                SqlDB.MakeInParam("@Belong",           SqlDbType.Int,        4, info.Belong),
                SqlDB.MakeInParam("@DianId",           SqlDbType.Int,        4, info.DianId),
                SqlDB.MakeInParam("@CardLevel",        SqlDbType.Int,        4, info.CardLevel),
                SqlDB.MakeInParam("@IsPause",          SqlDbType.Int,        4, info.IsPause),
                SqlDB.MakeInParam("@RegisterDate",     SqlDbType.DateTime,   8, info.RegisterDate),
                SqlDB.MakeInParam("@AllowChangeCount", SqlDbType.Int,        4, info.AllowChangeCount),
                SqlDB.MakeInParam("@HaveChangeCount",  SqlDbType.Int,        4, info.HaveChangeCount),
                SqlDB.MakeInParam("@EndTime",          SqlDbType.DateTime,   8, info.EndTime),
                SqlDB.MakeInParam("@Memo",             SqlDbType.NVarChar, 500, info.Memo),
                SqlDB.MakeInParam("@DingDanHao",       SqlDbType.NVarChar, 100, info.DingDanHao),
            };
            int intReturnValue = 0;

            intReturnValue = SqlDB.ExecuteNonQuery(CommandType.StoredProcedure, "GaoKaoCardEdit", prams);
            if (intReturnValue == 1)
            {
                return(true);
            }
            return(false);
        }
Esempio n. 2
0
        public static Entity.GaoKaoCard GaoKaoCardEntityGetByKaHao(string strKaoHao)
        {
            Entity.GaoKaoCard info = new Entity.GaoKaoCard();
            DataTable         dt   = SqlDB.ExecuteDataset(CommandType.Text, "SELECT * FROM [GaoKaoCard] WHERE KaHao = '" + strKaoHao + "'").Tables[0];

            if (dt.Rows.Count > 0)
            {
                info.ID               = Basic.Utils.StrToInt(dt.Rows[0]["ID"].ToString(), 0);
                info.KaHao            = dt.Rows[0]["KaHao"].ToString();
                info.MiMa             = dt.Rows[0]["MiMa"].ToString();
                info.StudentId        = Basic.Utils.StrToInt(dt.Rows[0]["StudentId"].ToString(), 0);
                info.ProvinceId       = Basic.Utils.StrToInt(dt.Rows[0]["ProvinceId"].ToString(), 0);
                info.Belong           = Basic.Utils.StrToInt(dt.Rows[0]["Belong"].ToString(), 0);
                info.DianId           = Basic.Utils.StrToInt(dt.Rows[0]["DianId"].ToString(), 0);
                info.CardLevel        = Basic.Utils.StrToInt(dt.Rows[0]["CardLevel"].ToString(), 0);
                info.IsPause          = Basic.Utils.StrToInt(dt.Rows[0]["IsPause"].ToString(), 0);
                info.AllowChangeCount = Basic.Utils.StrToInt(dt.Rows[0]["AllowChangeCount"].ToString(), 0);
                info.HaveChangeCount  = Basic.Utils.StrToInt(dt.Rows[0]["HaveChangeCount"].ToString(), 0);
                info.Memo             = dt.Rows[0]["Memo"].ToString();
                info.DingDanHao       = dt.Rows[0]["DingDanHao"].ToString();

                info.EndTime      = Basic.TypeConverter.StrToDateTime(dt.Rows[0]["DingDanHao"].ToString());
                info.RegisterDate = Basic.TypeConverter.StrToDateTime(dt.Rows[0]["RegisterDate"].ToString());

                info.IsArt = Basic.Utils.StrToInt(dt.Rows[0]["IsArt"].ToString(), 0);

                return(info);
            }
            else
            {
                return(null);
            }
        }
Esempio n. 3
0
        //空或者0:账号或者密码错误
        //1:未完善个人信息:目前只有账号和密码
        //2:账号被完全关闭账号:卡用户的卡已关闭或者过期;注册用户被关闭
        //3:高考卡用户:可以正常使用系统的账户
        //4.注册用户或者会员卡用户(如果是先注册,后绑定的报考卡,那么报考卡过期之后该用户又是一个普通注册用户了)

        /*使用账号和密码 检测 GaoKaoCard 表*/
        string GaoKaoCard(string strBank, string strPwd)
        {
            #region 针对卡号段  '19140600001' and '19140610000'  作如下处理

            if (strBank.StartsWith("191406"))
            {
                string strBank2 = strBank.Substring(6);
                int    intBank  = Basic.TypeConverter.StrToInt(strBank2, 0);
                if (intBank >= 1 && intBank <= 10000)
                {
                    strBank += DAL.AnalysisArea.GetProvinceIdByIp();
                }
            }

            #endregion

            Entity.GaoKaoCard infoCard = DAL.GaoKaoCard.GaoKaoCardEntityGetByKaHao(strBank, strPwd);
            if (infoCard != null)
            {
                //UserInfo
                user.ProvinceId = infoCard.ProvinceId;//UserInfo

                //JsonCallBack
                infoJson.Bank         = infoCard.KaHao;                       //账号
                infoJson.Level        = infoCard.CardLevel;                   //会员等级
                infoJson.ProvinceName = GetProvinceName(infoCard.ProvinceId); //省份

                //Basic.CookieHelper.WriteCookie("EndTime", infoCard.EndTime.ToString());
                //Basic.CookieHelper.WriteCookie("EndTime222", DateTime.Now.ToString());
                //判定是否已经关闭或者过期
                if (infoCard.IsPause == 1 || DateTime.Compare(DateTime.Now, infoCard.EndTime) > 0)
                {
                    infoJson.Status = 2;//高考卡已关闭或者过期
                }
                else
                {
                    //没有关闭也没有过期的一张卡,等待接下来的处理

                    //通过StudentId 验证Join_Student
                    int ProvinceId = ValidJoin_Student(3, infoCard.StudentId, infoCard.RegisterDate);
                    if (infoCard.ProvinceId == 0)
                    {
                        infoCard.ProvinceId = ProvinceId;
                        DAL.GaoKaoCard.GaoKaoCardEdit(infoCard);
                    }
                }

                return(GetJson(infoJson));
            }
            else
            {
                return("");
            }
        }
Esempio n. 4
0
        /// <summary>
        /// 暂停该值
        /// </summary>
        /// <param name="ID">自增id的值</param>
        /// <returns>暂停成功返回ture,否则返回false</returns>
        public static bool GaoKaoCardPause(Entity.GaoKaoCard info)
        {
            int intReturnValue = 0;

            intReturnValue = SqlDB.ExecuteNonQuery(CommandType.Text, "UPDATE [GaoKaoCard] SET IsPause = " + info.IsPause + "  WHERE ID =  " + info.ID);
            if (intReturnValue == 1)
            {
                return(true);
            }
            return(false);
        }
Esempio n. 5
0
        public static bool GaoKaoCardHaveChangeCount(Entity.GaoKaoCard info)
        {
            int intReturnValue = 0;

            intReturnValue = SqlDB.ExecuteNonQuery(CommandType.Text, "UPDATE [GaoKaoCard] SET HaveChangeCount = " + info.HaveChangeCount + "  WHERE ID =  " + info.ID);
            if (intReturnValue == 1)
            {
                return(true);
            }
            return(false);
        }
Esempio n. 6
0
        /*使用账号和密码 检测 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("");
            }
        }
Esempio n. 7
0
 /// <summary>
 /// 调用存储过程增加一个
 /// </summary>
 /// <param name="info">实体对象</param>
 /// <returns>正常返回大于 0 的自增id, 0代表重复,否则返回-1</returns>
 public static int GaoKaoCardAdd(Entity.GaoKaoCard info)
 {
     SqlParameter[] prams =
     {
         SqlDB.MakeInParam("@KaHao",            SqlDbType.NVarChar,  50, info.KaHao),
         SqlDB.MakeInParam("@MiMa",             SqlDbType.NVarChar,  50, info.MiMa),
         SqlDB.MakeInParam("@StudentId",        SqlDbType.Int,        4, info.StudentId),
         SqlDB.MakeInParam("@ProvinceId",       SqlDbType.Int,        4, info.ProvinceId),
         SqlDB.MakeInParam("@Belong",           SqlDbType.Int,        4, info.Belong),
         SqlDB.MakeInParam("@DianId",           SqlDbType.Int,        4, info.DianId),
         SqlDB.MakeInParam("@CardLevel",        SqlDbType.Int,        4, info.CardLevel),
         SqlDB.MakeInParam("@IsPause",          SqlDbType.Int,        4, info.IsPause),
         //	SqlDB.MakeInParam("@RegisterDate", SqlDbType.DateTime, 8, info.RegisterDate),
         SqlDB.MakeInParam("@AllowChangeCount", SqlDbType.Int,        4, info.AllowChangeCount),
         SqlDB.MakeInParam("@HaveChangeCount",  SqlDbType.Int,        4, info.HaveChangeCount),
         SqlDB.MakeInParam("@EndTime",          SqlDbType.DateTime,   8, info.EndTime),
         SqlDB.MakeInParam("@Memo",             SqlDbType.NVarChar, 500, info.Memo),
         SqlDB.MakeInParam("@DingDanHao",       SqlDbType.NVarChar, 100, info.DingDanHao),
     };
     return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "GaoKaoCardAdd", prams).ToString(), -1));
 }
Esempio n. 8
0
        public static Entity.GaoKaoCard GaoKaoCardEntityGetByKaHao(string strKaoHao, string strMiMa)
        {
            Entity.GaoKaoCard info = new Entity.GaoKaoCard();

            SqlParameter[] prams =
            {
                SqlDB.MakeInParam("@KaHao", SqlDbType.NVarChar, 500, strKaoHao),
                SqlDB.MakeInParam("@MiMa",  SqlDbType.NVarChar,  50, strMiMa),
            };
            DataTable dt = SqlDB.ExecuteDataset(CommandType.StoredProcedure, "GaoKaoCardEntityGet", prams).Tables[0];

            //DataTable dt = SqlDB.ExecuteDataset(CommandType.Text, "SELECT * FROM [GaoKaoCard] WHERE KaHao = '" + strKaoHao + "' AND MiMa = '" + strMiMa + "'").Tables[0];
            if (dt.Rows.Count > 0)
            {
                info.ID               = Basic.Utils.StrToInt(dt.Rows[0]["ID"].ToString(), 0);
                info.KaHao            = dt.Rows[0]["KaHao"].ToString();
                info.MiMa             = dt.Rows[0]["MiMa"].ToString();
                info.StudentId        = Basic.Utils.StrToInt(dt.Rows[0]["StudentId"].ToString(), 0);
                info.ProvinceId       = Basic.Utils.StrToInt(dt.Rows[0]["ProvinceId"].ToString(), 0);
                info.Belong           = Basic.Utils.StrToInt(dt.Rows[0]["Belong"].ToString(), 0);
                info.DianId           = Basic.Utils.StrToInt(dt.Rows[0]["DianId"].ToString(), 0);
                info.CardLevel        = Basic.Utils.StrToInt(dt.Rows[0]["CardLevel"].ToString(), 0);
                info.IsPause          = Basic.Utils.StrToInt(dt.Rows[0]["IsPause"].ToString(), 0);
                info.AllowChangeCount = Basic.Utils.StrToInt(dt.Rows[0]["AllowChangeCount"].ToString(), 0);
                info.HaveChangeCount  = Basic.Utils.StrToInt(dt.Rows[0]["HaveChangeCount"].ToString(), 0);
                info.Memo             = dt.Rows[0]["Memo"].ToString();
                info.DingDanHao       = dt.Rows[0]["DingDanHao"].ToString();

                info.EndTime      = Basic.TypeConverter.StrToDateTime(dt.Rows[0]["EndTime"].ToString());
                info.RegisterDate = Basic.TypeConverter.StrToDateTime(dt.Rows[0]["RegisterDate"].ToString());

                info.IsArt = Basic.Utils.StrToInt(dt.Rows[0]["IsArt"].ToString(), 0);

                return(info);
            }
            else
            {
                return(null);
            }
        }
Esempio n. 9
0
        /* 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);
        }