예제 #1
0
        /// <summary>
        /// 查询卡通过传入的User查询。User:Id,Password,Identify
        /// </summary>
        /// <param name="user">传入登录信息,账号Id,Password,Identify</param>
        /// <returns></returns>
        public DepositorAndCard QueryCardsService(User user)
        {
            DepositorAndCard cards     = new DepositorAndCard(); //函数将要返回的对象
            Cards            card      = new Cards();            //接受查询结果数据
            Depositors       depositor = new Depositors();       //接受查询结果数据

            card = CardsAccess.QueryCardsData(user);
            if (card != null)            //查询不空
            {
                if (card.Cid != user.Id) //不是要查询的对象
                {
                    cards = null;
                }
                else
                {
                    cards.Duid  = (int)card.Cuid;//返回对象装入值
                    cards.Dcid  = card.Cid;
                    cards.Dname = idcardService.QueryService(card.Cicid).Icname;
                }
            }
            else
            {
                cards = null;
            }
            return(cards);
        }
예제 #2
0
        /// <summary>
        /// 根据封装登录信息的对象User(卡或储户)
        /// </summary>
        /// <param name="user">Id,Password,Identify</param>
        /// <returns>Depositors</returns>
        public DepositorAndCard QueryDepositorsService(User user)
        {
            Depositors       depositor  = new Depositors();       //接受返回值
            DepositorAndCard depositors = new DepositorAndCard(); //函数将要返回的对象

            depositor = accessDepositors.QueryDepositorsData(user);
            if (depositor != null)
            {
                if (depositor.Uid != user.Id)
                {
                    depositors = null;
                }
                else
                {
                    depositors.Duid = depositor.Uid;
                    depositors.Dcid = depositor.Ucid;
                    if (depositor.Ucid == null)
                    {
                        depositors.Dname = "您还没有绑定银行卡";
                    }
                    else
                    {
                        depositors.Dname = idcardService.QueryService(depositor.Uicid).Icname;
                    }
                }
            }
            else
            {
                depositors = null;
            }
            return(depositors);
        }
예제 #3
0
 /// <summary>
 /// 增加定期存款记录,并向FixBalance表添加存款数据,分别向fixbalanceService,recordsService提出需求。
 /// </summary>
 /// <param name="depositorAndCard">传入从cooike中获取的储户和储户银行卡信息。其对象为DepositorAndCard</param>
 /// <param name="fix">Fyear,FfixBalanceRate,FfixBalance,FfixBalance</param>
 /// <param name="mid">传入业务办理员账号Mid</param>
 public void AddFixBalanceService(DepositorAndCard depositorAndCard, Fixbalances fix, int mid)
 {
     fix.Fcid = (int)depositorAndCard.Dcid;
     fix.Fmid = mid;
     fixbalanceService.AddFixBalanceService(fix);
     recordsService.AddRecordsService(depositorAndCard, 0, 3, (double)fix.FfixBalance, mid); //此处的0没有意义
 }
예제 #4
0
        /// <summary>
        /// 增加活期存款记录Records,并向修改cards表中的数据,分别向cardServive,recordsService提出需求。
        /// </summary>
        /// <param name="dAndC">传入从cooike中获取的储户和储户银行卡信息。其对象为DepositorAndCard</param>
        /// <param name="card">CflowBalance</param>
        /// <param name="mid">传入业务办理员账号Mid</param>
        public void AddFlowBalanceService(DepositorAndCard dAndC, Cards card, int mid)
        {
            Cards cardss = new Cards();

            cardss.CflowBalance = cardServive.FlowBalanceService((int)dAndC.Dcid)[1] + card.CflowBalance;                                     //修改活期余额
            cardss.Cid          = (int)dAndC.Dcid;
            cardServive.UpdataFlowBalanceService(cardss);                                                                                     //更新
            recordsService.AddRecordsService(dAndC, cardServive.CheakCardsService((int)dAndC.Dcid).Cicid, 2, (double)card.CflowBalance, mid); //Records生成记录
        }
