/// <summary> /// 修改入离职信息 /// </summary> /// <param name="entry"></param> /// <returns></returns> public int UpdateEntryDimissionRecord(EntryDimissionRecord entry) { using (MySqlConnection conn = DapperHelper.GetConnString()) { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@OperationType", entry.OperationType, null, null, null); parameters.Add("@DatesEmployed", entry.DatesEmployed, null, null, null); parameters.Add("@DepartureTime", entry.DepartureTime, null, null, null); parameters.Add("@ModificationTime", entry.ModificationTime, null, null, null); parameters.Add("@IsDelete", entry.IsDelete, null, null, null); parameters.Add("@Id", entry.PersonnelId, null, null, null); string sql = "update entrydimissionrecord set OperationType=@OperationType,DatesEmployed=@DatesEmployed,DepartureTime=@DepartureTime,ModificationTime=@ModificationTime,IsDelete=@IsDelete where PersonnelId=@Id"; int i = conn.Execute(sql, parameters); return(i); } }
/// <summary> /// 添加入离职信息 /// </summary> /// <param name="entry"></param> /// <returns></returns> public int AddEntryDimissionRecord(EntryDimissionRecord entry) { using (MySqlConnection conn = DapperHelper.GetConnString()) { entry.ModificationTime = System.DateTime.Now; DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Name", entry.Name, null, null, null); parameters.Add("@PersonnelId", entry.PersonnelId, null, null, null); parameters.Add("@OperationType", entry.OperationType, null, null, null); parameters.Add("@DatesEmployed", entry.DatesEmployed, null, null, null); parameters.Add("@DepartureTime", entry.DepartureTime, null, null, null); parameters.Add("@CreationTime", entry.CreationTime, null, null, null); parameters.Add("@ModificationTime", entry.ModificationTime, null, null, null); parameters.Add("@IsDelete", entry.IsDelete, null, null, null); string sql = "insert into entrydimissionrecord(Name,PersonnelId,OperationType,DatesEmployed,DepartureTime,CreationTime,ModificationTime,IsDelete) VALUES(@Name,@PersonnelId,@OperationType,@DatesEmployed,@DepartureTime,@CreationTime,@ModificationTime,@IsDelete)"; int i = conn.Execute(sql, parameters); return(i); } }
public int UpdateEntryDimissionRecord(EntryDimissionRecord entry) { int i = entryDimission.UpdateEntryDimissionRecord(entry); return(i); }
public int AddEntryDimissionRecord(EntryDimissionRecord entry) { int i = entryDimission.AddEntryDimissionRecord(entry); return(i); }