public ActionResult ChangePassword(string oldpassword, string password, string confirmPassword) { int id = BLL.UserInfo.CurUser.Id; if(password!=confirmPassword) { ModelState.AddModelError("confirmPassword","两次密码不一致"); return View(); } if(password.Trim()=="") { ModelState.AddModelError("password", "密码不能为空"); return View(); } using (OUContext db = new OUContext()) { OUDAL.Supplier supplier = (from o in db.Suppliers where o.Id == id select o).First(); if (supplier.Password == oldpassword) { supplier.Password = password; db.SaveChanges(); return Redirect("~/Supplier/SupplierView"); } else { ModelState.AddModelError("oldpassword", "旧密码错误"); } }return View(); }
public static void AddLog(OUContext db,string person, int id, string logClass, string logAction, string info) { AccessLog a = new AccessLog(); a.KeyId = id; a.AccessClass = logClass; a.AccessAction = logAction; a.AccessInfo = info; a.AccessTime = DateTime.Now; a.AccessPerson = person; db.AccessLogs.Add(a); db.SaveChanges(); }
public static void Add(decimal rate,DateTime date) { using (OUContext db = new OUContext()) { var list = (from o in db.ExchangeRates where o.EndDate == null select o).ToList(); list.ForEach(o=>o.EndDate=date.AddDays(-1)); ExchangeRate r = new ExchangeRate {Rate = rate, BeginDate = date}; db.ExchangeRates.Add(r); db.SaveChanges(); } }
public ActionResult ChangePassword(string oldpassword,string password) { int id = BLL.UserInfo.CurUser.Id; if(password.Length==0) { ModelState.AddModelError("password", "密码不能为空"); } using (OUContext db = new OUContext()) { SystemUser user = (from o in db.SystemUsers where o.Id == id select o).First(); if(user.CheckPassword(oldpassword)==true) { user.Password = password; user.Save(db); db.SaveChanges(); return Redirect("ChangePasswordSuccess"); } else { ModelState.AddModelError("oldpassword", "旧密码错误"); } }return View(); }
public ActionResult ChangePassword(string oldpassword, string password) { int id = BLL.UserInfo.CurUser.Id; if (password.Length == 0) { ModelState.AddModelError("password", "password can not be empty"); } using (OUContext db = new OUContext()) { Client s = (from o in db.Clients where o.Id == id select o).First(); if (s.Password==oldpassword) { s.Password = password; db.SaveChanges(); return Redirect("ChangePasswordSuccess"); } else { ModelState.AddModelError("oldpassword", "wrong old password"); } } return View(); }
public ActionResult SupplierEdit( FormCollection collection) { int id = 0; int.TryParse(System.Web.HttpContext.Current.User.Identity.Name, out id); OUContext db = new OUContext(); Supplier s = (from o in db.Suppliers where o.Id == id select o).FirstOrDefault(); if(s==null) { return View(s); } if(s.State==(int)SupplierState.往来) { return View("ShowError", "", "已是往来供应商,不能修改资料"); } //collection.Remove(""); TryUpdateModel(s, "", new string[] { }, new string[] { "Name", "Password", "Level", "State","AuditRemark" ,"AccessCode"}, collection); if (ModelState.IsValid) { s.Save(db); db.SaveChanges(); if(id==0) { BLL.Utilities.AddLog(s.Id,Supplier.LogClass, "创建", ""); } else { BLL.Utilities.AddLog(s.Id, Supplier.LogClass, "修改", ""); } return Redirect("SupplierView" ); } return View(s); }
public string Syn() { OUContext db=new OUContext(); var users = (from o in db.SystemUsers select o).ToList(); string sqlUsers = @" select a.nvarchar8 as company ,a.nvarchar21 as department ,a.nvarchar15 as subdepartment ,a.nvarchar7 as email,a.nvarchar6 as name ,nvarchar20 as loginname,nvarchar10 as title from AllUserData a where a.tp_ListId ='10236E7F-298D-4247-BEE3-1FEB8738784D' and nvarchar20 is not null and a.nvarchar8 is not null"; System.Data.SqlClient.SqlConnection conn = SqlHelper.Conn(); conn.Open(); var OaUsers = conn.Query(sqlUsers); foreach (var oaUser in OaUsers) { bool found = false; string loginname = oaUser.loginname; foreach (var systemUser in users) { if(loginname==systemUser.WorkNO) { found = true; systemUser.Email = oaUser.email; systemUser.Name = oaUser.name; } } if(found==false) { db.SystemUsers.Add(new SystemUser { Email = oaUser.email, Name = oaUser.name, Password = "******", WorkNO = loginname }); } db.SaveChanges(); } //找不到的账号禁用 users.ForEach(o => { if (o.Id > 1) { if ((from u in OaUsers where u.loginname == o.WorkNO select o.Id).ToList().Count == 0) { o.State = 1; } } }); db.SaveChanges(); var departments = (from o in db.Departments select o).ToList(); var sqlDepart =@"select a.nvarchar1 as company ,a.nvarchar3 as department ,a.nvarchar4 as subdepartment ,u1.tp_Title as submanager,u2.tp_Title as manager from AllUserData a join UserInfo u1 on a.int1=u1.tp_deleted --and u1.tp_Login like 'glcp%' join UserInfo u2 on a.int2=u2.tp_deleted --and u2.tp_Login like 'glcp%' where a.tp_ListId ='40394CC4-40A8-4B8F-BF08-068DB9E90FB7' "; var OaDeparts = conn.Query(sqlUsers); var q1 = (from o in OaDeparts select o.company).Distinct(); //公司一级 foreach (string o in q1) { bool found = false; foreach (var department in departments) { if(department.Name==o) { found = true; } } if(!found&&(!string.IsNullOrEmpty(o))) { db.Departments.Add(new Department {DepartmentType = "公司", Name = o, PId = 1}); } } db.SaveChanges(); //部门一级 departments = (from o in db.Departments select o).ToList(); var q2 = (from o in OaDeparts select new {company = o.company, department = o.department}).Distinct(); foreach (var o in q2) { bool found = false; Department parent = (from d in departments where d.Name == o.company select d).FirstOrDefault(); if(parent!=null) { foreach (var department in departments) { if(department.Name==o.department && department.PId==parent.Id) { found = true; } } } if(!found) { db.Departments.Add(new Department {DepartmentType = "部门", Name = o.department, PId = parent.Id}); } } db.SaveChanges(); //子部门一级 departments = (from o in db.Departments select o).ToList(); var q3 = (from o in OaDeparts select new {company = o.company, department = o.department, subdepartment = o.subdepartment}).Distinct(); foreach (var o in q3) { bool found = false; Department company = (from d in departments where d.Name == o.company select d).First(); Department department = (from d in departments where d.Name == o.department && d.PId == company.Id select d).First(); foreach (var dept in departments) { if(dept.Name==o.subdepartment )//-- 子部门名称唯一 && dept.PId==department.Id { found = true; } } if(!found) { db.Departments.Add(new Department {DepartmentType = "部门", Name = o.subdepartment, PId = department.Id}); } } db.SaveChanges(); //部门用户 departments = (from o in db.Departments select o).ToList(); users = (from o in db.SystemUsers select o).ToList(); var departUsers = (from o in db.DepartmentUsers select o).ToList(); foreach (var oaUser in OaUsers) { var dept = (from o in departments where o.Name == oaUser.subdepartment select o).First(); var user= (from o in users where o.WorkNO==oaUser.loginname select o).First(); var du = (from o in departUsers where o.DepartmentId == dept.Id && o.UserId == user.Id select o). FirstOrDefault(); if(du==null) { du=new DepartmentUser{DepartmentId = dept.Id,UserId = user.Id }; db.DepartmentUsers.Add(du); } if (oaUser.title != null && ((oaUser.title as string).Contains("经理") || (oaUser.title as string).Contains("领导"))) { du.IsManager = 1; } else { du.IsManager = 0; } var delList = (from o in departUsers where o.DepartmentId != dept.Id && o.UserId == user.Id select o).ToList(); delList.ForEach(o=>db.DepartmentUsers.Remove(o)); } db.SaveChanges(); return "OK"; }
private void ImportVisit(SqlConnection conn) { List<visitrecord> listVisitRecord = conn.Query<visitrecord>(visitrecord.sql).ToList(); int count = 0; OUContext db = new OUContext(); db.Configuration.ValidateOnSaveEnabled = false; db.Configuration.AutoDetectChangesEnabled = false; foreach (var record in listVisitRecord) { if (record.l_MemID == 0) continue; ShineConsume sc = new ShineConsume(); int asset = GetAsset(db, record.l_MsgID); sc.ShineType = "日晒机"; sc.AssetId = asset; sc.CardId = GetCard(db, record.l_MemID); if (record.l_PurchaseCerterID == 1) { sc.ChargeStoreId = 3; } else if (record.l_PurchaseCerterID == 2) { sc.ChargeStoreId = 4; } else { sc.ChargeStoreId = StoreId; } if (record.l_VisitCerterID == 1) { sc.StoreId = 3; } else if (record.l_VisitCerterID == 2) { sc.StoreId = 4; } else { sc.StoreId = StoreId; } sc.ConsumeTime = record.l_CreateTime; sc.Minutes = Convert.ToDecimal(record.l_SessionTime); sc.RelativeMinutes = Convert.ToDecimal(record.l_Minutes); sc.SalesId = 1; sc.Remark = record.l_VisitID.ToString(); db.ShineConsumes.Add(sc); count++; if (count%500 == 0) { db.SaveChanges(); } if (count%1000 == 0) { Console.WriteLine(string.Format("{0} {1} ", count, DateTime.Now)); //db = new OUContext(); //db.Configuration.ValidateOnSaveEnabled = false; //GC.Collect(); } } db.SaveChanges(); }
private void ImportPurchase(SqlConnection conn) { List<purchase> listPurchase = conn.Query<purchase>(purchase.sql).ToList(); using (OUContext db = new OUContext()) { db.Configuration.ValidateOnSaveEnabled = false; db.Configuration.AutoDetectChangesEnabled = false; foreach (var pur in listPurchase) { ProductSale p = new ProductSale(); p.StoreId = StoreId; p.SalesId = 1; p.Remark = pur.cnname + " " + pur.l_purchaseid.ToString(); int cardid = GetCard(db, pur.l_memid); p.CardId = cardid; p.Num = Convert.ToDecimal(pur.l_uints); if (p.Num == 0) p.Num = 1; p.Price = Convert.ToDecimal(pur.l_price); p.UnitPrice = p.Price/p.Num; if (pur.l_uints == 0f) { p.MarkPrice = Convert.ToDecimal(pur.l_grossprice); } else { p.MarkPrice = Convert.ToDecimal(pur.l_grossprice/pur.l_uints); } Product _product = GetProduct(db, pur.l_productid); if (_product != null) { p.ProductId = _product.Id; } p.SaleTime = pur.l_createtime; db.ProductSales.Add(p); try { db.SaveChanges(); if (_product.Catalog == "日晒时长") { ShineRecharge sr = new ShineRecharge(); sr.ChargeStoreId = StoreId; sr.CardId = cardid; sr.Minutes = p.Num; sr.RechargeTime = p.SaleTime; sr.SaleId = p.Id; sr.ShineType = "日晒机"; db.ShineRecharges.Add(sr); db.SaveChanges(); } } catch (Exception exp) { throw exp; } } //} //transcope.Complete(); } Console.WriteLine(DateTime.Now.ToLongTimeString()); }
private void ImportProduct(TransactionScopeOption option, SqlConnection conn) { using (TransactionScope transcope = new TransactionScope(option, TimeSpan.FromMinutes(5))) { using (OUContext db = new OUContext()) { db.Configuration.ValidateOnSaveEnabled = false; List<megasun> listMegasun = conn.Query<megasun>(megasun.sql).ToList(); foreach (var mega in listMegasun) { Asset asset = new Asset(); asset.AssetType = "日晒机"; asset.Name = mega.l_mgsname + " " + mega.l_roomnum; asset.Rate = Convert.ToDecimal(mega.l_usage); asset.StoreId = StoreId; asset.Remark = mega.l_mgsid.ToString(); db.Assets.Add(asset); } db.SaveChanges(); List<product> listProduct = conn.Query<product>(product.sql).ToList(); foreach (var prod in listProduct) { Product p = new Product(); p.Name = prod.l_productname; p.UnitPrice = Convert.ToDecimal(prod.l_productprice); p.StoreId = StoreId; p.Remark = prod.l_productid.ToString(); switch (prod.l_typename) { case "Minute": p.Catalog = "日晒时长"; if (prod.l_productname.Contains("单次")) p.Catalog = "单次日晒"; break; case "Health": p.Catalog = "健康产品"; break; case "Lotion": p.Catalog = "护肤液"; break; case "Cloth": p.Catalog = "服装"; break; } db.Products.Add(p); } db.SaveChanges(); transcope.Complete(); } } Console.WriteLine(DateTime.Now.ToLongTimeString()); }
private void ImportCustomer(SqlConnection conn) { using (TransactionScope transcope = new TransactionScope()) { using (OUContext db = new OUContext()) { db.Configuration.ValidateOnSaveEnabled = false; db.Configuration.AutoDetectChangesEnabled = false; List<customer> listCustomer = conn.Query<customer>(customer.sql).ToList(); foreach (var cust in listCustomer) { Card card = new Card(); card.StoreId = StoreId; card.ActiveDate = cust.l_createtime; card.Birthday = cust.l_birth; card.CardCode = "旧"+cust.l_memnum; card.OldCode = cust.l_memnum; card.CardId = "旧"+cust.l_cardnum; switch (cust.l_membergradeid) { case 1: card.CardType = "普通卡"; break; case 2: card.CardType = "金卡"; break; case 3: card.CardType = "白金卡"; break; } string email = cust.l_email1; if (string.IsNullOrEmpty(cust.l_email1)) { email = cust.l_email2; } else if (string.IsNullOrEmpty(cust.l_email2) == false) { email += " " + cust.l_email2; } card.Email = email; if (cust.l_sex == "女" || cust.l_sex == "F") { card.Gender = GenderEnum.女; } else { card.Gender = GenderEnum.男; } string tel = ""; if (!string.IsNullOrEmpty(cust.l_hometel)) { tel = cust.l_hometel; } if (!string.IsNullOrEmpty(cust.l_officetel)) { tel += " " + cust.l_officetel; } if (!string.IsNullOrEmpty(cust.l_othertel)) { tel += " " + cust.l_othertel; } card.Mobile = cust.l_mobile; card.Phone = tel; card.Remark = cust.l_standby; card.OldSpendTotal = Convert.ToDecimal(cust.l_spenttotal); switch (cust.l_status) { case 1: card.State = ClientState.正常; break; case 2: card.State = ClientState.冻结; break; case 3: card.State = ClientState.失效; break; } string name = string.Format("{0} {1} {2} {3} {4}", cust.l_givenname, cust.l_surname, cust.l_mandaringivenname, cust.l_mandarinsurname, string.IsNullOrEmpty(cust.l_spousename) ?"": string.Format("({0})", cust.l_spousename) ); card.UserName = name; db.Cards.Add(card); db.SaveChanges(); } } transcope.Complete(); } Console.WriteLine(DateTime.Now.ToLongTimeString()); }
private void ImportCardMinutes(SqlConnection conn) { OUContext db; List<cardminute> listCardMinutes = conn.Query<cardminute>(cardminute.sql).ToList(); db = new OUContext(); db.Configuration.ValidateOnSaveEnabled = false; db.Configuration.AutoDetectChangesEnabled = false; foreach (var cardMinute in listCardMinutes) { CardMinute cm = new CardMinute(); if (cardMinute.l_memNum != null) { int memid = int.Parse(cardMinute.l_memNum); cm.CardId = GetCard(db, memid); } cm.Minutes = Convert.ToDecimal(cardMinute.l_balanceminutes); if (cardMinute.l_centerID == 1) { cm.StoreId = 3; } else if (cardMinute.l_centerID == 2) { cm.StoreId = 4; } else if (cardMinute.l_centerID == 3) { cm.StoreId = 2; } cm.oldId = Convert.ToInt16(cardMinute.l_Minuteid); db.CardMinutes.Add(cm); db.SaveChanges(); } }
/// <summary> /// 修改密码或用户名时候调用。调用时password应该是加密前password /// </summary> /// <param name="db"></param> /// <returns></returns> public bool Save(OUContext db) { Name = Name.Trim(); int count = db.Database.SqlQuery<int>("select count(1) from systemusers where id!={0} and (name={1} )", Id, Name).FirstOrDefault(); if (count > 0) { return false; } Password = EncryptPassword(Name.ToLower(), Password); if (Id == 0) db.SystemUsers.Add(this); db.SaveChanges(); return true; }
public string RequestImportItem(OUContext db, string code, int foodId, decimal num, DateTime date, string remark, string action) { FoodMaterialRequest req = (from o in db.FoodMaterialRequests where o.Code == code select o).FirstOrDefault(); if (action == "删除") { if (req == null) return "找不到可以删除的申请"; if (req.TypeId != foodId) return "要删除的记录与原记录不匹配,原料不同"; if(req.State!=(int)FoodMaterialRequestState.未提交)return "要删除的记录状态不允许删除"; req.State = (int)FoodMaterialRequestState.作废; db.SaveChanges(); return ""; } if (action == "修改") { if (req == null) return "找不到可以修改的申请"; if (req.TypeId != foodId) return "要修改的记录与原记录不匹配,原料不同"; if(req.State!=(int)FoodMaterialRequestState.未提交)return "要修改的记录状态不允许修改"; } if (req == null) { req = new FoodMaterialRequest(); db.FoodMaterialRequests.Add(req); req.Code = code; req.TypeId=foodId; } req.Num = num; req.OrderDate = date; req.Remark = remark; req.PersonId = UserInfo.CurUser.Id; req.RequestTime = DateTime.Now; db.SaveChanges(); return ""; }