/// <summary>
/// 正常写日志；文件和数据库都写。
/// </summary>
/// <param name="logInfo"></param>
public void WriteLog(sys_log logInfo, LogMsgLevel logMsgLevel)
{
#region logInfo参数补充
if (logInfo == null)
logInfo = new sys_log();
logInfo.create_date = DateTime.Now;
logInfo.modify_date = logInfo.create_date;
logInfo.status = 0;
logInfo.local_ip = GetLocalIP();
logInfo.visitor_ip = GetClientIP();
#endregion
//log4net按配置等级来写文本日志
LogHelper.Write(JsonHelper.ToJson(logInfo), logMsgLevel);
//判断数据库日志级别，写数据库日志
var task = Task.Factory.StartNew(
() =>
{
try
{
logService.Add(logInfo);
}
catch (Exception ex)
{
LogHelper.Write("Famliy.Finance.BLL.LogBusiness.WriteLog() error.", ex);
}
});
}
public async Task<ActionResult> Login(LoginViewModel model, string returnUrl)
{
//BankModel bank = new BankModel();
//DBInit.Instance.Init(bank);
if (!ModelState.IsValid)
{
return View(model);
}
//var user = await MemberBLL.Instance.Find_SysUser(model.Email);
//if (user == null) ModelState.AddModelError("UserName", "用户名不存在");
var user = await MemberBLL.Instance.Get_SysUser(model.Email, Utils.MD5Encrypt(model.Password));
if (user != null )
{
ViewBag.LoginState = "已登录";
//FormsAuthentication.SetAuthCookie(model.Email, model.RememberMe);
var identity = MemberBLL.Instance.CreateIdentity(user, DefaultAuthenticationTypes.ApplicationCookie);
AuthenticationManager.SignOut(DefaultAuthenticationTypes.ApplicationCookie);
AuthenticationManager.SignIn(new AuthenticationProperties() { IsPersistent = model.RememberMe }, identity);
Session.Add(ConfigBusiness.Session_User_Key, user);
sys_log logInfo = new sys_log();
logInfo.user_id = user.user_id;
logInfo.user_name = user.user_name;
logInfo.interface_name = "Login";
logInfo.interface_param = JsonHelper.ToJson(model);
logInfo.result = ViewBag.LoginState;
LogBusiness.Instance.WriteLog(logInfo, GW.Utils.LogMsgLevel.Info);
return RedirectToLocal(returnUrl);
}
else { ViewBag.LoginState = "未登录"; }
AddErrors(new IdentityResult(new string[] { "登录失败" }));
sys_log logInfo2 = new sys_log();
logInfo2.user_id = user.user_id;
logInfo2.user_name = user.user_name;
logInfo2.interface_name = "Login";
logInfo2.interface_param = JsonHelper.ToJson(model);
logInfo2.result = ViewBag.LoginState;
LogBusiness.Instance.WriteLog(logInfo2,GW.Utils.LogMsgLevel.Info);
return View(model);
}
public void InitDb(BankModel context)
{
bank_family family = new bank_family(true);
family.family_name = "董瑞军的家";
family.family_nick_name = "My Sweet Home";
family.assets_money = 0;
family.assets_investment = 0;
family.assets_real = 0;
family.assets_total = 0;
family.assets_debt = 0;
family.assets_net = 0;
bank_family tfamily = context.bank_familys.Add(family);
context.SaveChanges();
sys_permission permission = new sys_permission(true);
permission.permission_name = "系统管理员";
permission.permission_url = "/Home/Index";
sys_permission tpermission = context.sys_permissions.Add(permission);
context.SaveChanges();
sys_role role = new sys_role(true);
role.role_name = "管理员";
role.role_desc = "管理员";
sys_role trole = context.sys_roles.Add(role);
context.SaveChanges();
sys_role_permission role_permission = new sys_role_permission(true);
role_permission.role_id = trole.role_id;
role_permission.permission_id = tpermission.permission_id;
role_permission.sys_role = trole;
role_permission.sys_permission = tpermission;
sys_role_permission trole_permission = context.sys_role_permissions.Add(role_permission);
context.SaveChanges();
sys_user user = new sys_user(true);
user.email = user.user_name = "*****@*****.**";
user.password = Utils.MD5Encrypt("dreign");
user.nick_name = "董瑞军";
user.birthday = DateTime.Now;
user.sex = false;
user.address = "上海市浦东新区";
user.age = 35;
user.family_name = "家长";
user.interest = "电影，音乐，运动";
user.last_login_ip = "127.0.0.1";
user.last_login_time = DateTime.Now;
user.phone = "1861xxxx091";
user.post = "200126";
user.qq = "27178846";
user.remark = "好想给国家多庆祝几天生日啊~";
user.weixin = "dreign";
user.user_desc = @"上海交通大学继续教育学院网络教育（原网络教育学院）,位于上海市华山路1954号交大徐汇校区。开展专升本\高升专\高升本学历教育，招生专业涵盖艺术\经济管理\船舶\计算机\英语\机电等十余个领域，总机：021-52389900。";
user.bank_family = tfamily;
sys_user tuser1 = context.sys_users.Add(user);
user = new sys_user(true);
user.email = user.user_name = "*****@*****.**";
user.password = Utils.MD5Encrypt("dreign");
user.nick_name = "魏晶晶";
user.birthday = DateTime.Now;
user.sex = true;
user.address = "上海市浦东新区";
user.age = 30;
user.family_name = "家长";
user.interest = "美食，音乐";
user.last_login_ip = "127.0.0.1";
user.last_login_time = DateTime.Now;
user.phone = "1861xxxx091";
user.post = "200126";
user.qq = "27178846";
user.remark = "好好学习天天向上~";
user.weixin = "dreign";
user.user_desc = @"东宫白庶子，南寺远禅师。何处遥相见，心无一事时。";
user.bank_family = tfamily;
sys_user tuser2 = context.sys_users.Add(user);
context.SaveChanges();
sys_user_role user_role = new sys_user_role(true);
user_role.user_name = tuser1.user_name;
user_role.role_id = trole.role_id;
user_role.sys_role = trole;
user_role.sys_user = tuser1;
sys_user_role tuser_role1 = context.sys_user_roles.Add(user_role);
user_role = new sys_user_role(true);
user_role.user_name = tuser2.user_name;
user_role.role_id = trole.role_id;
user_role.sys_role = trole;
user_role.sys_user = tuser2;
sys_user_role tuser_role2 = context.sys_user_roles.Add(user_role);
context.SaveChanges();
bank_account account = new bank_account(true);
account.user_id = tuser1.user_id;
account.user_name = tuser1.user_name;
account.money = 9500;
account.freezing = 0;
bank_account taccount1 = context.bank_accounts.Add(account);
account = new bank_account(true);
account.user_id = tuser2.user_id;
account.user_name = tuser2.user_name;
account.money = 0;
account.freezing = 0;
bank_account taccount2 = context.bank_accounts.Add(account);
context.SaveChanges();
//bank_family_user family_relation = new bank_family_user(true);
//family_relation.family_id = tfamily.family_id;
//family_relation.user_name = tuser1.user_name;
//family_relation.sys_user = tuser1;
//family_relation.bank_family = tfamily;
//bank_family_user tfamily_user1 = context.bank_family_users.Add(family_relation);
//family_relation = new bank_family_user(true);
//family_relation.family_id = tfamily.family_id;
//family_relation.user_name = tuser2.user_name;
//family_relation.sys_user = tuser2;
//family_relation.bank_family = tfamily;
//bank_family_user tfamily_user2 = context.bank_family_users.Add(family_relation);
context.SaveChanges();
sys_subject subject = new sys_subject(true);
subject.subject_id = 1;
subject.subject_name = "资产";
subject.subject_level = 1;
subject.subject_desc = "资产";
subject.parents_id = 0;
sys_subject tsubject = context.sys_subjects.Add(subject);
subject = new sys_subject(true);
subject.subject_id = 2;
subject.subject_name = "负债";
subject.subject_level = 1;
subject.subject_desc = "负债";
subject.parents_id = 0;
tsubject = context.sys_subjects.Add(subject);
subject = new sys_subject(true);
subject.subject_id = 3;
subject.subject_name = "货币资产";
subject.subject_level = 2;
subject.subject_desc = "资产";
subject.parents_id = 1;
tsubject = context.sys_subjects.Add(subject);
subject = new sys_subject(true);
subject.subject_id = 4;
subject.subject_name = "投资资产";
subject.subject_level = 2;
subject.subject_desc = "资产";
subject.parents_id = 1;
tsubject = context.sys_subjects.Add(subject);
subject = new sys_subject(true);
subject.subject_id = 5;
subject.subject_name = "实物资产";
subject.subject_level = 2;
subject.subject_desc = "资产";
subject.parents_id = 1;
tsubject = context.sys_subjects.Add(subject);
subject = new sys_subject(true);
subject.subject_id = 6;
subject.subject_name = "贷款";
subject.subject_level = 2;
subject.subject_desc = "负债";
subject.parents_id = 2;
tsubject = context.sys_subjects.Add(subject);
subject = new sys_subject(true);
subject.subject_id = 7;
subject.subject_name = "债务";
subject.subject_level = 2;
subject.subject_desc = "负债";
subject.parents_id = 2;
tsubject = context.sys_subjects.Add(subject);
subject = new sys_subject(true);
subject.subject_id = 8;
subject.subject_name = "日常家用";
subject.subject_level = 2;
subject.subject_desc = "负债";
subject.parents_id = 2;
tsubject = context.sys_subjects.Add(subject);
context.SaveChanges();
List<sys_subject> subjectList = new List<sys_subject>();
subject = new sys_subject(true) { subject_id = 9, subject_name = "现金与活期存款", subject_level = 3, subject_desc = "货币资产", parents_id = 3 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 10, subject_name = "活期存款", subject_level = 3, subject_desc = "货币资产", parents_id = 3 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 11, subject_name = "工资", subject_level = 3, subject_desc = "货币资产", parents_id = 3 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 12, subject_name = "其他货币资产", subject_level = 3, subject_desc = "货币资产", parents_id = 3 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 13, subject_name = "股票", subject_level = 3, subject_desc = "投资资产", parents_id = 4 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 14, subject_name = "债券", subject_level = 3, subject_desc = "投资资产", parents_id = 4 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 15, subject_name = "基金", subject_level = 3, subject_desc = "投资资产", parents_id = 4 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 16, subject_name = "银行理财", subject_level = 3, subject_desc = "投资资产", parents_id = 4 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 17, subject_name = "信托", subject_level = 3, subject_desc = "投资资产", parents_id = 4 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 18, subject_name = "互联网金融", subject_level = 3, subject_desc = "投资资产", parents_id = 4 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 19, subject_name = "保险", subject_level = 3, subject_desc = "投资资产", parents_id = 4 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 20, subject_name = "其他投资资产", subject_level = 3, subject_desc = "投资资产", parents_id = 4 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 21, subject_name = "自住房", subject_level = 3, subject_desc = "实物资产", parents_id = 5 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 22, subject_name = "投资房", subject_level = 3, subject_desc = "实物资产", parents_id = 5 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 23, subject_name = "机动车", subject_level = 3, subject_desc = "实物资产", parents_id = 5 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 24, subject_name = "家具", subject_level = 3, subject_desc = "实物资产", parents_id = 5 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 25, subject_name = "其他实物资产", subject_level = 3, subject_desc = "实物资产", parents_id = 5 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 26, subject_name = "住房贷款", subject_level = 3, subject_desc = "贷款", parents_id = 6 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 27, subject_name = "车辆贷款", subject_level = 3, subject_desc = "贷款", parents_id = 6 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 28, subject_name = "消费贷款", subject_level = 3, subject_desc = "贷款", parents_id = 6 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 29, subject_name = "助学贷款", subject_level = 3, subject_desc = "贷款", parents_id = 6 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 30, subject_name = "信用卡贷款", subject_level = 3, subject_desc = "贷款", parents_id = 6 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 31, subject_name = "其他贷款", subject_level = 3, subject_desc = "贷款", parents_id = 6 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 32, subject_name = "法人债务", subject_level = 3, subject_desc = "债务", parents_id = 7 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 33, subject_name = "个人债务", subject_level = 3, subject_desc = "债务", parents_id = 7 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 34, subject_name = "餐饮", subject_level = 3, subject_desc = "日常家用", parents_id = 8 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 35, subject_name = "水电煤", subject_level = 3, subject_desc = "日常家用", parents_id = 8 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 36, subject_name = "交通", subject_level = 3, subject_desc = "日常家用", parents_id = 8 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 37, subject_name = "通讯", subject_level = 3, subject_desc = "日常家用", parents_id = 8 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 38, subject_name = "医疗", subject_level = 3, subject_desc = "日常家用", parents_id = 8 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 39, subject_name = "衣服", subject_level = 3, subject_desc = "日常家用", parents_id = 8 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 40, subject_name = "社交", subject_level = 3, subject_desc = "日常家用", parents_id = 8 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 41, subject_name = "旅游", subject_level = 3, subject_desc = "日常家用", parents_id = 8 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 42, subject_name = "教育", subject_level = 3, subject_desc = "日常家用", parents_id = 8 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 43, subject_name = "日用品", subject_level = 3, subject_desc = "日常家用", parents_id = 8 }; subjectList.Add(subject);
subject = new sys_subject(true) { subject_id = 44, subject_name = "其他负债", subject_level = 3, subject_desc = "日常家用", parents_id = 8 }; subjectList.Add(subject);
context.sys_subjects.AddRange(subjectList);
context.SaveChanges();
bank_operate_log operate_log = new bank_operate_log(true);
operate_log.user_id = tuser1.user_id;
operate_log.user_name = tuser1.user_name;
operate_log.subject_id = 11;
operate_log.sys_subject = tsubject;
operate_log.money = 5000;
operate_log.subject_remark = "奖金";
operate_log.remark = "收入";
bank_operate_log toperate_log1 = context.bank_operate_logs.Add(operate_log);
operate_log = new bank_operate_log(true);
operate_log.user_id = tuser1.user_id;
operate_log.user_name = tuser1.user_name;
operate_log.subject_id = 35;
operate_log.money = -200;
operate_log.subject_remark = "水电煤";
operate_log.remark = "支出";
operate_log.sys_subject = tsubject;
toperate_log1 = context.bank_operate_logs.Add(operate_log);
operate_log = new bank_operate_log(true);
operate_log.user_id = tuser1.user_id;
operate_log.user_name = tuser1.user_name;
operate_log.subject_id = 37;
operate_log.money = -100;
operate_log.subject_remark = "手机费";
operate_log.remark = "支出";
operate_log.sys_subject = tsubject;
toperate_log1 = context.bank_operate_logs.Add(operate_log);
operate_log = new bank_operate_log(true);
operate_log.user_id = tuser1.user_id;
operate_log.user_name = tuser1.user_name;
operate_log.subject_id = 36;
operate_log.money = -200;
operate_log.subject_remark = "交通费";
operate_log.remark = "支出";
operate_log.sys_subject = tsubject;
toperate_log1 = context.bank_operate_logs.Add(operate_log);
operate_log = new bank_operate_log(true);
operate_log.user_id = tuser1.user_id;
operate_log.user_name = tuser1.user_name;
operate_log.subject_id = 11;
operate_log.money = 10000;
operate_log.subject_remark = "工资";
operate_log.remark = "收入";
operate_log.sys_subject = tsubject;
toperate_log1 = context.bank_operate_logs.Add(operate_log);
operate_log = new bank_operate_log(true);
operate_log.user_id = tuser1.user_id;
operate_log.user_name = tuser1.user_name;
operate_log.subject_id = 42;
operate_log.money = -4000;
operate_log.subject_remark = "学费";
operate_log.remark = "支出";
operate_log.sys_subject = tsubject;
toperate_log1 = context.bank_operate_logs.Add(operate_log);
operate_log = new bank_operate_log(true);
operate_log.user_id = tuser1.user_id;
operate_log.user_name = tuser1.user_name;
operate_log.subject_id = 44;
operate_log.money = -1000;
operate_log.subject_remark = "偿还信用卡";
operate_log.remark = "支出";
operate_log.sys_subject = tsubject;
toperate_log1 = context.bank_operate_logs.Add(operate_log);
context.SaveChanges();
sys_log log = new sys_log(true);
log.user_id = tuser1.user_id;
log.user_name = tuser1.user_name;
log.visitor_ip = "127.0.0.1";
log.local_ip = "127.0.0.1";
log.result = "OK";
var tlog = context.sys_logs.Add(log);
log = new sys_log(true);
log.user_id = tuser1.user_id;
log.user_name = tuser1.user_name;
log.visitor_ip = "127.0.0.1";
log.local_ip = "127.0.0.1";
log.result = "OK";
tlog = context.sys_logs.Add(log);
context.SaveChanges();
sys_user_log userlog = new sys_user_log(true);
userlog.user_id = tuser1.user_id;
userlog.user_name = tuser1.user_name;
userlog.login_time = DateTime.Now;
userlog.action = "Login";
userlog.action_desc = "登录";
var tuserlog = context.sys_user_logs.Add(userlog);
userlog = new sys_user_log(true);
userlog.user_id = tuser1.user_id;
userlog.user_name = tuser1.user_name;
userlog.login_time = DateTime.Now;
userlog.action = "Login";
userlog.action_desc = "登录";
tuserlog = context.sys_user_logs.Add(userlog);
context.SaveChanges();
}
public async Task<ActionResult> Register(RegisterViewModel model)
{
//ViewBag.Register = "欢迎注册";
if (ModelState.IsValid)
{
if (TempData["VerificationCode"] == null || TempData["VerificationCode"].ToString() != model.VerificationCode.ToUpper())
{
ModelState.AddModelError("VerificationCode", "验证码不正确");
return View(model);
}
var tuser = await MemberBLL.Instance.Find_SysUser(model.Email);
if (tuser != null && tuser.user_name == model.Email)
ModelState.AddModelError("UserName", "用户名已存在");
var user = new Famliy.Finance.Models.sys_user
{
user_name = model.Email,
email = model.Email,
password = Utils.MD5Encrypt(model.Password),
nick_name = model.NickName,
sex = model.Sex,
birthday = model.Birthday
//,sys_user_roles = new List<sys_user_role>(),
//bank_family = new bank_family()
};
var item = await MemberBLL.Instance.Add_SysUser(user);
if (item != null)
{
sys_log logInfo = new sys_log();
logInfo.user_id = user.user_id;
logInfo.user_name = user.user_name;
logInfo.interface_name = "Register";
logInfo.interface_param = JsonHelper.ToJson(model);
logInfo.result = "OK";
LogBusiness.Instance.WriteLog(logInfo, GW.Utils.LogMsgLevel.Info);
return RedirectToAction("Index", "Home");
}
else
{
sys_log logInfo = new sys_log();
logInfo.user_id = user.user_id;
logInfo.user_name = user.user_name;
logInfo.interface_name = "Register";
logInfo.interface_param = JsonHelper.ToJson(model);
logInfo.result = "Error";
LogBusiness.Instance.WriteLog(logInfo, GW.Utils.LogMsgLevel.Info);
AddErrors(new IdentityResult(new string[] { "注册失败" }));
}
}
// 如果我们进行到这一步时某个地方出错，则重新显示表单
return View(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(sys_log log)
{
string connStr = string.Empty;
logService.Add(log);
}