public int DeleteCharge(string sysno)
 {
     CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("DeleteCharge");
     command.CommandText = command.CommandText.Replace("#SysNo#", sysno);
     int result = command.ExecuteNonQuery();
     if (result > 0)
     {
         FilesDataAccess fda = new FilesDataAccess();
         fda.DeleteFilesByFSysNos(sysno);
     }
     return result;
 }
 public int UpdateCharge(ChargeEntity entity)
 {
     CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("UpdateCharge");
     command.SetParameterValue("@SysNo", entity.SysNo);
     command.SetParameterValue("@Title", entity.Title);
     command.SetParameterValue("@Remark", entity.Remark);
     command.SetParameterValue("@Content", entity.Content);
     command.SetParameterValue("@Field1", entity.Field1);
     command.SetParameterValue("@Field2", entity.Field2);
     command.SetParameterValue("@Field3", entity.Field3);
     command.SetParameterValue("@Field4", entity.Field4);
     command.SetParameterValue("@Field5", entity.Field5);
     command.SetParameterValue("@Status", entity.Status);
     command.SetParameterValue("@InUser", entity.InUser);
     command.SetParameterValue("@InDate", entity.InDate);
     int result = command.ExecuteNonQuery();
     if (result > 0)
     {
         FilesDataAccess fda = new FilesDataAccess();
         fda.DeleteFilesByFSysNo(entity.SysNo);
         entity.Files.ForEach(x =>
         {
             new FilesDataAccess().InsertFiles(x);
         });
     }
     return result;
 }