예제 #5
0
        /// <summary>
        /// 活期存款
        /// </summary>
        /// <param name="dAndC">cooike中当前账户信息:Cid,Uid,Name</param>
        /// <param name="money">前端出入ATM数钱器输入的活期存款金额</param>
        public void AddFloatBalanceService(DepositorAndCard dAndC, double money)
        {
            double moneys = money;//记录存款额

            //money += (double)CardsAccess.CardsData((int)dAndC.Dcid).CflowBalance;//将存款额和原来的余额加起来,等待更新
            money += FlowBalanceService((int)dAndC.Dcid)[1];
            CardsAccess.UpdateCardsData((int)dAndC.Dcid, money);                                                 //更新余额
            recordsService.AddRecordsService(dAndC, CardsAccess.CardsData((int)dAndC.Dcid).Cicid, 2, moneys, 0); //增加记录。0代表ATM
        }
예제 #6
0
 /// <summary>
 /// 接受页面参数,准备判断应该登录那个系统
 /// </summary>
 /// <param name="user">传入登录信息,账号Id,Password,Identify</param>
 /// <returns></returns>
 public IActionResult SignIn(User user)
 {
     user.Password = MD5Encrypt64(user.Password);//接到登录信息,给密码加密
     //此处分类,让储户,管理员分别登录到自己的界面,
     //还有ATM系统登录(利用卡号登录)
     #region 储户新版本
     if (user.Identify == "depository")
     {
         dAndC = depositorServive.QueryDepositorsService(user);//验证信息
         if (dAndC != null)
         {
             return(RedirectToAction("Login", "Depositors", dAndC));
         }
         else
         {
             return(Redirect(Url.Action("PasswordError", "Errors")));
         }
     }
     #endregion
     #region ATM-银行卡
     else if (user.Identify == "cards")
     {
         dAndC = cardServive.QueryCardsService(user);//验证信息
         if (dAndC != null)
         {
             return(RedirectToAction("Login", "Cards", dAndC));
         }
         else
         {
             return(Redirect(Url.Action("PasswordError", "Errors")));
         }
     }
     #endregion
     #region 管理员或行长
     else
     {
         manager = managerServive.QueryManagersService(user);//验证信息
         if (manager == null || manager.Mpassword != user.Password)
         {
             return(Redirect(Url.Action("PasswordError", "Errors")));
         }
         else if (user.Identify == "manager")
         {
             return(RedirectToAction("Login", "Managers", manager));
         }
         else
         {
             return(RedirectToAction("Login", "Governors", manager));
         }
     }
     #endregion
 }
예제 #7
0
        //2.将返回的信息进行处理,然后登陆系统主页
        /// <summary>
        /// 绑定银行卡并返回主页
        /// </summary>
        /// <param name="depositor">前端传入DepositorAndCard对象,属性:Dcid,Dicid</param>
        /// <returns></returns>
        public IActionResult UpdataBand(DepositorAndCard depositor)
        {
            DepositorAndCard depositor1 = new DepositorAndCard();

            depositor.Duid = DAndC().Duid;
            depositor1     = depositorServive.UpdataBandService(depositor);//绑定
            if (depositor1 != null)
            {
                return(RedirectToAction("Login", "Depositors", depositor1));
            }
            else
            {
                return(Redirect(Url.Action("DepositoryNotExistError", "Errors")));
            }
        }
예제 #8
0
        /// <summary>
        /// 接受前端页面的User信息
        /// </summary>
        /// <param name="card">User型对象:Id,Password</param>
        /// <returns></returns>
        public IActionResult BusinessLogin(User card)
        {
            card.Password = MD5Encrypt64(card.Password);//Md5加密
            DepositorAndCard dAndC = new DepositorAndCard();

            dAndC = managerServive.LoginCardsService(card);
            if (dAndC != null)//不空,证明验证成功
            {
                AddCooikeOfDAndC(dAndC);
                return(View());//返回业务办理页面
            }
            else
            {
                return(RedirectToAction("CardsLoginError", "Errors"));
            }
        }
예제 #9
0
        //2.将返回的信息进行处理,然后登陆系统主页
        /// <summary>
        /// 增加储户,并登录到储户系统
        /// </summary>
        /// <param name="depositor">传入前端页面填写的信息,参数对象Depositors:Uid,Uicid,Upassword </param>
        /// <returns></returns>
        public IActionResult AddLogin(Depositors depositor)
        {
            depositor.Upassword = MD5Encrypt64(depositor.Upassword);
            DepositorAndCard depositors = new DepositorAndCard();

            depositors = depositorServive.AddService(depositor);
            if (depositors != null)
            {
                cooikeAdd(depositors);
                return(RedirectToAction("Login", "Depositors", depositors));
            }
            else
            {
                return(Redirect(Url.Action("DepositoryExistError", "Errors")));
            }
        }
