/// <summary> /// 更改工资领取状况信息 /// </summary> /// <param name="New_SalaryLog">新的工资领取状况实体</param> /// <returns></returns> public bool UpdateSalaryLog(User_SalaryLog TempSalaryLog) { User_SalaryLog OldSalaryLog = DB_SalaryLog.Select(P => P.SalaryLog_ID == TempSalaryLog.SalaryLog_ID).Single(); User_SalaryLog NewSalaryLog = OldSalaryLog; NewSalaryLog.SalaryLog_Mark = TempSalaryLog.SalaryLog_Mark; NewSalaryLog.SalaryLog_Time = TempSalaryLog.SalaryLog_Time; NewSalaryLog.SalaryLog_User = TempSalaryLog.SalaryLog_User; return(DB_SalaryLog.Update(OldSalaryLog, NewSalaryLog)); }
/// <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 DeleteSalaryLog(int SalaryLogID) { User_SalaryLog SL = DB_SalaryLog.Select(P => P.SalaryLog_ID == SalaryLogID).Single(); return(DB_SalaryLog.Delete(SL)); }
/// <summary> /// 新增工资领取状况信息 /// </summary> /// <param name="SalaryLog">要增加的工资领取状况实体</param> /// <returns></returns> public bool AddSalaryLog(User_SalaryLog SalaryLog) { return(DB_SalaryLog.Insert(SalaryLog)); }