/// <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);
}