예제 #10
0
        /// <summary>
        /// 从浏览器获取DepositorAndCard对象的值:Dcid,Dname,Duid
        /// </summary>
        /// <returns>返回DepositorAndCard对象</returns>
        public DepositorAndCard DAndC()
        {
            DepositorAndCard dAndC = new DepositorAndCard();

            this.Request.Cookies.TryGetValue("Cid", out string Cid);
            int cid = int.Parse(Cid);

            this.Request.Cookies.TryGetValue("Uid", out string Uid);
            int uid = int.Parse(Uid);

            this.Request.Cookies.TryGetValue("Name", out string Name);
            string name = Name;

            dAndC.Dcid  = cid;
            dAndC.Dname = name;
            dAndC.Duid  = uid;
            return(dAndC);
        }
예제 #11
0
        /// <summary>
        /// ATM活期取款功能
        /// </summary>
        /// <param name="dAndC"></param>
        /// <param name="identity">传入操作类型,此处为1,为取款</param>
        /// <param name="money">传入取钱金额</param>
        /// <returns></returns>
        public bool DrawalService(DepositorAndCard dAndC, int identity, double money)
        {
            List <Double> record = new List <Double>();

            record = FlowBalanceService((int)dAndC.Dcid); //查询银行卡活期的余额
            if (record[1] >= money)                       //可取
            {
                //1.修改卡的表项,//取钱,
                record[1] = record[1] - money;                                                           //使用计算的余额减去要取余额。
                CardsAccess.UpdateCardsData((int)dAndC.Dcid, record[1]);                                 //更新余额
                AddRecordsService(dAndC, CardsAccess.CardsData((int)dAndC.Dcid).Cicid, identity, money); //增加记录
                return(true);
            }
            else
            {
                return(false);//不可取
            }
        }
예제 #12
0
        /// <summary>
        /// 判断是否增加储户成功
        /// </summary>
        /// <param name="depositor">表单填写的储户信息Uid,Uname,UPassword</param>
        /// <returns>DepositorAndCard</returns>
        public DepositorAndCard AddService(Depositors depositor)
        {
            DepositorAndCard depositors = new DepositorAndCard();
            Depositors       depositor1 = new Depositors();

            depositor1 = accessDepositors.CheakData(depositor.Uid);//查询有没有该储户
            if (depositor1 != null)
            {
                depositors = null;
            }
            else
            {
                accessDepositors.AddData(depositor);
                depositors.Duid  = depositor.Uid;
                depositors.Dname = "请绑定银行卡";
            }
            return(depositors);
        }
예제 #13
0
 /// <summary>
 /// 绑定银行卡,数据访问层,根据储户账号Uid,修改Ucid
 /// </summary>
 /// <param name="depositor">前端传入DepositorAndCard对象,属性:Duid,Dname,Dcid</param>
 public void UpdataBandData(DepositorAndCard depositor)
 {
     using (var dbContext = new bankContext())
     {
         //修改数据库信息最好有一些事务操作
         using (var transaction = dbContext.Database.BeginTransaction())
         {
             try
             {
                 var sql = @"Update Depositors SET Ucid =  {0},Uicid={1} WHERE Uid =  {2}";
                 dbContext.Database.ExecuteSqlCommand(sql, depositor.Dcid, depositor.Dicid, depositor.Duid);
                 dbContext.SaveChanges();
                 transaction.Commit();
             }
             catch (Exception e)
             {
                 Console.WriteLine(e.Message);
                 transaction.Rollback();
             }
         }
     }
 }
