/// <summary> /// 注册用户 /// <param name="User">用户注册资料</param> /// <param name="UserEX">用户附加详细资料</param> /// </summary> /// <returns></returns> public bool UserReg(User_ViewModel User, aspnet_UsersEX UserEX) { String guid = Guid.NewGuid().ToString(); User = User ?? new User_ViewModel() { UserName = guid, UserPassword = guid, Email = "", Answer = "no", Question = "no" }; MembershipCreateStatus state = new MembershipCreateStatus(); MembershipUser Temp_User = Membership.CreateUser(User.UserName, User.UserPassword, User.Email, User.Question, User.Answer, false, out state); if (state == MembershipCreateStatus.Success) { UserEX.User_ID = (Guid)Temp_User.ProviderUserKey; } else { return(false); } if (!DB_UserEX.Insert(UserEX)) { Membership.DeleteUser(Temp_User.UserName); } else { Roles.AddUserToRole(User.UserName, "普通会员"); } return(true); }
/// <summary> /// 删除所有的过期订单 /// </summary> /// <returns></returns> public int Delete_OverTime(int ShopID) { TimeSpan TS_Now = new TimeSpan(DateTime.Now.Ticks); List <Car_Order> List_CarOrder = DB_CarOrder.Select(P => new TimeSpan(P.Order_Time.Ticks).Subtract(TS_Now).Duration().Days >= 2 && P.Order_Shop == ShopID).ToList(); List <Car_Checkout> List_Check = new List <Car_Checkout>(); foreach (Car_Order temp in List_CarOrder) { List_Check.Add(DB_Checkout.Select(P => P.Checkout_Order == temp.Order_ID).SingleOrDefault()); } if (DB_Checkout.Delete_ALL(List_Check)) { foreach (Car_Order temp in List_CarOrder) { DB_CarOrder.Delete(temp); } return(List_Check.Count()); } else { foreach (Car_Checkout Temp in List_Check) { DB_Checkout.Insert(Temp); } return(0); } }
/// <summary> /// 添加员工到一个店铺 /// </summary> /// <param name="UserID">用户ID</param> /// <param name="ShopID">店铺ID</param> /// <returns></returns> public bool UserPutInShop(Guid UserID, int ShopID) { return(DB_UserInShop.Insert(new UserInShop() { UserID = UserID, ShopID = ShopID })); }
/// <summary> /// 新增店铺信息 /// </summary> /// <param name="Shop">要增加的店铺实体</param> /// <returns></returns> public bool AddShop(Car_Shop Shop) { if (DB_Shop.Select(P => P.Shop_Name == Shop.Shop_Name && P.Shop_City == Shop.Shop_City).Count() == 0) { return(DB_Shop.Insert(Shop)); } else { return(false); } }
/// <summary> /// 新增城市信息 /// </summary> /// <param name="City">要增加的城市实体</param> /// <returns></returns> public bool AddCity(Car_City City) { if (DB_City.Select(P => P.City_Name == City.City_Name && P.City_Province == City.City_Province).Count() == 0) { return(DB_City.Insert(City)); } else { return(false); } }
/// <summary> /// 领工资 /// </summary> /// <param name="SalaryLogID">工资单号</param> /// <returns></returns> public bool GetSalary(int SalaryLogID, Guid UID, String RealName, decimal Price) { User_SalaryLog OldLog = DB_SalaryLog.Select(P => P.SalaryLog_ID == SalaryLogID).SingleOrDefault(); User_SalaryLog NewLog = OldLog; NewLog.SalaryLog_Mark = true; UserManager s = new UserManager(); int ShopID = s.SelectShopID_UserID(OldLog.SalaryLog_User); using (TransactionScope TS = new TransactionScope()) { try { DB_Account.dt = DB_SalaryLog.dt; DB_Account.Insert_NoSub(new Car_Account() { Account_Info = String.Format("这笔款项属于工资发放,店铺编号:{0},工资领取人:{1},工资领取时间:{2}", ShopID, RealName, DateTime.Now), Account_Price = Price, Account_Shop = ShopID, Account_Time = DateTime.Now, Account_User = UID }); DB_SalaryLog.Update_NoSub(OldLog, NewLog); DB_SalaryLog.dt.SubmitChanges(); TS.Complete(); return(true); } catch (Exception EX) { DB_Error.Insert(new Error() { Error_Messege = EX.Message, Error_Time = DateTime.Now }); return(false); } } }
/// <summary> /// 新增工资领取状况信息 /// </summary> /// <param name="SalaryLog">要增加的工资领取状况实体</param> /// <returns></returns> public bool AddSalaryLog(User_SalaryLog SalaryLog) { return(DB_SalaryLog.Insert(SalaryLog)); }
/// <summary> /// 新增员工工资情况信息 /// </summary> /// <param name="Salary">要增加的员工工资情况实体</param> /// <returns></returns> public bool AddSalary(User_Salary Salary) { return(DB_Salary.Insert(Salary)); }
/// <summary> /// 新增员工奖惩方案信息 /// </summary> /// <param name="RAP">要增加的员工奖惩方案实体</param> /// <returns></returns> public bool AddRAP(User_RAP RAP) { return(DB_RAP.Insert(RAP)); }
/// <summary> /// 新增订单信息 /// </summary> /// <param name="Order">要增加的订单实体</param> /// <returns></returns> public bool AddOrder(Car_Order Order) { return(DB_Order.Insert(Order)); }
/// <summary> /// 新增活动信息 /// </summary> /// <param name="Action">要增加的活动实体</param> /// <returns></returns> public bool AddAction(Car_Action Action) { DB_Action.Insert(Action); return(DB_Action.SubmitChanges()); }
/// <summary> /// 新增车型信息 /// </summary> /// <param name="Type">要增加的车型实体</param> /// <returns></returns> public bool AddType(Car_Type Type) { return(DB_Type.Insert(Type)); }
/// <summary> /// 新增资金变动信息 /// </summary> /// <param name="Account">要增加的资金变动实体</param> /// <returns></returns> public bool AddAccount(Car_Account Account) { return(DB_Account.Insert(Account)); }
/// <summary> /// 新增员工制度奖惩情况信息 /// </summary> /// <param name="WorkRAP">要增加的员工制度奖惩情况实体</param> /// <returns></returns> public bool AddWorkRAP(User_WorkRAP WorkRAP) { return(DB_WorkRAP.Insert(WorkRAP)); }
/// <summary> /// 新增收款单信息 /// </summary> /// <param name="Checkout">要增加的收款单实体</param> /// <returns></returns> public bool AddCheckout(Car_Checkout Checkout) { return(DB_Checkout.Insert(Checkout)); }
/// <summary> /// 新增省份信息 /// </summary> /// <param name="province">要增加的省份实体</param> /// <returns></returns> public bool AddProvince(Car_Province province) { return(DB_Province.Insert(province)); }
/// <summary> /// 新增活动信息 /// </summary> /// <param name="Action">要增加的活动实体</param> /// <returns></returns> public bool AddAction(Car_Action Action) { return(DB_Action.Insert(Action)); }
/// <summary> /// 新增员工额外奖惩情况信息 /// </summary> /// <param name="SalaryAppend">要增加的员工额外奖惩情况实体</param> /// <returns></returns> public bool AddSalaryAppend(User_SalaryAppend SalaryAppend) { return(DB_SalaryAppend.Insert(SalaryAppend)); }
/// <summary> /// 新增资金变动信息 /// </summary> /// <param name="CarGet">要增加的资金变动实体</param> /// <returns></returns> public bool AddCarGet(Car_Get CarGet) { return(DB_CarGet.Insert(CarGet)); }
/// <summary> /// 新增车名信息 /// </summary> /// <param name="Version">要增加的车名实体</param> /// <returns></returns> public bool AddVersion(Car_Version Version) { return(DB_Version.Insert(Version)); }
/// <summary> /// 新增品牌信息 /// </summary> /// <param name="Brand">要增加的品牌实体</param> /// <returns></returns> public bool AddBrand(Car_Brand Brand) { return(DB_Brand.Insert(Brand)); }