/// <summary>
/// 根据参数更新工作人员
/// </summary>
/// <param name="officersName">姓名</param>
/// <param name="officers">工作人员</param>
internal void UpdateOfficersByArgs(Officers officers)
{
if (officers.OfficersName == "")
return;
Officers databaseOfficers = null;
SelectSqlSection section = DB.Select(DataBases.Officers).Where(DataBases.Officers.OfficersName == officers.OfficersName);
if (officers.CID != "" && officers.OfficersName != "")
section.Where(DataBases.Officers.CID == officers.CID);
else if (officers.Position != "" && officers.OfficersName != "")
section.Where(DataBases.Officers.Position == officers.Position);
using (IDataReader reader = section.ToDataReader())
{
if (reader.Read())
{
databaseOfficers = ReadRow(reader);
}
}
if (databaseOfficers != null)
{
if (officers.CID != "")
databaseOfficers.CID = officers.CID;
if (officers.OfficersName != "")
databaseOfficers.OfficersName = officers.OfficersName;
if (officers.Position != "")
databaseOfficers.Position = officers.Position;
if (officers.Unit != "")
databaseOfficers.Unit = officers.Unit;
databaseOfficers.SystemService = this.SystemService;
databaseOfficers.SQLtransaction = this.SQLtransaction;
databaseOfficers.Update();
}
else
{
officers.SystemService = this.SystemService;
officers.SQLtransaction = this.SQLtransaction;
officers.Update();
}
}
