.NET 项目实训总结（二）

1.下面是 .NET项目实训的一些小模块功能，提现界面

提现的金额不能大于个人账户上的金额，而且提现的金额只能提现到添加好的银行卡上

还要输入提现密码才能提现
下面是相应的代码

public ActionResult BringCash(Fm_Fum_Bringup bringup)//提现
        {
            string strMsg = "提现出错!";
            try
            {
                //获取登录用户的用户ID
                int intUserId = Convert.ToInt32(Session["UserID"]);
                //根据登录用户ID查询银行卡表的用户ID，并且获取页面的提现账户查询银行卡的银行账号是否有数据
            

var tbbank = (from dbBankCard in myModels.Um_Usm_BankCard
                          where dbBankCard.UserID == intUserId &&
                          dbBankCard.BankAccount == bringup.NowAccount
                          select dbBankCard).Count();
            if (tbbank == 1)
            {
                int usablemoney = Convert.ToInt32(Session["UsableMoney"]);
                var nowrental = bringup.NowRental;
                if (usablemoney >= nowrental)
                {
                    //把当前登录用户ID 赋值给 提现表的用户ID
                    bringup.UserID = intUserId;
                    //给提现表的审核状态ID 赋值为 1
                    bringup.ExamineStateID = 1;
                    //获取当前时间
                    DateTime dateTimeNow = DateTime.Now;
                    //把当前时间 赋值给 提现时间
                    bringup.NowTime = dateTimeNow;

                    //查询出银行所在省
                    var varProvince = (from dbBankProvince in myModels.Jc_Bas_BankProvince
                                       where dbBankProvince.BankProvinceID == bringup.BankProvinceID
                                       select new { BankProvincename = dbBankProvince.BankProvincename.Trim() }).Single();
                    var ee = varProvince.BankProvincename;

                    //查询出银行所在市
                    var varCity = (from dbBankCity in myModels.Jc_Bas_BankCity
                                   where dbBankCity.BankCityID == bringup.BankCityID
                                   select new { BankCityname = dbBankCity.BankCityname.Trim() }).Single();
                    var ii = varCity.BankCityname;

                    //提现所在地 = 银行所在省 拼接 银行所在市
                    bringup.LiftNowLocation = ee + ii;

                    myModels.Fm_Fum_Bringup.Add(bringup);
                    myModels.SaveChanges();

                    strMsg = "提现成功!";
                }
                else
                {
                    strMsg = "提现余额不足!";
                }
            }
            else
            {
                strMsg = "提现账号与银行账号不匹配!";
            }
        }
        catch (Exception e)
        {
            Console.WriteLine(e);
            strMsg = "提现出错!";
        }
        return Json(strMsg, JsonRequestBehavior.AllowGet);
    }