예제 #14
0
        /// <summary>
        /// 查询银行卡登录
        /// </summary>
        /// <param name="user">传入登录信息,账号Id,Password,Identify</param>
        /// <returns></returns>
        public DepositorAndCard QueryCardsData(User user)
        {
            Cards            card  = new Cards();            //接受查询到的数据
            DepositorAndCard dAndC = new DepositorAndCard(); //函数将返回DepositorAndCard对象

            using (var dbContext = new bankContext())
            {
                card = dbContext.Cards.FirstOrDefault(a => a.Cid == user.Id);
                if (card != null && card.Cpassword == user.Password)
                {
                    using (var viewContext = new ViewContext())
                    {
                        dAndC = viewContext.DepositorAndCard.FirstOrDefault(a => a.Dcid == card.Cid);//返回储户和该用户默认的卡号组成的视图
                    }
                }
                else
                {
                    dAndC = null;
                }
            }
            return(dAndC);
        }
예제 #15
0
 /// <summary>
 /// 记录表Records中增加记录,该层为访问层,传入参数:DepositorAndCard,操作类型int v,double money, int mid
 /// </summary>
 /// <param name="dAndC">传入从cooike中获取的储户和储户银行卡信息。其对象为DepositorAndCard</param>
 /// <param name="v">出入参数v代表类型,1:代表取款,2:代表活期存款,其他:代表定期存款。每次传入一个类型的值,其他两项字段默认为0</param>
 /// <param name="money">金额</param>
 /// <param name="mid">业务办理员</param>
 public void AddData(DepositorAndCard dAndC, int icid, int v, double money, int mid)
 {
     using (var dbContext = new bankContext())
     {
         //修改数据库信息最好有一些事务操作
         using (var transaction = dbContext.Database.BeginTransaction())
         {
             try
             {
                 Records records = new Records();
                 records.Rcid  = (int)dAndC.Dcid;
                 records.Ruid  = dAndC.Duid;
                 records.Rmid  = mid;
                 records.Ricid = icid;
                 if (v == 1)
                 {
                     records.Rwithdrawals = money;
                 }
                 else if (v == 2)
                 {
                     records.RflowDeposit = money;
                 }
                 else
                 {
                     records.RfixDeposit = money;
                 }
                 dbContext.Add(records);
                 dbContext.SaveChanges();
                 transaction.Commit();
             }
             catch (Exception e)
             {
                 Console.WriteLine(e.Message);
                 transaction.Rollback();
             }
         }
     }
 }
예제 #16
0
        /// <summary>
        /// 查询银行卡登录
        /// </summary>
        /// <param name="user">传入登录信息,账号Id,Password,Identify</param>
        /// <returns></returns>
        public DepositorAndCard QueryDepositorData(User user)
        {
            Depositors       depositors = new Depositors();       //接受查询到的数据
            DepositorAndCard dAndC      = new DepositorAndCard(); //函数将返回DepositorAndCard对象

            using (var dbContext = new bankContext())
            {
                depositors = dbContext.Depositors.FirstOrDefault(a => a.Uid == user.Id);
                //判断是否为正确
                if (depositors != null && depositors.Upassword == user.Password)
                {
                    using (var viewContext = new ViewContext())                                              //视图查询环境
                    {
                        dAndC = viewContext.DepositorAndCard.FirstOrDefault(a => a.Dcid == depositors.Ucid); //返回储户和该用户默认的卡号组成的视图
                    }
                }
                else
                {
                    dAndC = null;
                }
            }
            return(dAndC);
        }
예제 #17
0
        /// <summary>
        /// 储户绑定卡号,先找到该储户,然后找到该储户要绑定的银行卡,最后绑定
        /// </summary>
        /// <param name="depositor">前端传入DepositorAndCard对象,属性:Duid,Dname,Dcid</param>
        /// <returns></returns>
        public DepositorAndCard UpdataBandService(DepositorAndCard depositor)
        {
            Idcard           idcard     = new Idcard();
            DepositorAndCard DAndC      = new DepositorAndCard();    //返回对象
            Cards            card       = new Cards();               //接受返回数据
            Depositors       depositor1 = new Depositors();          //接受查询到的数据

            depositor1 = accessDepositors.CheakData(depositor.Duid); //查询有没有该储户
            if (depositor1 != null)                                  //有数据
            {
                if (depositor1.Uid == depositor.Duid)                //判断查找到的储户是不是我们要找的
                {
                    card = cardsService.CheakCardsService((int)depositor.Dcid);
                    if (card != null && card.Cuid == depositor.Duid && card.Cicid == depositor.Dicid) //判断查找到的银行卡是不是我们要找的
                    {
                        accessDepositors.UpdataBandData(depositor);                                   //更新绑定卡号
                        idcard      = idcardService.QueryService(card.Cicid);
                        DAndC.Dname = idcard.Icname;
                        DAndC.Dcid  = depositor.Dcid;
                        DAndC.Duid  = depositor.Duid;
                    }
                    else
                    {
                        DAndC = null;
                    }
                }
                else
                {
                    DAndC = null;
                }
            }
            else
            {
                DAndC = null;
            }
            return(DAndC);
        }
예제 #18
0
 /// <summary>
 /// 记录表Records中增加记录,业务逻辑层,CardsService对象将任务交给recordsService来处理
 /// </summary>
 /// <param name="dAndC">传入从cooike中获取的储户和储户银行卡信息。其对象为DepositorAndCard</param>
 /// <param name="v">出入参数v代表类型,1:代表取款,2:代表活期存款,其他:代表定期存款。每次传入一个类型的值,其他两项字段默认为0</param>
 /// <param name="money">金额</param>
 /// <param name="mid">业务办理员</param>
 public void AddRecordsService(DepositorAndCard dAndC, int Icid, int v, double money)
 {
     //此处零代表的是记录表中Mid填为0,代表取款是在ATM中进行的。
     recordsService.AddRecordsService(dAndC, Icid, v, money, 0);
 }
예제 #19
0
        //public static RecordsService recordsService = new RecordsService();
        #endregion

        #region “登录”功能 已实现
        /// <summary>
        /// “登录”功能,向cooike中加入信息
        /// </summary>
        /// <param name="card">传入DepositorAndCard类型的参数</param>
        /// <returns>返回主页,带参数</returns>
        public IActionResult Login(DepositorAndCard card)
        {
            AddCooikeOfDAndC(card);
            return(View("Login", card));
        }
예제 #20
0
        public static Transferrecords transferrecords    = new Transferrecords();//代码需求
        #endregion

        #region “登录”功能 已实现
        /// <summary>
        /// “登录”功能
        /// </summary>
        /// <param name="depositor">传入的是DepositorAndCard类型的数据</param>
        /// <returns>返回主页</returns>
        public IActionResult Login(DepositorAndCard depositor)
        {
            cooikeAdd(depositor);
            return(View("Login", depositor));
        }
예제 #21
0
 /// <summary>
 /// 向浏览器cooike中加入值DepositorAndCard
 /// </summary>
 /// <param name="card1">传入DepositorAndCard对象</param>
 public void cooikeAdd(DepositorAndCard depositor)
 {
     this.Response.Cookies.Append("Uid", depositor.Duid.ToString());
     this.Response.Cookies.Append("Cid", depositor.Dcid.ToString());
     this.Response.Cookies.Append("Name", depositor.Dname.ToString());
 }
예제 #22
0
 /// <summary>
 /// 向浏览器cooike中加入值DepositorAndCard
 /// </summary>
 /// <param name="card1">传入DepositorAndCard对象</param>
 public void AddCooikeOfDAndC(DepositorAndCard card1)
 {
     this.Response.Cookies.Append("Uid", card1.Duid.ToString());
     this.Response.Cookies.Append("Cid", card1.Dcid.ToString());
     this.Response.Cookies.Append("Name", card1.Dname.ToString());
 }
예제 #23
0
 /// <summary>
 /// 记录表Records中增加记录,业务逻辑层
 /// </summary>
 /// <param name="dAndC">传入从cooike中获取的储户和储户银行卡信息。其对象为DepositorAndCard</param>
 /// <param name="v">出入参数v代表类型,1:代表取款,2:代表活期存款,其他:代表定期存款。每次传入一个类型的值,其他两项字段默认为0</param>
 /// <param name="money">金额</param>
 /// <param name="mid">业务办理员,0代表ATM操作,1代表是储户操作,Rmid有值(管理员账号)时代表柜台管理员操作,默认为储户系统转账</param>
 public void AddRecordsService(DepositorAndCard dAndC, int icid, int v, double money, int mid)
 {
     accessRecords.AddData(dAndC, icid, v, money, mid);
 }